Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dumpall non-interactive, how?

pg_dumpall non-interactive, how?

From
"A.Bhuvaneswaran"
Date:
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?

regards,
bhuvaneswaran

Re: pg_dumpall non-interactive, how?

From
Bruno Wolff III
Date:
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.