| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ident authentication problems postgresql 9.2 |
| Date: | 2013-10-16 19:59:23 |
| Message-ID: | 7531.1381953563@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Rory Campbell-Lange <rory(at)campbell-lange(dot)net> writes:
> Thanks for the suggestion for checking the logs. My apologies for not
> checking that. The logs show:
> 2013-10-16 16:21:16 BST template1 LOG: local user with ID <abc> does not exist
> 2013-10-16 16:21:16 BST template1 FATAL: Peer authentication failed for user "postgres"
> However /etc/passwd has
> postgres:x:<abc>:<def>:PostgreSQL administrator,,,:/db:/bin/bash
Hm. A look at the PG source code shows conclusively that the "local user
does not exist" error comes out only if getpwuid() fails. Why it's
failing isn't too clear though. Perhaps your upgrade accidentally made
/etc/passwd non-world-readable, or some such?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2013-10-16 20:10:20 | Re: ident authentication problems postgresql 9.2 |
| Previous Message | Merlin Moncure | 2013-10-16 18:48:00 | Re: PostgreSQL vs Mongo |