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?

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.
2. After successful login use below command to set the password:

ALTER ROLE postgres PASSWORD 'postgres';

Hope this helps.