Re: BUG #1249: pg_restore doesnt handle restoring databases

From: Bill Schaub <talon(at)cosmic-cow(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1249: pg_restore doesnt handle restoring databases
Date: 2004-09-10 22:34:18
Message-ID: Pine.LNX.4.56L0.0409102201280.27752@oybjre.pbfzvp-pbj.arg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Attachment Content-Type Size
pg_backup_archiver.c.diff text/plain 2.0 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Theodore Petrosky 2004-09-10 22:36:35 Re: problems with OS X and beta 2
Previous Message Aidan Dixon 2004-09-10 20:53:51 Re: BUG #1250: compilation fails in src/backend/storage/lmgr/s_lock.c