Re: Dump/Restore Large Object OID

From: Norberto Delle <betodelle(at)gmail(dot)com>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump/Restore Large Object OID
Date: 2007-12-03 11:31:01
Message-ID: 4753E8F5.7070207@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com
> <mailto:betodelle(at)gmail(dot)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.

Browse pgsql-general by date

  From Date Subject
Next Message Martin Marques 2007-12-03 12:15:59 Re: full_page_writes = off?
Previous Message Christian Rengstl 2007-12-03 11:29:39 Archiving problem on Windows