| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Robert Fitzpatrick <robert(at)webtent(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Pg_dumpall |
| Date: | 2003-06-10 13:52:20 |
| Message-ID: | 20030610135220.GA16346@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Jun 08, 2003 at 22:04:26 -0400,
Robert Fitzpatrick <robert(at)webtent(dot)com> wrote:
> I'm looking for an unattended (cron job) to dump all the databases. We
> have both 7.3.3 and 7.0.2 (Cobalt RaQ) to do this for. I cannot grant a
> certain user permission to dump the databases in 7.0.2 pg_hba.conf file
> and, if I do this for our 7.3.3, does it mean anyone at the command
> prompt can access the databases using the '-U' option and it not require
> a password? What are most on this list doing for automated dumps?
In 7.3.3 you can use ident authentication for local (domain socket)
connections on some OS's. This is a good way to do this kind of thing.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2003-06-10 13:57:06 | Re: host and hostssl equivalence in pg_hba.conf |
| Previous Message | Tom Lane | 2003-06-10 13:51:05 | Re: The transaction that "happens" with function invocation |