| 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: | Whole Thread | Raw Message | 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 |