public inbox for [email protected]  
help / color / mirror / Atom feed
Can not close psql
3+ messages / 3 participants
[nested] [flat]

* Can not close psql
@ 2025-10-16 13:23  PG Doc comments form <[email protected]>
  0 siblings, 2 replies; 3+ messages in thread

From: PG Doc comments form @ 2025-10-16 13:23 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

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.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Can not close psql
@ 2025-10-16 21:59  David G. Johnston <[email protected]>
  parent: PG Doc comments form <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: David G. Johnston @ 2025-10-16 21:59 UTC (permalink / raw)
  To: [email protected] <[email protected]>; [email protected] <[email protected]>

On Thursday, October 16, 2025, PG Doc comments form <[email protected]>
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.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Can not close psql
@ 2025-10-16 22:12  Tom Lane <[email protected]>
  parent: PG Doc comments form <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2025-10-16 22:12 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

PG Doc comments form <[email protected]> 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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2025-10-16 22:12 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-10-16 13:23 Can not close psql PG Doc comments form <[email protected]>
2025-10-16 21:59 ` David G. Johnston <[email protected]>
2025-10-16 22:12 ` Tom Lane <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox