CODEWITHSUNDEEP
database-connectionpgadmin-4
aircraft
aircraft

Reputation: 26924

Connection with my db using pgAdmin4

I am study with this tutorial: https://www.youtube.com/watch?v=Ho3DKKopC2E&list=PLDmvslp_VR0xlwr5lAx2PDsZLu7oIOhpX&index=20

When I connect to db, I want to connect the db like the turorial:

enter image description here

But I failed, because I don't know how to do with it:

enter image description here

Does anyone knows how to do with it?

Upvotes: 17

Views: 105188

Answers (4)

Murtuza Z
Murtuza Z

Reputation: 6017

Add new server steps:

  1. Open pgAdmin4

  2. Right click in "Servers" in Browser panel

  3. Enter some meaningful name for Server eg: "PostgreSQL9.6"

  4. Click on "Connection" tab

  5. Enter "Host" (default is "localhost" if database is installed on your own local system otherwise IP address of system where PostgreSQL database is installed)

  6. Enter "Port" (default port for PostgreSQL server is "5432")

  7. Enter "Maintenance Database" name (default is "postgres")

  8. Enter "User Name" (default user is "postgres")

  9. Enter "Password" (Password which you gave when you installed PostgreSQL database for "postgres" user)

  10. Click on CheckBox "Save password?" to save your password in pgAdmin4 for future use.

Now as you can see, "Save" button gets enable in dialog, just click on it.

You will see that your server is now listed under "Servers" and you should be connected to your database.

Upvotes: 36

ARTHUR SANTOS
ARTHUR SANTOS

Reputation: 11

If you created a database from the docker, use the 'docker inspect ID_IMAGE' to see the IP address. This IP address will be put in pgadmin in the connection tab in the first input "host name/address". If you mirrored the default postgress port on docker-compose.yml for 5432 like ports: 5432:5432 the IP address will be input "host name/address" and will only receive this value '0.0.0.0'

Upvotes: 1

WCS
WCS

Reputation: 99

localhost did no work for me, but my server ip (192.168.xx.x) address worked. The x needs to be replace with you ip address.

Upvotes: 1

Murtuza Z
Murtuza Z

Reputation: 6017

You are getting error because You did not specified Name for server, Click on "General" tab provide name for your server like "PostgreSQL9.6"

Refer the pgAdmin4 documents:

Connecting to server: https://www.pgadmin.org/docs4/dev/connecting.html

Creating new server: https://www.pgadmin.org/docs4/dev/server_dialog.html

While creating new Server you should have all the required parameters like,

Host (default is "localhost" if database is installed on local system), Port(default is "5432"), Maintenance Database Name (default is "postgres"), User Name (default is "postgres"), Password

Without above required information you can't connect to PostgreSQL database server.

Upvotes: 2

Related Questions