Default password for postgres user?

[erik20000]

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?

[saurabhs]

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.