Excluding schema from backup

From: Stéphane Schildknecht <stephane(dot)schildknecht(at)postgresqlfr(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Excluding schema from backup
Date: 2006-12-08 09:33:17
Message-ID: 4579315D.3010205@postgresqlfr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Thanks by advance.

Stéphane Schildknecht

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-12-08 09:53:48 Re: Internal function call from C-language function
Previous Message Shoaib Mir 2006-12-08 09:17:46 Re: How to use outer join in update