Re: Automated restore? - Mailing list pgsql-novice

From A.Bhuvaneswaran
Subject Re: Automated restore?
Date
Msg-id Pine.LNX.4.44.0304151451210.10246-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Automated restore?  (Paul Makepeace <postgresql.org@paulm.com>)
List 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


pgsql-novice by date:

Previous
From: "A.Bhuvaneswaran"
Date:
Subject: Re: What version am I running?
Next
From: Ben Clewett
Date:
Subject: Re: Triggers