[PLUG] How to take pg dump by excluding more than 1 schema?

Amey Abhyankar sco1984 at gmail.com
Fri Apr 19 13:36:58 IST 2019


Hello,

I have postgresql 9.x DB.
I want to take backup of 1 DB.
How to take backup from cmdline/bash using pgdump command?
I can not take backup using pgadmin or dbeaver UI due to some issues.

I can use = pg_dump -Fp -v -h mydbsvip.srv -U postgres app01 >
app01_data.dump --exclude-schema log

But If I put -N or -n & 'some_schema.another_*_pattern_*' it's not working.

Regards,
Amey.


More information about the plug-mail mailing list