Re: Authorise root as postgres

Thank you for the reply.

Bruno Wolff III wrote:
>>How can I authorise root the same previliage as postgres?
>>
>>My postgres is password protected, I want to use 'psql -U postgres' as a
>>root without specifying password every time, or for a certain group of
>
> If you are using postgres through a socket (and hence must be on the
> same machine as the server), running at least postgresql 7.2 and your
> OS supports getpeerid, then you can use ident authentication and
> permit root to connect as the postgres user without using a password.

All the anwsers should be yes, except that I don't know about getpeerid.
I'm using RH8, BTW.

Here is what I've been trying (postgresql 7.2 that comes along with RH8):

In $PGDATA/pg_hba.conf, add:

# TYPE       DATABASE    IP_ADDRESS    MASK        AUTH_T    AUTH_ARG
   local      template1                    ident

printf 'admins\troot\tpostgres\n' >> $PGDATA/pg_ident.conf
killall -HUP postmaster

It will still ask for password when 'psql template1' as root. Besides,
specifying either root password or postgres password won't work.

What is supposed to be the right way?

PS. the following works. So I guess it is not the problem of ident:

# TYPE       DATABASE    IP_ADDRESS    MASK               AUTH_T  AUTH_ARG
   local      sameuser                                     ident   sameuser