neon: psql stuck on reconnection
To reproduce:
- Connect with "quick connect:
$ psql -h start.zenith.tech
NOTICE: ☀️ Welcome to Zenith!
To proceed with database creation, open the following link:
https://console.zenith.tech/psql_session/4d754295011d1690
It needs to be done once and we will send you '.pgpass' file,
which will allow you to access or create databases without opening your web browser.
NOTICE: Connecting to database.
psql (13.5 (Debian 13.5-0+deb11u1), server 14.2)
WARNING: psql major version 13, server major version 14.
Some psql features might not work.
Type "help" for help.
heikki=>
- Connect again, with the
\c
command
heikki=> \c
NOTICE: ☀️ Welcome to Zenith!
To proceed with database creation, open the following link:
https://console.zenith.tech/psql_session/712b63cd43e0b9b2
It needs to be done once and we will send you '.pgpass' file,
which will allow you to access or create databases without opening your web browser.
^C
^C^C
^C^C
Without opening the link, try killing psql with CTRL-C. It doesn’t work. It does work in the first connection attempt, but when reconnecting with \c
it does not.
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 16 (16 by maintainers)
Committed today. I don’t think it’ll be back-patched, but available for PG 17.
Confirming I can still reproduce this (psql 16.1). However, I don’t think it’s a concern for proxy so I’m removing the label
yep.
@tristan957, you’ve been looking into ctrl-c with pgbench, could you have a look at this too?