From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Julie Nishimura <juliezain(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: postgres backup question |
Date: | 2019-11-20 00:12:10 |
Message-ID: | 65d635f3-3d8f-713b-9723-5bc9e875b059@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | stan | 2019-11-20 00:32:03 | mysysconf ? |
Previous Message | Julie Nishimura | 2019-11-20 00:06:55 | postgres backup question |