Horton

Re: postgres operational

Martín Marqués <martin@2ndquadrant.com>

View thread View on postgr.es
From: Martín Marqués <martin@2ndquadrant.com>
To: Steve Clark <steve.clark@netwolves.com>, pgsql <pgsql-general@postgresql.org>
Date: 2019-01-09T18:19:46Z
Lists: pgsql-general 
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`


-- 
Martín Marqués                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services