Re: Service startup delay
Bruce Momjian <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
Barry Lind wrote: > We are incorporating the win32 port into our product, and have run into > a problem with the timing of the startup of the windows service. What > is happening is that we have setup a dependency between our service and > the postgres service so that our service starts after the postgres one. > However this sometimes still fails, as it appears the postgres service > returns control to windows before the database is actually fully started > and ready to accept connections as we are getting an error in our app > (org.postgresql.util.PSQLException: A connection error has occurred: > org.postgresql.util.PSQLException: FATAL: the database system is > starting up). Can this be fixed? We can hack around this in our code, > but it would be nice (and I am sure others will run into this as well) > if this was fixed properly in the postgres service itself. I think you need to use 'pg_ctl -w' to wait for it to start. -- Bruce Momjian | http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [email protected]