Re: postgres operational - Mailing list pgsql-general

From Ron
Subject Re: postgres operational
Date
Msg-id 1945c175-0c31-b030-5d52-6535c7f9a5d6@gmail.com
Whole thread Raw
In response to Re: postgres operational  (Martín Marqués <martin@2ndquadrant.com>)
Responses Re: postgres operational
List pgsql-general
On 1/9/19 12:19 PM, Martín Marqués wrote:
> El 9/1/19 a las 14:58, Steve Clark escribió:
>> Hi List,
>>
>> Is there a sure fire way to tell if postgres server is up an operational. I was testing to see if the
>> socket at /tmp/.s.PGSQL.5432 existed - but I ran into a recent problem on CentOS 7.5, postgresql 9.2.24, where the
>> socket was there but my script couldn't read from my database yet.
> Use `check_postgres`

Isn't "pg_ctl status" the canonical method?


-- 
Angular momentum makes the world go 'round.


pgsql-general by date:

Previous
From: Mark Fletcher
Date:
Subject: Re: Pulling data from Postgres DB table for every 5 seconds.
Next
From: github kran
Date:
Subject: Re: Pulling data from Postgres DB table for every 5 seconds.