Connect PostgreSQL database with password to pgAdmin

Question

I am trying to connect a PostgreSQL database to pgAdmin.

The only information I have about the database are:

postgres://candidate.company.org/company
Username: banana
Password: aaabbbccc

On pgAdmin I do:

1) Click on Add new server

2) Fill the info as in photo

3) Press save

BUT I get:

Unable to connect to server:

could not translate host name "postgres://candidate.company.org/company" to address: nodename nor servname provided, or not known

Was getting the same error, despite having the hostname configured correctly. Worked around it by running nslookup <hostname> and configuring the IP address returned as the host in pgadmin. Temporary hack, but it works. — aroth
– aroth, Commented Aug 21 at 0:27

Jeremy · Accepted Answer · 2019-09-23 15:42:14Z

5

It looks like someone gave you a JDBC url. The hostname is just candidate.company.org. The database is company.

answered Sep 23, 2019 at 15:42

Jeremy

6,78322 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Connect PostgreSQL database with password to pgAdmin

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