| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | martin(at)gregorie(dot)org |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: Fixing the loss of 'template1' |
| Date: | 2012-03-07 16:51:45 |
| Message-ID: | 9504.1331139105@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Martin Gregorie <martin(at)gregorie(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolas Grilly | 2012-03-07 16:53:29 | Re: Full text search ranking: ordering using index and proximiti ranking with OR queries |
| Previous Message | mdione.ext | 2012-03-07 16:51:19 | Re: ERROR: could not find tuple for trigger 37463634 |