[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