cancel
Showing results for 
Search instead for 
Did you mean: 

Default password for postgres user?

Level 3 Traveller

Default password for postgres user?

Installed PostgreSQL 10.4.1 on Mac. Started pgAdmin 4. But get message Please enter password for user postgres to connect the server - PostgreSQL 10

 

Anyone know the password?

1 REPLY
EDB Team Member

Re: Default password for postgres user?

Hi erik,

 
There is no such default password for user Postgres. The password needs to be set. 
 
Please find below details:
 
1. Login to the machine where PostgreSQL is installed. Use below command from terminal to connect to the cluster. 
 
psql -U postgres 
 
- If the PATH is not set, above command will give an error. Below is the default PATH for PostgreSQL binaries.
 
/Applications/Postgres.app/Contents/Versions/latest/bin/
 
2. After successful login use below command to set the password:
 

ALTER ROLE postgres PASSWORD 'postgres';

 
Hope this helps.