Re: superuser authentication? - Mailing list pgsql-general

From Tom Lane
Subject Re: superuser authentication?
Date
Msg-id 4800.1167835963@sss.pgh.pa.us
Whole thread Raw
In response to superuser authentication?  ("woger151" <woger151@jqpx37.cotse.net>)
Responses Re: superuser authentication?  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
"woger151" <woger151@jqpx37.cotse.net> writes:
> What I'm not sure about is how to authenticate the postgresql superuser
> (user 'postgres' on my system).  I'm considering:

> 1.  Using ident (supposedly secure because of the SO_PEERCRED mechanism; and
> I've made a lot of effort to secure the server at the OS level)
> 2.  Using password (_not_ stored on disk in e.g. pgpass)
> 3.  Using reject

How are you going to do backups?

            regards, tom lane

pgsql-general by date:

Previous
From: "woger151"
Date:
Subject: superuser authentication?
Next
From: "hubert depesz lubaczewski"
Date:
Subject: Re: "no unpinned buffers available" ? why? (hstore and plperl involved)