Re: pg_restore woes..

Upgrade to 7.3. There were some bugs in the TOC handling in 7,2.X.

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

Chris Bowlby wrote:
>
> Hi All,
>
> Ok, got one annoying issue with pg_restore, I'm trying to make use the
> re-order/remove option using a TOC listing. The catch is that no matter
> WHAT I do, it always imports the data for a particularily large table that
> I can get rid of or wait till the end of the import to have it stored. I
> current have the line that tells it to import it commented out and have
> even gone so far as to delete the line all together. It's as it the TOC
> internal to the tarred archive is overriding my override list... anyone
> got any ideas? I'm using 7.2.x, on FreeBSD, here's my command line:
>
> pg_restore -U pgsql -S pgsql -h site.test.com -p 5433 -F t -v -d database
> -x -O -L database.lst database.sql.tar
>
> Chris Bowlby,
> -----------------------------------------------------
> Manager of Information and Technology.
> excalibur(at)hub(dot)org
> www.hub.org
> 1-902-542-3657
> -----------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

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