Postgres service startup - Mailing list pgsql-general

From M S
Subject Postgres service startup
Date
Msg-id 389914.72469.qm@web25005.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: Postgres service startup  (Dave Page <dpage@postgresql.org>)
List 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'tfind 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

pgsql-general by date:

Previous
From: "Alain Roger"
Date:
Subject: import content of XLS file into PostgreSQL
Next
From: Dave Page
Date:
Subject: Re: Postgres service startup