Re: Monitor Postgres database status on Docker - Mailing list pgsql-general

From Olivier Gautherot
Subject Re: Monitor Postgres database status on Docker
Date
Msg-id CAJ7S9TVupf_8nuRdHk3KM4fTJX-_XVwU--qpNMPKgf-mK9U1+A@mail.gmail.com
Whole thread Raw
In response to RE: Monitor Postgres database status on Docker  (Daulat Ram <Daulat.Ram@exponential.com>)
List pgsql-general
Hi Daulat,

El mar., 24 de septiembre de 2019 07:05, Daulat Ram <Daulat.Ram@exponential.com> 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@ericsson.com>
Sent: Tuesday, September 24, 2019 3:02 PM
To: Daulat Ram <Daulat.Ram@exponential.com>; pgsql-general@lists.postgresql.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.Ram@exponential.com>
Sent: Tuesday, September 24, 2019 5:18 PM
To: pgsql-general@lists.postgresql.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

 

 

 

 

 

 

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: "Failed to connect to Postgres database"
Next
From: Achilleas Mantzios
Date:
Subject: Re: pgq is one of the most underrated pg related stuff