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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
