Search Postgresql Archives

Re: Dump/Restore Large Object OID

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



   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@xxxxxxxxx <mailto:betodelle@xxxxxxxxx>> 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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux