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 <[email protected]>; [email protected]
Subject: RE: Monitor Postgres database status on Docker

Thanks but how we can use it for docker container.

Regards,
Daulat

From: Fan Liu <[email protected]<mailto:[email protected]>>
Sent: Tuesday, September 24, 2019 3:02 PM
To: Daulat Ram <[email protected]<mailto:[email protected]>>; [email protected]<mailto:[email protected]>
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 <[email protected]<mailto:[email protected]>>
Sent: Tuesday, September 24, 2019 5:18 PM
To: [email protected]<mailto:[email protected]>
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