Re: BUG #1249: pg_restore doesnt handle restoring databases - Mailing list pgsql-bugs

From Bill Schaub
Subject Re: BUG #1249: pg_restore doesnt handle restoring databases
Date
Msg-id Pine.LNX.4.56L0.0409102201280.27752@oybjre.pbfzvp-pbj.arg
Whole thread Raw
In response to Re: BUG #1249: pg_restore doesnt handle restoring databases not created as a superuser  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Fri, 10 Sep 2004, Tom Lane wrote:

> Hmm.  This is still broken in CVS tip, but I think the correct solution
> is just to replace "\connect db user" with "\connect db" everywhere.
> This will retain the starting real user authentication throughout the
> restore process.  We have completely abandoned use of \connect to change
> authorization, and this seems just an unintentional hangover from the
> old way.

Attached is a backport of your CVS commit to 7.4.5 it seems to work fine
here after some testing.

pgsql-bugs by date:

Previous
From: Rikardo Tinauer
Date:
Subject: Shared memory bug
Next
From: Tom Lane
Date:
Subject: Re: Shared memory bug