How connect Postgres to localhost server using pgAdmin on Ubuntu?

Question

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

Next, I opened the UI and create the server with this information.

But this below error appears.

How can I fix this?

Answer 1

You have not created a user db. If it is simply a fresh install, the default user is postgres and the password should be blank. Then you access it, you can able to create the users you want.

You can also refer to the SQL tutorial that will help you out in understanding the topic in a better way.

Want to become an expert in SQL? Join SQL Certification course fast !!