Re: Can not close psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kes-kes(at)yandex(dot)ru
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Can not close psql
Date: 2025-10-16 22:12:03
Message-ID: 1569201.1760652723@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

PG Doc comments form <noreply(at)postgresql(dot)org> writes:
> I was connected to database via `psql` then I rebooted DB. I was not able to
> disconnect from terminal after that. Only whole window close helped.

A documentation comment is a very poor way to submit a trouble
report...

> FATAL: terminating connection due to administrator command
> SSL connection has been closed unexpectedly
> The connection to the server was lost. Attempting reset:
> ^C^C^C^C

Hmm. When I try this I get either

postgres=# \d
FATAL: terminating connection due to administrator command
SSL connection has been closed unexpectedly
The connection to the server was lost. Attempting reset: Failed.
!?>

or

postgres=# \d
FATAL: terminating connection due to administrator command
SSL connection has been closed unexpectedly
The connection to the server was lost. Attempting reset: Succeeded.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off, ALPN: postgresql)
postgres=#

(depending on whether I restarted the server yet), with pretty
much no delay. You'll need to provide a lot more context about
your setup if you want useful help. What's the platform? Is
the server on the same machine as psql, or remote? What
connection options are you using besides SSL? What OpenSSL
version is psql using? For that matter, which psql version
is it?

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

regards, tom lane

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Sergei Katkovsky 2025-10-17 07:37:40 Re: BPCHAR description in 8.3. Character Types is misleading and incomplete
Previous Message David G. Johnston 2025-10-16 21:59:18 Re: Can not close psql