Обсуждение: Found incorrect output in pg_lsclusters
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/Linux
postgres@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.log
postgres@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"
Linux PC 4.9.0-3-amd64 #1 SMP Debian 4.9.30-2+deb9u5 (2017-09-19) x86_64 GNU/Linux
postgres@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.log
postgres@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!
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/ > Linux > > postgres@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.log > > postgres@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 +