Re: Excluding schema from backup

In response to "Stéphane Schildknecht" <stephane(dot)schildknecht(at)postgresqlfr(dot)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(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023