Re: postgres backup question

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