Re: Automated restore?

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: Paul Makepeace <postgresql(dot)org(at)paulm(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Automated restore?
Date: 2003-04-15 09:22:34
Message-ID: Pine.LNX.4.44.0304151451210.10246-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> The problem is that the dump contains \connect commands which require me
> to either authenticate or create *nix users and run ident - as far as I
> can tell. Ideally I'd like the super-user to be able to perform these
> connects silently - the initial authentication effectively happening at
> sudo time.

I suppose, using --use-set-session-authorization option in pg_dump command
must help. Refer the pg_dump manual page for more details.

regards,
bhuvaneswaran

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ben Clewett 2003-04-15 11:05:06 Re: Triggers
Previous Message A.Bhuvaneswaran 2003-04-15 09:16:14 Re: What version am I running?