How to 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

enter image description here

but this error appear

enter image description here

how can I fix it?

download postgresql of v9.3 from this link [https://www.enterprisedb.com/downloads/postgres-postgresql-downloads#windows](https://www.enterprisedb.com/downloads/postgres-postgresql-downloads#windows) and again run pgadmin III you will get local host already install need not to connect. — Dhavalkumar Prajapati, Aug 18 '17 at 08:57

score 223 · Answer 1 · edited May 23 '17 at 12:10

223

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?

edited May 23 '17 at 12:10

Community

1
1

answered Apr 17 '15 at 19:07

WiredIn

4,157
4
27
23

16

or you can just.. 'sudo -u postgres psql' and then type '\password'. hit enter. enter new password. – Jay Modi Dec 21 '15 at 06:54
2

This should be accepted answer. Thank you. This helped a lot. – Pramesh Bajracharya May 30 '18 at 16:38

score 35 · Accepted Answer · answered Jul 23 '14 at 19:00

35

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.

answered Jul 23 '14 at 19:00

Eric Workman

1,425
12
13

49

If I do that, this error appear ``Error connecting to the server: fe_sendauth: no password supplied`` – TuGordoBello Jul 23 '14 at 20:00
Here on opensuse the postgres user password is not blank, but undefined (an exclamation mark in /etc/shadow). No password login possible. – Str. Jul 23 '14 at 21:16
Just tested to verify, and yes, Pg does emit `password authentication failed` for a user that doesn't exist when using `md5` auth. – Craig Ringer Jul 24 '14 at 01:54
@CraigRinger I just checked a default pg_hba.conf, and you are correct. The default is peer or md5. – Eric Workman Jul 24 '14 at 11:32
1

how do you create a user? – ahnbizcad Jan 31 '15 at 02:06
2

"Error connecting to the server: fe_sendauth: no password supplied" – Cerin Sep 19 '17 at 19:02

score 29 · Answer 3 · edited Sep 19 '17 at 19:06

29

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)

edited Sep 19 '17 at 19:06

Cerin

60,957
96
316
522

answered Feb 05 '16 at 12:38

Kas Elvirov

7,394
4
40
62

This solved my problem, but can you explain why changing the db admin login to trust prior to setting the postgres password is needed in some instances? – HostMyBus Oct 01 '18 at 20:12
@HostMyBus Hi man, actually I don't recall at all this case. Try to dig some answers from the web (i think there is a good explanation about that) – Kas Elvirov Oct 02 '18 at 05:26
@HostMyBus this is a security feature. If it is set to trust, any user on the machine can login to the database. – Simon Zyx Feb 28 '19 at 14:43
And you actually don't need it: Just use WiredIn answer – Simon Zyx Feb 28 '19 at 14:45

Str. · Answer 4 · 2014-07-24T19:51:38.580

4

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.

edited Jul 24 '14 at 19:51

answered Jul 23 '14 at 21:10

Str.

1,389
9
14

`sudo -u postgres -i` will lead to password question. There is no password on my system you can enter. My proposal works always (hm, hopefully). – Str. Jul 24 '14 at 19:35
`sudo -u postgress -i` doesn't lead to password question (at least on my Ubuntu after default installation). Either the `createuser --interactive` doesn't lead to the password prompt... :( – Ondřej Doněk Nov 28 '14 at 06:06
@OndřejDoněk my proposal was sudo /bin/bash first, did you do that? – Str. Nov 29 '14 at 09:20
what should you type in for role? – ahnbizcad Jan 31 '15 at 02:12
$ `createuser --interactive` Enter name of role to add: `postgres` Shall the new role be a superuser? (y/n) `y` – Elise Chant Jun 10 '17 at 20:27

score 3 · Answer 5 · answered Jun 28 '17 at 05:25

3

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.

answered Jun 28 '17 at 05:25

Pubudu

93
3

score 0 · Answer 6 · answered Jun 10 '17 at 20:41

0

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.

answered Jun 10 '17 at 20:41

Elise Chant

5,048
3
29
36

How to connect Postgres to localhost server using pgAdmin on Ubuntu?

6 Answers6

Linked