Raspberry PI 2 + postgresql

[wonko69]

Hi,

Since I moved my TT-RSS install (exported my opml file, but installed nginx, php and postgresql on raspberian Jessie) I'm getting a lot of segfaults on the postgresql.

Specially "was terminated by signal 11: Segmentation fault" but about ½ of the ram is free and none of the CPU's are maxed out.

The PI is not overclocked either. So I'm posting there in the hope that someone has a fix for this?

[QBall1977]

I had a similar problem. Been using Raspian (Wheezy) for a long time with Postgresql, but after some issues I ended up flashing the card and trying with Jessie. EVERY time I try running it with POSTGRESQL I get faults and errors. Tried this 3 times, always the same result, corrupt DB.

Sad to say I started again with a MySQL DB and currently (touch-wood) everything seems to be running fine, with minimal loss to performance.

I generally access the TTRSS through the TTRSS2 app on my iPhone (4S) and 3G! My feeds on the move!

Sorry it wasn't better news.

[wonko69]

Thanks for the reply.
What I ended up doing was reverting to Wheezy where postgresql ran without any issues. And now that Jessie is stable I have upgraded to that and everything is still spinning thank fully.
So what I'm thinking was the issue was actually the way my image was setup, because I run a lean distro and remove all the X stuff since my pi2 is a server not a workstation.

Oh yeah and always remember to backup 3-2-1