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