From: | Teja Jakkidi <teja(dot)jakkidi05(at)gmail(dot)com> |
---|---|
To: | Erik Wienhold <ewie(at)ewie(dot)name> |
Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: pg_dump and restore without indexes |
Date: | 2024-06-04 17:58:24 |
Message-ID: | E700253C-6D81-4A9C-AE9C-52E0E6F6EAA2@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you, Erik.
Will try this option.
Also, is there a way we can remap schema or table during restore like how we have an option to remap in Oracle?
Thank,
J. Teja.
> On Jun 4, 2024, at 10:56 AM, Erik Wienhold <ewie(at)ewie(dot)name> wrote:
>
> On 2024-06-04 19:42 +0200, Teja Jakkidi wrote:
>> I am trying to look for an option that can be added in pg_dump command
>> to ignore all the indexes when creating the schema dump with data. Is
>> there any such option that can be used in pg_dump? Or in pg_restore?
>
> You can get the table of contents with pg_restore --list and remove or
> comment out the INDEX entries in that file. Then feed the TOC back into
> pg_restore with --use-list. The implicit indexes for primary key and
> unique constraints will still be created, though.
>
> --
> Erik
From | Date | Subject | |
---|---|---|---|
Next Message | Wetmore, Matthew (CTR) | 2024-06-04 18:15:07 | pg_dump and restore without indexes |
Previous Message | Erik Wienhold | 2024-06-04 17:56:13 | Re: pg_dump and restore without indexes |