How connect Postgres to localhost server using pgAdmin on Ubuntu?

TuGordoBello picture TuGordoBello · Jul 23, 2014 · Viewed 262.6k times · Source

I installed Postgres with this command

sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev

Using psql --version on terminal I get psql (PostgreSQL) 9.3.4

then I installed pgadmin with

sudo apt-get install pgadmin3

Later I opened the UI and create the server with this information

enter image description here

but this error appear

enter image description here

how can I fix it?

Answer

WiredIn picture WiredIn · Apr 17, 2015

Modify password for role postgres:

sudo -u postgres psql postgres

alter user postgres with password 'postgres';

Now connect to pgadmin using username postgres and password postgres

Now you can create roles & databases using pgAdmin

How to change PostgreSQL user password?