Thorsten Glaser writes:
> On Fri, 7 Apr 2023, Telium Technical Support wrote:
>
>>Notice: extra pg_ctl/postgres options given, bypassing systemctl for stop
>
>>it might be 13. Coincidentally, there is a postmaster.pid file in a
>>directory OTHER than the data directory:
>>
>>/var/lib/postgresql/
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 for it's status it says the server is
running.
What does this mean?
root@d11:/var/tmp/myapp# pg_lsclusters
Ver Cluster Port Stat
>The mix between 13 and 15 here is what I’d consider a misconfiguration.
As I inherited this (and I'm somewhat new to pgsql), I'm trying to understand
this. From the docs I read online, the postmaster.pid file is supposed to
reside in the data directory. Which it does. So that's ok.
Does the
nal Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Friday, April 7, 2023 6:47 PM
To: Telium Technical Support ;
pgsql-general@lists.postgresql.org
Subject: Re: pg_ctlcluster is not stopping cluster
On 4/7/23 15:27, Telium Technical Support wrote:
> I am string to stop my Postg
On Fri, 7 Apr 2023, Telium Technical Support wrote:
>I’m assuming something is misconfigured on the host that’s causing this
>unusual behavior….and that’s what I need to understand
The mix between 13 and 15 here is what I’d consider a misconfiguration.
Also, please don’t top-post and full-quote.
On Fri, 7 Apr 2023, Telium Technical Support wrote:
>Notice: extra pg_ctl/postgres options given, bypassing systemctl for stop
>it might be 13. Coincidentally, there is a postmaster.pid file in a
>directory OTHER than the data directory:
>
>/var/lib/postgresql/15/main/postmaster.pid
>
>(and noti
: Friday, April 7, 2023 6:46 PM
To: Telium Technical Support
Cc: pgsql-general@lists.postgresql.org
Subject: Re: pg_ctlcluster is not stopping cluster
I wonder if the best way to proceed would be to go on to individual nodes in
the cluster and use OS level commands (such as ps) to track
On 4/7/23 15:27, Telium Technical Support wrote:
I am string to stop my PostgreSQL (on debian 11) server using the
following command
root@d11:/# sudo -u postgres /usr/bin/pg_ctlcluster 15 main stop -- -m
fast -D /var/lib/postgresql/13/main
Notice: extra pg_ctl/postgres options given, bypassi
I wonder if the best way to proceed would be to go on to individual nodes
in the cluster and use OS level commands (such as ps) to track individual
processes and stop them individually.
On Fri, Apr 7, 2023 at 6:27 PM Telium Technical Support
wrote:
> I am string to stop my PostgreSQL (on debian
