Postgres service startup

From: M S <arthur_ringworn(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres service startup
Date: 2007-08-06 10:44:09
Message-ID: 389914.72469.qm@web25005.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I'm getting errors in my application which suggest that Postgres has not completely started
when it has told the Windows Service Control Manager that is has.

Postgres log file extracts which (I believe) support this are shown below:

2007-08-06 10:27:42 LOG: database system was shut down at 2007-08-06 09:55:16 GMT Daylight Time
2007-08-06 10:27:42 LOG: checkpoint record is at 0/29C8BE0
2007-08-06 10:27:42 LOG: redo record is at 0/29C8BE0; undo record is at 0/0; shutdown TRUE
2007-08-06 10:27:42 LOG: next transaction ID: 0/1881853; next OID: 21761
2007-08-06 10:27:42 LOG: next MultiXactId: 46; next MultiXactOffset: 91
2007-08-06 10:27:42 LOG: database system is ready
2007-08-06 10:27:56 FATAL: the database system is starting up
2007-08-06 10:27:57 FATAL: the database system is starting up
2007-08-06 10:27:57 FATAL: the database system is starting up
2007-08-06 10:27:57 FATAL: the database system is starting up

The fatal errors generated by our app have a later timestamp than the message "database system is ready".

Looking in the registry for the service start options, pg_ctl.exe is being called with the runserver argument (which I can't find documented anywhere I'm afraid).
I have tried adding a -w switch but it prevented the service from starting.

Has anyone got any suggestions?

___________________________________________________________
Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for
your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2007-08-06 11:07:08 Re: Postgres service startup
Previous Message Alain Roger 2007-08-06 10:37:00 import content of XLS file into PostgreSQL