Re: pg_ctlcluster is not stopping cluster

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: Thorsten Glaser <tg(at)evolvis(dot)org>
Cc: Telium Technical Support <support(at)telium(dot)io>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_ctlcluster is not stopping cluster
Date: 2023-04-08 04:27:55
Message-ID: m0bkjzxak4.fsf@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thorsten Glaser <tg(at)evolvis(dot)org> 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/15/main/postmaster.pid
>>
>>(and notice the 15). Is this a clue?
>
> Maybe the pidfile is written into the cluster version-based directory
> instead of the data directory. Best figure out what exactly writes the
> pidfile, whether systemd is used for starting (which would of course be

Some distros in their wrapper foo, I believe including Debian use this
setting to put a PID file under /var/run/postgresql IIRC but YMMV...

external_pid_file (string)

Specifies the name of an additional process-ID (PID) file that the
server should create for use by server administration programs. This
parameter can only be set at server start.

> a prime suspect as it says it’s explicitly not used for stopping), etc.
>
> Maybe this is indeed a bug in whatever determines the pidfile path,
> perhaps not; is it supposed to live within the data directory?
>
> bye,
> //mirabilos

In response to

Browse pgsql-general by date

  From Date Subject
Next Message jian he 2023-04-08 12:58:40 doc sql-grant.html Synopsis error?
Previous Message Adrian Klaver 2023-04-07 23:01:01 Re: pg_ctlcluster is not stopping cluster