Can't backup my PostgreSQL database [ peer authentication failed for user "USER" ]

Question

sql file that I backedup a long time ago of my website database and now I'm trying to use it but everytime I use:

psql -U <username> -d --password <dbname> -1 -f <filename>.sql

it gives me this error

peer authentication failed for user "USER"

I tried to edit the pg_hba.conf but that did nothing.

how can I do it ?

Laurenz Albe · Accepted Answer · 2020-04-27 07:54:24Z

1

Several mistakes:

You didn't edit pg_hba.conf properly or you forgot to reload PostgreSQL.

Add your pg_hba.conf to the question for more details.
Your command line is syntactically incorrect; --password will be interpreted as argument of -d. Try
```
psql -U <username> -d <dbname> --password -1 -f <filename>.sql
```

answered Apr 27, 2020 at 7:54

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

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

1 Answer 1