From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Cc: pgsql-admin@lists.postgresql.org, Holger Jakobs <holger@jakobs.com>
Subject: Re: Error
Date: Sun, 05 Nov 2023 11:19:25 -0500
Message-ID: <3652551.1699201165@sss.pgh.pa.us> (raw)
In-Reply-To: <8e083b7c-62af-289b-9665-997a38dbd65f@jakobs.com>
References: <CAJk5AtYw5E49npzvaXF6VqOvvjRfaZrj1TnZfZcRYM+VbT1V=A@mail.gmail.com>
<CAKFQuwYC7LObFN4+6-W3EMZqtSyv17Vaozy9u6qmsvFiZ0pxEg@mail.gmail.com>
<CAJk5AtYvNTdqND3QS3bdivt7SMoabG_XuA49xYOcWX6NsZ593w@mail.gmail.com>
<8e083b7c-62af-289b-9665-997a38dbd65f@jakobs.com>
Holger Jakobs <holger@jakobs.com> writes:
> Am 05.11.23 um 16:46 schrieb Rajesh Kumar:
>> Is it because of vacuuming?
> No, some application has called pg_terminate_backend() function or the
> server was shut down.
> see
> https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL
Concretely, this indicates that something sent the server process
a SIGTERM signal. At least within Postgres, that can only come
from pg_terminate_backend() or the postmaster sending it because
it was sent a SIGINT signal to do a fast shutdown.
So, if you weren't doing this intentionally, you need to look
for an external source of those signals.
A common newbie mistake that could lead to this is launching the
postmaster by hand, or in a shell script, in a way that doesn't
dissociate it from your terminal session. In that case typing
control-C or ending the session would deliver one of these
signals. Make sure your postmaster start script (a) uses nohup
and (b) redirects all three of postmaster's stdin, stdout, and
stderr away from the terminal.
Could be something else too, but in the end you've got something
signaling the server that you don't want.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, rajeshkumar.dba09@gmail.com, holger@jakobs.com
Subject: Re: Error
In-Reply-To: <3652551.1699201165@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox