Re: pg_dumpall: could not connect to database "template1": FATAL: - Mailing list pgsql-general

From John R Pierce
Subject Re: pg_dumpall: could not connect to database "template1": FATAL:
Date
Msg-id 00a90e89-463b-7f9e-b9b8-1495cfeec573@hogranch.com
Whole thread Raw
In response to Re: pg_dumpall: could not connect to database "template1": FATAL:  (aws backup <albatin.saltanat@gmail.com>)
List pgsql-general
On 11/13/2016 8:51 AM, aws backup wrote:
> I assume that the postgres database password is the one which is shown
> in the DaVinci connect database window.
>
> user: postgres
> password: DaVinci

there are no database passwords, thats the password for the postgres
database role/user.

>
> But if I work in the Terminal and change the user "sudo su - postgres"
> I have to use my admin password.

sudo expects the password of the user running sudo.  this has nothing to
do wih postgres.

>> That is optional and I sort of doubt the application using one.
>
> You think DaVinci is not using any password … ?

he meant, he doubts DaVinci is using a .pgpass file.     The .pgpass
file is another way to pass your passwords to postgres, but its NOT
where postgres stores its passwords, those are stored as hashes in the
pg_catalog.





--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: aws backup
Date:
Subject: Re: pg_dumpall: could not connect to database "template1": FATAL:
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dumpall: could not connect to database "template1": FATAL: