RE: Monitor Postgres database status on Docker

[Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx>]

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.liu@xxxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx
Subject: RE: Monitor Postgres database status on Docker

 

Thanks but how we can use it for docker container.

 

Regards,

Daulat

 

From: Fan Liu <fan.liu@xxxxxxxxxxxx>
Sent: Tuesday, September 24, 2019 3:02 PM
To: Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx
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.Ram@xxxxxxxxxxxxxxx>
Sent: Tuesday, September 24, 2019 5:18 PM
To: pgsql-general@xxxxxxxxxxxxxxxxxxxx
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