Re: [GENERAL] postgre restarts in short period

2013-08-06 Thread Scott Marlowe
On Tue, Aug 6, 2013 at 8:45 AM, edlef wrote: > Hi, > > I looked into other log files, but there is no regularity. I found intervals > when it restarted 2-3 time in a hour. > What I pasted was a full days log entrys, they were not snipets. There are > no entries about the shot down. > I try to find

Re: [GENERAL] postgre restarts in short period

2013-08-06 Thread Adrian Klaver
On 08/06/2013 07:45 AM, edlef wrote: Hi, I looked into other log files, but there is no regularity. I found intervals when it restarted 2-3 time in a hour. What I pasted was a full days log entrys, they were not snipets. There are no entries about the shot down. I try to find when it all began.

Re: [GENERAL] postgre restarts in short period

2013-08-06 Thread edlef
Hi, I looked into other log files, but there is no regularity. I found intervals when it restarted 2-3 time in a hour. What I pasted was a full days log entrys, they were not snipets. There are no entries about the shot down. I try to find when it all began. fenor 2013.08.06. 16:32 keltezéss

Re: [GENERAL] postgre restarts in short period

2013-08-06 Thread Scott Marlowe
On Tue, Aug 6, 2013 at 7: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, analyze

Re: [GENERAL] postgre restarts in short period

2013-08-06 Thread Adrian Klaver
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, analyze) on the database

Re: [GENERAL] postgre restarts in short period

2013-08-06 Thread edlef
yes, I knew that, but thanks! 2013.08.06. 16:03 keltezéssel, Klaus Ita írta: well, in your statement, the parameters are missing. 2013-08-05 10:18:01 STATEMENT: select distinct count(*) as rownum from minta as m join partner as p on ( m.partnerid = p.partnerid ) join mintajelleg as mj on

Re: [GENERAL] postgre restarts in short period

2013-08-06 Thread Adrian Klaver
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, analyze) on the database

Re: [GENERAL] postgre restarts in short period

2013-08-06 Thread Klaus Ita
well, in your statement, the parameters are missing. 2013-08-05 10:18:01 STATEMENT: select distinct count(*) as rownum from minta as m join partner as p on ( m.partnerid = p.partnerid ) join mintajelleg as mj on ( mj.mintajellegid = m.mintajellegid ) where m.status IN and m.mintajellegid =

[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