From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: How to fully restore a single table from a custom dump?
Date: Tue, 9 Aug 2022 15:21:33 +0200
Message-ID: <9ca2d8ca-a175-630e-e449-48c2dee5e0f6@jakobs.com> (raw)
In-Reply-To: <1622540476.1110533.1660049347030@email.ionos.com>
References: <e434fe3f-0159-2223-8670-411d5c21c5bd@gmx.net>
<1622540476.1110533.1660049347030@email.ionos.com>
Am 09.08.22 um 14:49 schrieb MichaelDBA Vitale:
> Hi,
> If you use the directory dump method, -Fd, then you could generate an
> editable listing where you can selectively remove stuff that you don't
> want to restore, just keeping the stuff related to your specific
> table. You run pg_restore once to generate the listing. Then run
> pg_restore again using that modified listing to load into the target
> database. See the pg_restore docs for exact syntax.
> Regards,
> Michael Vitale
>> On 08/09/2022 8:06 AM EDT Thomas Kellerer <shammat@gmx.net> wrote:
>> Hello,
>> I just realized that using
>> pg_restore -t some_table ... some_dump_file
>> doesn't restore things like identity attributes
>> or indexes on the specified table.
>> The dump contains much more than just that table, so simply
>> using pg_restore without -t is not an option.
>> While I could extract the indexes manually using some clever regex
>> on the index names, I don't see a way to make sure that identity
>> definitions (or sequence values) are restored properly for the
>> selected table.
>> Any ideas, how I can _fully_ restore a single table from a custom dump?
>> Thomas
Creating a list of contained items and restoring some of them works the
same with custom dumps. Directory dumps have no advantage here.
Just comment out all items you don't want to restore by putting a ; in
front of the lines or delete the unwanted lines altogether and restore.
Best regards,
Holger
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
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: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: How to fully restore a single table from a custom dump?
In-Reply-To: <9ca2d8ca-a175-630e-e449-48c2dee5e0f6@jakobs.com>
* 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