| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Robert Fitzpatrick <robert(at)webtent(dot)com> |
| Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: backup using cron |
| Date: | 2004-07-06 20:39:05 |
| Message-ID: | 20040706203905.GA6396@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jul 06, 2004 at 13:41:15 -0400,
Robert Fitzpatrick <robert(at)webtent(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Petrilli | 2004-07-06 20:48:14 | Re: Do we need more emphasis on backup? |
| Previous Message | Stephan Szabo | 2004-07-06 19:41:28 | Re: Interpreting query plan |