Re: ident authentication problems postgresql 9.2

On 16/10/13, Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> Rory Campbell-Lange <rory(at)campbell-lange(dot)net> writes:
> > 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?

Hi Tom. Thanks for your response.

I'm sure I'm doing something silly, but /etc/password is 0644, and I've
checked my etckeeper logs for changes over the past month and the passwd
file hasn't changed.

...
reset
...

I've just done an upgrade to 9.2.5 and the ident issue is resolved. The
package changes were:

-libpq5 9.3.0-2.pgdg70+1
+libpq5 9.3.1-1.pgdg70+1
-postgresql-9.2 9.2.4-2.pgdg70+1
+postgresql-9.2 9.2.5-1.pgdg70+1
-postgresql-client-9.2 9.2.4-2.pgdg70+1
+postgresql-client-9.2 9.2.5-1.pgdg70+1
-postgresql-contrib-9.2 9.2.4-2.pgdg70+1
+postgresql-contrib-9.2 9.2.5-1.pgdg70+1

Regards
Rory