Changing postgres password in version 9.4

Question

I have PostgreSql 9.3 version installed in my ubuntu 14.04 machine. I just installed the 9.4 version as well and the port it is on is 5433(by default). When i give the command psql --version, it gives me the following:

psql (PostgreSQL) 9.4.1

So far so good! Now i am trying to change my password for my postgresql 9.4 and i gave the following command:

>>sudo -u postgres -p 5433 psql
psql (9.4.1, server 9.3.6)
Type "help" for help.

postgres=# alter user postgres with password 'password';
ALTER ROLE
postgres=# \q

Now i tried connecting it on pgadmin3 but it would give me the password authentication failure. Am i doing it right?

Are the connection/authentication settings in your pg_hba.conf set up correctly? Try connecting with your local IP address in pgadmin. — Simon Hoare
– Simon Hoare, Commented Apr 15, 2015 at 19:08

Tometzky · Accepted Answer · 2015-04-15 18:59:47Z

4

sudo -u postgres psql -p 5433

Your -p 5433 as you write it is treated as an option for sudo, not for psql. And you've connected to Postgres 9.3 on standard port.

answered Apr 15, 2015 at 18:59

Tometzky

24.2k5 gold badges64 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Abhishek Over a year ago

but this command is asking for my postgres password which i have not setup yet

Chris Tate · Accepted Answer · 2015-04-15 19:09:39Z

4

Try using:

>>sudo -u postgres -p 5433 psql
psql (9.4.1, server 9.3.6)
Type "help" for help.

postgres=# \password
Enter new password:
Enter it again:
postgres=#

edited Apr 15, 2015 at 19:09

answered Apr 15, 2015 at 18:58

Chris Tate

4582 silver badges10 bronze badges

2 Comments

Abhishek Over a year ago

can you tell me the exact command? i am a newbie to linux and postgresql

Chris Tate Over a year ago

The command is \password, a meta command of psql. Updated answer to include the original code.

Collectives™ on Stack Overflow

Changing postgres password in version 9.4

2 Answers 2

1 Comment

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Related