Cannot Connect Remotely to PostgreSQL DB

1

Using what seems to be standard psql commands in terminal, I cannot connect to my Postgresql DB on Render to manage tables etc.
Commands like:
psql -h <Host - **using my External Database URL**> -p <Port> -d <Name> -U <User> -W

I get:
psql: error: could not translate host name "postgresql://....." to address: nodename nor servname provided, or not known

I am not the most well-versed in this way of working but this seems straightforward from what I see around. Can anyone suggest anything?

2

Hi there,

Have you tried directly copying and using the psql command provided in the “Connect” dropdown (select “External”) in the Dashboard?

Regards,
Mike

Render Support Engineer, MT (UTC-6, UTC-7 in Winter)

3

I ended up using Postico, guess I’m good. answers still appreciated :slight_smile:

4

Glad you got it working! Thanks for letting us know.

Regards,
Mike

Render Support Engineer, MT (UTC-6, UTC-7 in Winter)

5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.