Re: Checking that Pg is running from a shell script

Can pg_ctl across the network? I'd like my middleware server to know
if my postgres db is up and running OK. I guess I could just make a
db connection but I was hoping for a more elegant solution.
Thanks.

Fran Fabrizio wrote:
> Lamar Owen wrote:
>
>> On Monday 10 June 2002 10:29 am, Fran Fabrizio wrote:
>>
>>
>>> What's the best way to ensure that Pg is running from a shell script?
>>> I'm crafting a few RPMs for my projects, one of which will attempt to
>>> load data into a database, but I want to check that it's running first
>>> before I try this
>>>
>> See the man page for pg_ctl. There is, IIRC, a status option, but you
>> have to know the location of PGDATA (which, in a vanilla RPM install
>> is /var/lib/pgsql/data).
>>
>>
>
> Thanks all, the pg_ctl -D /var/lib/pgsql/data status should be
> sufficient for my needs.
>
> -Fran
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Vincent Stoessel
Linux Systems Developer
vincent xaymaca.com