postgres backup question
Hello,
What is the best way to dump/restore the entire database except couple of largest tables, what is the best way to do it on PostgreSQL 9.4.1 on x86_64-unknown-linux-gnu?
Thank you
On 11/19/19 4:06 PM, Julie Nishimura wrote:
Hello,
What is the best way to dump/restore the entire database except couple
of largest tables, what is the best way to do it on PostgreSQL 9.4.1 on
x86_64-unknown-linux-gnu?
https://www.postgresql.org/docs/11/app-pgdump.html
-T table
--exclude-table=table
Do not dump any tables matching the table pattern. The pattern is
interpreted according to the same rules as for -t. -T can be given more
than once to exclude tables matching any of several patterns.
When both -t and -T are given, the behavior is to dump just the
tables that match at least one -t switch but no -T switches. If -T
appears without -t, then tables matching -T are excluded from what is
otherwise a normal dump.
Thank you
--
Adrian Klaver
adrian.klaver@aklaver.com