In response to "Stéphane Schildknecht" <stephane.schildknecht@postgresqlfr.org>:
> Hi all,
>
> I tried the knewly introduced feature allowing one to exclude a schema
> from a backup with pg_dump, but I got a
> really strange error :
>
> pg_dump -U postgres MYDB -N "_MYDB" gives me a dump including that schema.
>
> I then tried pg_dump -U postgres MYDB -n "_MYDB" and then got "pg_dump:
> No matching schemas were found"
>
> Dumping the only public schema works. But, by doing so, I miss some
> other schema I really need.
>
> Is there a limitation I didn't catch ?
My guess is that you're hitting case-folding issues. Try:
pg_dump -U postgres MYDB -n \"_MYDB\"
--
Bill Moran
Collaborative Fusion Inc.
wmoran@collaborativefusion.com
Phone: 412-422-3463x4023