Re: Pg_dumpall

From: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Robert Fitzpatrick <robert(at)webtent(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pg_dumpall
Date: 2003-06-10 14:25:07
Message-ID: Pine.GSU.4.44.0306100723520.2398-100000@eskimo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-06-10 14:25:36 Re: 2 servers with 1 database cluster
Previous Message Jonathan Bartlett 2003-06-10 14:23:25 Re: Optimizer failure on integer column?