psql hangs - Database is idle in Neon
I'm trying to connect using the given psql command. I paste it into my terminal but the command hangs. Otherwise my internet connection is working. The database instance just says Idle
5 Replies
genetic-orangeOP•2y ago
Nevermind, my postgres port was 5435 by default for psql. As a suggestion, the port should be included in the generated psql and connection string codes
magic-amber•2y ago
@Logan it's not clear what the issue was here. You're saying you had to specify port 5435 when connecting to Neon?
I've never seen that. We use 5432
genetic-orangeOP•2y ago
Other way around, sorry I was unclear. For whatever reason my default in psql client is 5435
magic-amber•2y ago
Oh, weird. Maybe you had
PGPORT set in your environment or a .psqlrc file?
This is a good suggestion though 👍genetic-orangeOP•2y ago
Neither of those, but I do have
port = 5435 in my postgresql.conf file, which I assumed only applied to the server!