I can't connect POSTGRES database using SQL Shell (command line tool)

Question

I've got a problem during connecting database from command line tool - SQL Shell. I cant connect database using command \c test localhost postgres 5432

After using it I receive message:

could not translate host name "postgres" to address: Unknown host Previous connection kept

Although I can connect using pgAdmin 4. Does anyone know how to fix this? I'm working on Windows 10, I have the newest version of PostgreSQL.

Look up the order of the arguments for \c

jjanes
– jjanes

2022-01-03 10:56:54 +00:00
Commented Jan 3, 2022 at 10:56 — jjanes
– jjanes, Commented Jan 3, 2022 at 10:56

Pooya · Accepted Answer · 2022-01-03 09:57:13Z

1

According to postgres document if you want CLI for to connect database you have to use like that:

=> \c mydb myuser host.dom 6432
=> \c service=foo
=> \c "host=localhost port=5432 dbname=mydb connect_timeout=10 sslmode=disable"
=> \c -reuse-previous=on sslmode=require    -- changes only sslmode
=> \c postgresql://tom@localhost/mydb?application_name=myapp

answered Jan 3, 2022 at 9:57

Pooya

3,2032 gold badges16 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

I can't connect POSTGRES database using SQL Shell (command line tool)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related