Setting the verbose mode (which usually uses to be very usefull ;) ), showed me
something like this while restoring :
BEGIN, still in transaction (more or less)
which made me think that the autocommit was disabled. This feature in series 7.3.x
is very usefull to me but, as I checked,
in the restore file there are two BEGIN's. That avoided pg_restore to resolve the
OID's succesfully.
Right now, turning the autocommit to true, while restore (and disabling it later),
allows me to restore any database.
Thanks for your interest,
Gustavo
"Kuhn, Dylan K (4520500D)" wrote:
> I've successfully dumped and restored a database containing large objects with 7.3.3
> and previous versions. I've used the 'tar' archive format something like this:
>
> % pg_dump -F t -b dbwithlos | gzip > dump.tar.gz
> % zcat dump.tar.gz | pg_restore -d restoredbwithlos
>
> Dylan Kuhn
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
