Re: Monitor Postgres database status on Docker

[Olivier Gautherot <ogautherot@xxxxxxxxxxxxx>]

Hi Daulat,

El mar., 24 de septiembre de 2019 07:05, Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx> escribió:

Thanks but how we can use it for docker container.

You have basically 2 ways:

1) Publish the port 5432 on the container and access it from the host, or

2) Use "docker exec" to run the commands natively inside the 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