From: Daniel Verite <daniel@manitou-mail.org>
To: Alanoly Andrews <alanolya@invera.com>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: [GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore?
Date: Sat, 02 May 2015 19:57:17 +0200
Message-ID: <a424fd94-8e5f-4e16-90c3-fa16841a07ec@mm> (raw)
In-Reply-To: <5a847d77e03244c8aa84f65b98cbc33e@exch1.invera.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Alanoly Andrews wrote:
> This table does not occur in the listing produced in step 1 above and so
> cannot be edited out
Yes, pg_largeobject is not mentioned but the TOC should have an entry named
BLOBS, as well as other entries related to each large object.
If "BLOBS" is removed or commented, pg_restore -L from that list should not
create any large object into the destination database.
As for the table that contain the "lo" column with the references to large
objects, it can be kept or removed from the restore list, it's up to you, but
it does not determine whether blobs are restored or not.
If the table is kept, its "lo" column will have dangling references to
non-existing large objects, but it's irrelevant for pg_restore, as it doesn't
track those references. You can always update that column to NULL after the
load, or ignore it, or drop it, whatever is more convenient.
Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: daniel@manitou-mail.org, alanolya@invera.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore?
In-Reply-To: <a424fd94-8e5f-4e16-90c3-fa16841a07ec@mm>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox