On Tue, Jul 06, 2004 at 13:41:15 -0400,
Robert Fitzpatrick <robert@webtent.com> wrote:
>
> Is there a way to automate backup (perhaps using cron)? Of course, I am
> having problems when requiring passwords. I do not want to provide
> passwordless access via pg_hba.conf, then anyone could see the database
> if they know the user name, correct? I am running version 7.4.3.
If you are using ident authentication then you can restrict usage of
various postgres usernames to various system usernames. For example
you could allow the system user root to connect as the postgres user
postgres, but not let anyone connect as postgres.