On Tue, Aug 6, 2013 at 7:56 AM, edlef <edlef@xxxxxxxxxxx> 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 and > reindexed everything, but it looks, nothing has changed. > > Server data: > Windows Standard Server 2007 SP2 64 bit > Intel Xeon 3GHz > 4MB ram > > Postgresql 8.2 32 bit > > The application is writen in php. > > > I paste here the logs for one day: > > postgresql-2013-08-05_044313.log: > 2013-08-05 04:43:13 FATAL: the database system is starting up > 2013-08-05 04:43:13 LOG: database system was interrupted at 2013-08-04 > 21:17:08 > 2013-08-05 04:43:13 LOG: checkpoint record is at A/C07BA3D0 > 2013-08-05 04:43:13 LOG: redo record is at A/C07BA3D0; undo record is at SNIP > I hope somebody has an idea how I can correct it. > Thanks for the help! We need to see what happens BEFORE the database was starting back up. I.e. what caused it to shut down / restart / crash etc. The fact that it's starting back up after a crash doesn't tell us much. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
