| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Backing up a DB excluding certain tables |
| Date: | 2022-04-28 16:43:17 |
| Message-ID: | 22362.1651164197@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> writes:
>> *FYI, -n riopoderoso and the riopoderoso
>> in'riopoderoso."AspNetRoleClaims"' are redundant.*
> Should I remove the schema name so the exclude switch is *-T "AspNet"*
> instead of *-T 'riopoderoso."AspNet"'?*
No. As I explained upthread, you'd better use either
*."AspNet"*
or
riopoderoso."AspNet"*
because otherwise the pattern won't match tables that aren't in
pg_dump's restricted search_path.
I continue to think that your problem boils down to one of getting
the quoting around the double-quoted pattern correct. I'm not a
Windows user so I don't know much about shell quoting rules there.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-04-28 16:52:51 | Re: Privilege error with c functions during postgresql upgrade from 11 -> 13 |
| Previous Message | Shaozhong SHI | 2022-04-28 16:26:10 | Re: parallel-processing multiple similar query tasks - any example? |