Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: pg_backup_archiver.c.diff
Description: text/plain (2.0 KB)

In response to

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group