Re: Fixing the loss of 'template1'

Martin Gregorie <martin@gregorie.org> writes:
> On Wed, 2012-03-07 at 10:50 -0500, Tom Lane wrote:
>> Oh, time for a new theory then.  What's the *exact* error message you
>> were getting from pg_dump?  Do you get the same from a manual attempt to
>> connect to template1?

> Yes:

> # psql -d template1 -U postgres
> psql: FATAL:  Peer authentication failed for user "postgres"

Oh, well, that hasn't got anything to do with the database permissions,
nor template1 for that matter.  That says you're trying to log in as
postgres and the OS reports that you're not postgres.  You either need
to su to postgres or change your authentication method.

            regards, tom lane