Re: pg_dump + function/table hierarchy - Mailing list pgsql-hackers

From Kovacs Zoltan Sandor
Subject Re: pg_dump + function/table hierarchy
Date
Msg-id Pine.LNX.4.05.10007312049230.17860-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
In response to Re: pg_dump + function/table hierarchy  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
> This is fixed in the next version as well as an experimental version for
> 7.0.2 found at:
> 
>     ftp://ftp.rhyme.com.au/pub/postgresql/pg_dump/blobs/
> 
> The solution (as suggested by Tom Lane) was to sort the items by OID before
> dumping them. This is not a perfect solution, but it will cover 95% of cases.
I tried this new pg_dump. It worked for me very well. But, for a
database with 10000 rows it wasn't too fast dumping out (twice slower than
the original one) and restoring it was three times slower.

Thanks again, Zoltan



pgsql-hackers by date:

Previous
From: hstenger@adinet.com.uy
Date:
Subject: Re: Now PostgreSQL recovers from errors within trns
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: Now PostgreSQL recovers from errors within trns