Re: At restore i get this error FATAL: password authentication failed for user "postgres"

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: Serge De Maseneer <serge(dot)de(dot)maseneer(at)telenet(dot)be>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: At restore i get this error FATAL: password authentication failed for user "postgres"
Date: 2022-11-23 12:35:37
Message-ID: CAM9w-_kdpPfBnH7DooD8Eak2jweC31UCvR2BVH9mZ1wLAoUt8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(dot)de(dot)maseneer(at)telenet(dot)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*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message William Torrez Corea 2022-11-24 05:58:20 My account was locked in pgadmin4
Previous Message Serge De Maseneer 2022-11-23 12:16:31 At restore i get this error FATAL: password authentication failed for user "postgres"