In response to "Stéphane Schildknecht" <stephane.schildknecht@xxxxxxxxxxxxxxxx>: > 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@xxxxxxxxxxxxxxxxxxxxxxx Phone: 412-422-3463x4023
