Hello Team, We are using PostgreSQL Version 9.6 and planning to archive our partition tables containing about 300 - 500 million rows . We have around ~ 50 partition tables to be archived to a new cold path PostgreSQL database , version 10.6. We have a requirement to filter few rows before exporting this data from these tables as we dont want to archive those rows .
What is a better approach to export and restore these tables ?. - Does COPY Command with a filter query to filter few rows using select works better ?. - pg_dump with filtering these rows ?. - Can i able to export my indexes , check constraints , constraints ?. - Any other options ?. Appreciate your replies. Thanks.
