This is where custom scripting your dump comes in handy.
Inside the shell script you can dump only what you want. Specifically line by line. This is good because you don't
haveto touch the 'official dump' and can have all your stuff editable and restorable if needed.
Most large db's do this since order of operations can cause issues.
a separate for loop for indexes, tables, views, sequences, etc.
-----Original Message-----
From: Teja Jakkidi <teja.jakkidi05@gmail.com>
Sent: Tuesday, June 4, 2024 10:42 AM
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: [EXTERNAL] pg_dump and restore without indexes
Hello Admins,
I am trying to look for an option that can be added in pg_dump command to ignore all the indexes when creating the
schemadump with data.
Is there any such option that can be used in pg_dump? Or in pg_restore?
Please help with your inputs.
Thanks in advance,
J. Teja.