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   Later I opened the UI and create the server with this information    but this error appear    how can I fix it

User · Answer

It helps me   1  Open the file pg hba conf     sudo nano  etc postgresql 9 x main pg hba conf   and change this line   Database administrative login by Unix domain socket local   all             postgres                                md5   to  Database administrative login by Unix domain socket local   all             postgres                                trust    Restart the server      sudo service postgresql restart  Login into psql and set password     psql -U postgres    ALTER USER postgres with password  new password      Again open the file pg hba conf and change this line     Database administrative login by Unix domain socket     local   all             postgres                                trust  to      Database administrative login by Unix domain socket     local   all             postgres                                md5   Restart the server      sudo service postgresql restart     It works      Helpful links  1  PostgreSQL  from ubuntu com

User · Answer

if you open the psql console in a terminal window  by typing     psql  you re super user username will be shown before the     for example   elisechant     That will be the user name you should use for localhost

User · Answer

You haven t created a user db  If its just a fresh install  the default user is postgres and the password should be blank  After you access it  you can create the users you need

User · Answer

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  amp  databases using pgAdmin  How to change PostgreSQL user password

User · Answer

Create a user first  You must do this as user postgres  Because the postgres system account has no password assigned  you can either set a password first  or you go like this   sudo  bin bash   you should be root now   su postgres   you are postgres now createuser --interactive   and the programm will prompt you

User · Answer

First you should change the password using terminal    username is postgres   postgres    password postgres  Then you will be prompted to enter the password and confirm it   Now you will be able to connect using pgadmin with the new password

[postgresql] How connect Postgres to localhost server using pgAdmin on Ubuntu?

Examples related to postgresql

Examples related to database-connection

Examples related to pgadmin