Re: superuser authentication?

"woger151"  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