Обсуждение: Can not close psql
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/18/app-psql.html Description: Hello. 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. ``` userdb=> userdb=> \d 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 ^C^C^C^C^C ^C^C^C^C^C ^X^Z 3 asdf dfafasf ^C^C^C^C^C^C^C ``` It would be nice if `psql` allows to disconnect from console if a connection to database was lost.
On Thursday, October 16, 2025, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/18/app-psql.html
Description:
Hello.
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.
It would be nice if `psql` allows to disconnect from console if a connection
to database was lost.
Seems like this would be better reported as an actual bug. Not as comments related to the effectiveness of the documentation.
David J.
PG Doc comments form <noreply@postgresql.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