Обсуждение: 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

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

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

Thanks but how we can use it for docker container.

Regards,

Daulat

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

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

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,

Thanks but how we can use it for docker container.

Regards,

Daulat

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

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

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,

Thanks but how we can use it for docker container.

Regards,

Daulat

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

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