Re: postgres operational
Ron <ronljohnsonjr@gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2019-01-09T20:38:48Z
Lists: 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.