CODEWITHSUNDEEP
postgresqlpgadmin
user3667111
user3667111

Reputation:

pgAdmin III : No servers showing up

I've followed many online tutorials on how to install pgAdmin correctly, I've installed and uninstalled it multiple times but whenever install it. It shows Server Groups without any servers in it.

Then when I try and register a new server using localhost for both name and host I get this error:

server doesn't listen

Searched for days trying to find a solution for this, any ideas?enter image description here

Upvotes: 11

Views: 43038

Answers (4)

user3003976
user3003976

Reputation: 329

Happened with me as well, when I started pgadmin3 for the first time, I was expecting it to ask for the password which I provided during but it didnt ask and then didnt display any servers. Anyways, you can create a server yourself. If your server is on the same machine,

provide a name: test
provide server: localhost
provide a port number : 5432 (default port)
provider a username: postgres (default user, you can change later in login roles)
password: provide something

Restart if required, and it will then show you a database with postgres (default db), tablespace, and login roles under your server, and you should be good to go .

Upvotes: 20

Miroslav Hinkov
Miroslav Hinkov

Reputation: 97

When I did this invalid password message appeared. So I had to change postgres user password: In the terminal window:

  1. Switch to the postgres account on the server by typing:

sudo -i -u postgres

  1. Now I can access a Postgres prompt immediately by:

psql

  1. Change the postgres user password:

ALTER USER postgres WITH PASSWORD 'newpass';

Upvotes: 6

Inamur Rahman
Inamur Rahman

Reputation: 3291

First Create a Server with the following credential-

Host Name/address : localhost
Port : 5432
Maintenance database : postgres

Username : postgres
Password : *Your_Password*

Note : Before Creating the Server first start the postgresql server

Upvotes: 4

user3667111
user3667111

Reputation:

Reinstalled program and saved it to directory C:\ instead of C:\program_Files

Upvotes: 4

Related Questions