Re: [GENERAL] postgre restarts in short period

2013-08-06 Thread edlef
keltezéssel, Adrian Klaver írta: On 08/06/2013 06:56 AM, edlef wrote: Hi, Our client has began to complain for a few days that the application can not connect to the database more times. I looked into the logs and as far as I can see, postgresql restarts more times a day. I made a vacuum (full, freeze

Re: [GENERAL] postgre restarts in short period

2013-08-06 Thread edlef
( mj.mintajellegid = m.mintajellegid ) where m.status IN and m.mintajellegid = and m.partnerid = there should be 'm.mintajellegid = and m.partnerid = ' but this should not be the cause of the rather heavy database system crash On Tue, Aug 6, 2013 at 3:56 PM, edlef

[GENERAL] postgre restarts in short period

2013-08-06 Thread edlef
Hi, Our client has began to complain for a few days that the application can not connect to the database more times. I looked into the logs and as far as I can see, postgresql restarts more times a day. I made a vacuum (full, freeze, analyze) on the database and reindexed everything, but it lo