Local Postgres Server on Mac Pw Auth Fail

0 votes

0 answers

1886 views

postgresql sql-server-localdb bash macos

                          Disclaimer: I am new to MacOs. Haven't found any useful related question.

After successfully installing postgresql 13.2 via homebrew on MacOs 11.2.1 (BigSur) i run into the following problem:

Use terminal for the command 

    psql postgres

Prompts user pwd of my standard Mac user account.

Returns: 

    psql: error: FATAL:  password authentication failed for user "standarduser"

Try:

    sudo psql postgres

Now asks standard user pwd and accepts it.
Then asks root user pwd and rejects it with the same error as before:
Returns:
   
    psql: error: FATAL:  password authentication failed for user "root"

What am I missing?

Asked by Google Google (1 rep)

Apr 16, 2021, 08:35 PM

Local Postgres Server on Mac Pw Auth Fail

Related Questions