Thread: At restore i get this error FATAL: password authentication failed for user "postgres"
Dear All,
I am new at PgAdmin4 (version 6.16).
So I was able to make a functional backup of my database which is protected by a strong password since that database is accessible over the internet.
When I tried to restore the database I got this error (see below). I looked if I could fill-in the password somewhere but was not able to find a place to do so.
It seems that PgAdmin4 tries to do the restore with the -no-password option. This is bound to fail and as you can see it does fail.
What did I overlook to make this restore work.
Any help would be greatly appreciated.
Kind regards,
Serge De Maseneer.
PS. This version of PgAdmin4 is the Windows version (Windows Professional 11)
Attachment
Hi Serge,
The flag is intentionally --no-password as it is not a good security practice to show the password in the command. The password is set in the environment of the process running the restore. So, yes the password is passed.
On Wed, Nov 23, 2022 at 5:46 PM Serge De Maseneer <serge.de.maseneer@telenet.be> wrote:
Dear All,I am new at PgAdmin4 (version 6.16).So I was able to make a functional backup of my database which is protected by a strong password since that database is accessible over the internet.When I tried to restore the database I got this error (see below). I looked if I could fill-in the password somewhere but was not able to find a place to do so.It seems that PgAdmin4 tries to do the restore with the -no-password option. This is bound to fail and as you can see it does fail.What did I overlook to make this restore work.Any help would be greatly appreciated.Kind regards,Serge De Maseneer.PS. This version of PgAdmin4 is the Windows version (Windows Professional 11)
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"