Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzfNl-0007n5-EP for pgsql-admin@arkaria.postgresql.org; Sun, 05 Nov 2023 15:49:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qzfNj-009lqR-Td for pgsql-admin@arkaria.postgresql.org; Sun, 05 Nov 2023 15:49:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzfNj-009lqJ-Dq for pgsql-admin@lists.postgresql.org; Sun, 05 Nov 2023 15:49:47 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzfNg-004621-N0 for pgsql-admin@lists.postgresql.org; Sun, 05 Nov 2023 15:49:46 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 9D296380334; Sun, 5 Nov 2023 16:49:42 +0100 (CET) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id sZBgGB8OIC_t; Sun, 5 Nov 2023 16:49:42 +0100 (CET) Received: from [192.168.178.86] (xdsl-87-79-218-125.nc.de [87.79.218.125]) by rs.plausibolo.de (Postfix) with ESMTPSA id 26DAD3801AF; Sun, 5 Nov 2023 16:49:42 +0100 (CET) Message-ID: <8e083b7c-62af-289b-9665-997a38dbd65f@jakobs.com> Date: Sun, 5 Nov 2023 16:49:40 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Subject: Re: Error Content-Language: de-DE To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------0jhAaX0z3vl03kITGSk2cKyd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------0jhAaX0z3vl03kITGSk2cKyd Content-Type: multipart/mixed; boundary="------------MQHH8fMJ0O47kISwEE6W2Fy1"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <8e083b7c-62af-289b-9665-997a38dbd65f@jakobs.com> Subject: Re: Error References: In-Reply-To: --------------MQHH8fMJ0O47kISwEE6W2Fy1 Content-Type: multipart/alternative; boundary="------------iPgH8dSxVgkiIQ9prq0In88q" --------------iPgH8dSxVgkiIQ9prq0In88q Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMDUuMTEuMjMgdW0gMTY6NDYgc2NocmllYiBSYWplc2ggS3VtYXI6DQo+IEkgYW0gdGhl IGFkbWluIHdpdGggbGVzcyB0aGFuIGEgeWVhciBhbmQgZXhwLi4uLi5JIGFtIG5vdCB0ZXJt aW5hdGluZyANCj4gYW55IGNvbm5lY3Rpb25zIC4uDQo+DQo+IElzIGl0IGJlY2F1c2Ugb2Yg dmFjdXVtaW5nPw0KPg0KPiBPbiBTdW4sIDUgTm92IDIwMjMsIDIxOjA3IERhdmlkIEcuIEpv aG5zdG9uLCANCj4gPGRhdmlkLmcuam9obnN0b25AZ21haWwuY29tPiB3cm90ZToNCj4NCj4g ICAgIE9uIFN1biwgTm92IDUsIDIwMjMgYXQgODowMOKAr0FNIFJhamVzaCBLdW1hcg0KPiAg ICAgPHJhamVzaGt1bWFyLmRiYTA5QGdtYWlsLmNvbT4gd3JvdGU6DQo+DQo+ICAgICAgICAg SGkgYWxsLA0KPg0KPiAgICAgICAgIEkgYW0gcmVjZWl2aW5nIHRoZSBmb2xsb3dpbmcgZXJy b3IgaW4gcG9zdGdyZXMgbG9nOg0KPg0KPiAgICAgICAgIEZBVEFMLDU3UDAxLCJ0ZXJtaW5h dGluZyBjb25uZWN0aW9uIGR1ZSB0byBhZG1pbmlzdHJhdG9yDQo+ICAgICAgICAgY29tbWFu ZCIuLi4NCj4NCj4NCj4gICAgICAgICBGcm9tIGFwcGxpY2F0aW9uIHNpZGUsIHRoZXkgYXJl IGdldHRpbmcgZm9sbG93aW5nIGVycm9yOg0KPg0KPiAgICAgICAgIFBzcWxleGNlcHRpb246 IEZBVEFMLDogdGVybWluYXRpbmcgY29ubmVjdGlvbiBkdWUgdG8NCj4gICAgICAgICBhZG1p bmlzdHJhdG9yIGNvbW1hbmQuDQo+DQo+DQo+ICAgICAgICAgSG93IHRvIHJlc29sdmUgdGhp cz8NCj4NCj4NCj4gICAgIFRlbGwgeW91ciBhZG1pbmlzdHJhdG9yIG5vdCB0byB0ZXJtaW5h dGUgY29ubmVjdGlvbnMuDQo+DQo+ICAgICBEYXZpZCBKLg0KPg0KTm8sIHNvbWUgYXBwbGlj YXRpb24gaGFzIGNhbGxlZCBwZ190ZXJtaW5hdGVfYmFja2VuZCgpIGZ1bmN0aW9uIG9yIHRo ZSANCnNlcnZlciB3YXMgc2h1dCBkb3duLg0KDQpzZWUgDQpodHRwczovL3d3dy5wb3N0Z3Jl c3FsLm9yZy9kb2NzL2N1cnJlbnQvZnVuY3Rpb25zLWFkbWluLmh0bWwjRlVOQ1RJT05TLUFE TUlOLVNJR05BTA0KDQotLSANCkhvbGdlciBKYWtvYnMsIEJlcmdpc2NoIEdsYWRiYWNoLCBU ZWwuICs0OS0xNzgtOTc1OTAxMg0KDQo= --------------iPgH8dSxVgkiIQ9prq0In88q Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Am 05.11.23 um 16:46 schrieb Rajesh Kumar:
I am the admin with less than a year and exp.....= I am not terminating any connections ..

Is it because of vacuuming?

On Sun, 5 Nov 2023, 21:07 David G. Johnston, <davi= d.g.johnston@gmail.com> wrote:
On Sun= , Nov 5, 2023 at 8:00=E2=80=AFAM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Hi all,

I am receiving the following error in= postgres log:

FATAL,57P01,"terminating connection due to administrator command"...


From application side, they are getting following error:

Psqlexception: FATAL,: terminating connection due to administrator command.


How to resolve this?


Tell you= r administrator not to terminate connections.

David J.=

No, some application has called pg_terminate_backend() function or the server was shut down.

see https://www.postgr= esql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL
= 

--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--------------iPgH8dSxVgkiIQ9prq0In88q-- --------------MQHH8fMJ0O47kISwEE6W2Fy1-- --------------0jhAaX0z3vl03kITGSk2cKyd Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZUe5lQUDAAAAAAAKCRCKV5yTsxlhunve AJ0a9psxXJvFGAjKN9KacwZd1/xacgCgi4flmEbk85Qv4JeiczOgwgEVAXY= =eEor -----END PGP SIGNATURE----- --------------0jhAaX0z3vl03kITGSk2cKyd--