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 have to 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@xxxxxxxxx> Sent: Tuesday, June 4, 2024 10:42 AM To: pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx> 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 schema dump 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.
