On 4/7/23 15:51, Telium Technical Support wrote:
> I tried the command you suggested, and it shows that data directory status as "DOWN". Yet when I ask pg_ctlcluster
forit's status it says the server is running.
>
> What does this mean?
>
> root@d11:/var/tmp/myapp# pg_lsclusters
> Ver Cluster Port Status Owner Data directory Log file
> 13 main 5432 down postgres /var/lib/postgresql/13/main /var/log/postgresql/postgresql-13-main.log
> 15 main 5433 down postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
Neither cluster is running.
To confirm do:
ps ax | grep postgres
> root@d11:/var/tmp/myapp# sudo -u postgres /usr/bin/pg_ctlcluster 15 main status -- -D /var/lib/postgresql/13/main
> pg_ctl: server is running (PID: 2701882)
Best guess, is that because of this:
sudo -u postgres /usr/bin/pg_ctlcluster 15 main stop -- -m fast -D
/var/lib/postgresql/13/main
the Postgres pid did not get removed on shutdown.
Bottom line you should not use
pg_ctlcluster 15 main stop
to
shut down a 13 cluster located at:
-D /var/lib/postgresql/13/main
Just do:
sudo -u postgres /usr/bin/pg_ctlcluster 15 main stop -m fast
or
sudo -u postgres /usr/bin/pg_ctlcluster 13 main stop -- -m fast
depending on which cluster you want to shut down.
> /usr/lib/postgresql/15/bin/postgres "-D" "/var/lib/postgresql/13/main" "-c"
"config_file=/etc/postgresql/15/main/postgresql.conf"
> root@d11:/var/tmp/myapp#
>
--
Adrian Klaver
adrian.klaver@aklaver.com