From: | Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Sean Chittenden <sean(at)chittenden(dot)org>, Joel Rees <joel(at)alpsgiken(dot)gr(dot)jp>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pgsql password when FreeBSD boots -- what's usual? |
Date: | 2003-04-03 18:47:13 |
Message-ID: | 3E8C81B1.5090908@intransa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In my application, I do the following before saying "ok db is up"
1- Look for the PID, that tells me postmaster at least is a process and
has an ID
2- Check /proc/pid
3- Connect to template-1
4- Connect to MyDatabase
5- Query something,
That tells me that all parts are working....
By the way, does the '-w' on start gives up in 60 seconds or
indefinitely blocks...
Tom Lane wrote:
>Sean Chittenden <sean(at)chittenden(dot)org> writes:
>
>
>>I personally find the behavior of pg_ctl connecting to the postmaster
>>_after_ it's started up to verify that it has indeed started up, to be
>>a rather broken behavior and think that it shouldn't be the default.
>>
>>
>
>?? It isn't.
>
>I agree that we could do with a better mechanism, though.
>
> regards, tom lane
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GUNDUZ | 2003-04-03 18:53:06 | Re: [NOVICE] Postgres Syslog |
Previous Message | Dennis Gearon | 2003-04-03 18:38:25 | Re: [GENERAL] Suggestion |