RE: Monitor Postgres database status on Docker

Hi Fan Liu,

I am able to make the connection to the Postgres database created in docker container via psql from postgres10 client but not able to connect through pg_isready.

psql -c 'select count (*) from pg_stat_activity' -h localhost -p 5432 -U postgres -W
Password for user postgres:
count
-------
7

Give me suggestions.
Thanks,

From: Daulat Ram
Sent: Tuesday, September 24, 2019 3:35 PM
To: Fan Liu <fan(dot)liu(at)ericsson(dot)com>; pgsql-general(at)lists(dot)postgresql(dot)org
Subject: RE: Monitor Postgres database status on Docker

Thanks but how we can use it for docker container.

Regards,
Daulat

From: Fan Liu <fan(dot)liu(at)ericsson(dot)com<mailto:fan(dot)liu(at)ericsson(dot)com>>
Sent: Tuesday, September 24, 2019 3:02 PM
To: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com<mailto:Daulat(dot)Ram(at)exponential(dot)com>>; pgsql-general(at)lists(dot)postgresql(dot)org<mailto:pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: Monitor Postgres database status on Docker

Hi,

I am not from PostgreSQL team.
Just let you know that when we run PostgreSQL in Kubernetes, we use below command for liveness check.

pg_isready --host localhost -p $PG_PORT -U $PATRONI_SUPERUSER_USERNAME

BRs,
Fan Liu

From: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com<mailto:Daulat(dot)Ram(at)exponential(dot)com>>
Sent: Tuesday, September 24, 2019 5:18 PM
To: pgsql-general(at)lists(dot)postgresql(dot)org<mailto:pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Monitor Postgres database status on Docker

Hi team,

We want to check the postgres database status on docker container just like we monitor Postgres (up / down) via /etc/init.d/postgresql status

But I am not sure how we can do that with docker.

Thanks,
Daulat