Re: pg_restore problem with 7.3.1 - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: pg_restore problem with 7.3.1
Date
Msg-id 200302180151.h1I1p1M27555@candle.pha.pa.us
Whole thread Raw
In response to Re: pg_restore problem with 7.3.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Did this ever get addressed?

---------------------------------------------------------------------------

Tom Lane wrote:
> Ian Burrell <ib@onsitetech.com> writes:
> > I just recreated the problem with a slightly different command.  The
> > problem was caused by using a list file to skip loading some function
> > definitions that were causing problems.  The command that loaded
> > everything into template1 was:
>
> > pg_restore -C -d template1 -L mpmx.lst -Ft mpmx.tar
>
> > It looks like the CREATE DATABASE call isn't done unless the -C flag is
> > included both when the list file is created and when doing the restore.
>
> Yeah, that seems to make sense.  I observe that -C causes an additional
> entry to be made in the list file:
>
> $ pg_restore -l r.tar >r.lst
> $ pg_restore -C -l r.tar >r.lstc
> $ diff r.lst r.lstc
> 13a14
> > 1; 0 DATABASE regression postgres
>
> and it makes sense that the actual CREATE DATABASE command would be
> issued when that TOC entry is processed (if -C was given).
>
> Offhand it seems to me that -l should produce this list-file entry
> always, regardless of -C; and perhaps "pg_restore -C -L" should
> complain if it doesn't find a DATABASE entry in the list (though I'm
> unsure how hard that is to implement).
>
> Philip, any comments?  Do you have time to fix this?
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-admin by date:

Previous
From: "Ed L."
Date:
Subject: Re: please help--database just locks up.
Next
From: Tom Lane
Date:
Subject: Re: server won't shutdown