Re: postgres operational

Поиск
Список
Период
Сортировка
От Martín Marqués
Тема Re: postgres operational
Дата
Msg-id 31cd6071-8ea5-a29d-ec77-c158a087d2b5@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: postgres operational  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
El 9/1/19 a las 17:38, Ron escribió:
> 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?

Depends on what you are expecting.

`check_postgres` has many different checks, one which will actually try
to connect and run `SELECT 1` to make sure postgres can actually run a
query.

pg_ctl status might return ok, yet you can't connect for other reasons.


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


В списке pgsql-general по дате отправления:

Предыдущее
От: Martín Marqués
Дата:
Сообщение: Re: Pulling data from Postgres DB table for every 5 seconds.
Следующее
От: Aidan Samuel
Дата:
Сообщение: CREATE OR REPLACE MATERIALIZED VIEW