On शुक्रवार, १९ एप्रिल, २०१९ १:३६:५८ म.उ. IST Amey Abhyankar wrote: > 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
You are redirecting in mid command? > > But If I put -N or -n & 'some_schema.another_*_pattern_*' it's not working. some_schema.another_*_pattern_* indicates object in that schema, not the schema itself. The intended usage of pattern seems to be, '-n *schema*' to include/exclude aschema1, bschema2 etc. What is exactly the error? what is the exact command that you are running? -- Regards Shridhar _______________________________________________ plug-mail mailing list plug-mail@plug.org.in http://list.plug.org.in/listinfo/plug-mail