Обсуждение: 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