Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dumpall non-interactive, how? - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: pg_dumpall non-interactive, how?
Date
Msg-id 20030507140633.GA24317@wolff.to
Whole thread Raw
In response to pg_dumpall non-interactive, how?  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
List pgsql-admin
Tree view 
On Wed, May 07, 2003 at 18:24:44 +0530,
  "A.Bhuvaneswaran" <bhuvansql@myrealbox.com> wrote:
> Hi,
>
> I use pgsql 7.3.2.
>
> How can i dump and restore all my databases in non-interactive mode? One
> way is i can set trust in pg_hba.conf. Is there any other *trusted* way?

If you are using domain sockets for connection and your OS supports it
you can use ident.

pgsql-admin by date:

Previous
From: Jan Kohout
Date:
Subject: Show all users
Next
From: Tom Lane
Date:
Subject: Re: cant' pg_ctl find pid file from PGDATA env variable?