Thread: Found incorrect output in pg_lsclusters

Found incorrect output in pg_lsclusters

From

Pash Ebash

Date:

26 June 2018, 17:07:42

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!

Re: Found incorrect output in pg_lsclusters

From

Bruce Momjian

Date:

01 August 2018, 01:40:29

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 +