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@hub.org
>  www.hub.org
>  1-902-542-3657
>  -----------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go 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