From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-general@postgresql.org
Subject: Re: How to exclude blobs (large objects) from being loaded by pg_restore?
Date: Sat, 2 May 2015 16:24:59 +0200
Message-ID: <20150502142459.GA4086@tux> (raw)
In-Reply-To: <20150502153901.db26611a4c21d19f046b688c@wanadoo.fr>
References: <5a847d77e03244c8aa84f65b98cbc33e@exch1.invera.com>
<20150502153901.db26611a4c21d19f046b688c@wanadoo.fr>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
Vincent Veyron <vv.lists@wanadoo.fr> wrote:
> On Fri, 1 May 2015 14:12:08 +0000
> Alanoly Andrews <alanolya@invera.com> wrote:
>
> > Hello,
> >
> > We have a database that has been unloaded using pg_dump. This database has a table with a field defined as "lo". When restoring this database to another system, we want to avoid loading this particular table as it is very large (about 8GB of blob data) and is not needed on the target system. I tried the following:
> > 1. Create a list of all the tables in the pg_dump file using the -l option of pg_restore
> > 2. Edit out the lines corresponding to the said table (with the "lo" column)
> > 3. Run the pg_restore with the -L option to use the edited list of tables.
> >
>
> use the -T option of pg_dump?
i think, this isn't a solution.
i HAVE a complete dump, but now i need a restore without the lo - data.
And - you can't create a new dump with -T for several reasons now.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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: akretschmer@spamfence.net, pgsql-general@postgresql.org
Subject: Re: How to exclude blobs (large objects) from being loaded by pg_restore?
In-Reply-To: <20150502142459.GA4086@tux>
* 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