Found incorrect output in pg_lsclusters
*postgres@PC:/root$ uname -aLinux PC 4.9.0-3-amd64 #1 SMP Debian
4.9.30-2+deb9u5 (2017-09-19) x86_64 GNU/Linuxpostgres@PC:/root$ PostgreSQL
9.6.8 on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18) 6.3.0
20170516, 64-bit(1 row)postgres@PC:/root$ pg_lsclusters Ver Cluster Port
Status Owner Data directory Log file9.6 asterisk 5433 down
postgres /postgresql/data/asterisk
/var/log/postgresql/postgresql-9.6-asterisk.log9.6 db1 5432 online
postgres /postgresql/data/db1
/var/log/postgresql/postgresql-9.6-db1.logpostgres@PC:/root$ pg_ctlcluster
9.6 asterisk statuscould not change directory to "/root": Отказано в
доступеpg_ctl: server is running (PID:
32275)/usr/lib/postgresql/9.6/bin/postgres "-D" "/postgresql/data/asterisk"
"-c" "config_file=/etc/postgresql/9.6/asterisk/postgresql.conf"*
But...Client program works well with current DB, but pg_lsclusters outputs
that cluster is down.
Another cluster works well :)
Thanks for your work!
On Tue, Jun 26, 2018 at 02:07:42PM +0300, Pash Ebash wrote:
postgres@PC:/root$ uname -a
Linux PC 4.9.0-3-amd64 #1 SMP Debian 4.9.30-2+deb9u5 (2017-09-19) x86_64 GNU/
Linuxpostgres@PC:/root$
PostgreSQL 9.6.8 on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18)
6.3.0 20170516, 64-bit
(1 row)postgres@PC:/root$ pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
9.6 asterisk 5433 down postgres /postgresql/data/asterisk /var/log/postgresql
/postgresql-9.6-asterisk.log
9.6 db1 5432 online postgres /postgresql/data/db1 /var/log/postgresql/
postgresql-9.6-db1.logpostgres@PC:/root$ pg_ctlcluster 9.6 asterisk status
could not change directory to "/root": Отказано в доступе
pg_ctl: server is running (PID: 32275)
/usr/lib/postgresql/9.6/bin/postgres "-D" "/postgresql/data/asterisk" "-c"
"config_file=/etc/postgresql/9.6/asterisk/postgresql.conf"But...Client program works well with current DB, but pg_lsclusters outputs that
cluster is down.
Another cluster works well :)
Thanks for your work!
'pg_lsclusters' is not a program the Postgres community maintains. I
think it is from Debian and/or Ubuntu --- I would report it to them.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +