Re: Dump/Restore Large Object OID - Mailing list pgsql-general

From Norberto Delle
Subject Re: Dump/Restore Large Object OID
Date
Msg-id 4753E8F5.7070207@gmail.com
Whole thread Raw
In response to Dump/Restore Large Object OID  (Norberto Delle <betodelle@gmail.com>)
List pgsql-general
    Gurjeet Singh wrote:
> Why not give it a try once? Dump and restore once and see for
> yourself. You'd have done that by now, but if you haven't do give it a
> try instead of waiting any more. You may learn a thing or two in the
> process...
>
> On 11/29/07, *Norberto Delle* <betodelle@gmail.com
> <mailto:betodelle@gmail.com>> wrote:
>
>     Hi all
>
>     If I don't use the --oids option when dumping a database with
>     pg_dump,
>     can I assure that the "loid" field of the pg_largeobject table
>     will keep
>     it's value when restoring?
>
>
Of course, I already done that. I'm using pgAdmin to make database
backups\restores, without checking the "With OIDs" option and it
works well for the most of the cases. But sometimes referenced large
objects are not found after the restore, that's is why I'm asking.

pgsql-general by date:

Previous
From: Norberto Delle
Date:
Subject: Re: Dump/Restore Large Object OID
Next
From: "Christian Rengstl"
Date:
Subject: Archiving problem on Windows