neon: psql stuck on reconnection

To reproduce:

  1. 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=>
  1. 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)

Most upvoted comments

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?