Re: Pg_dumpall

I'm the only one with access to our database server, so I do a full trust.

Jon

On Tue, 10 Jun 2003, Bruno Wolff III wrote:

> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>