Re: TR: Issue: --exclude-schema flag not working with pgrestore

Hi again,

I was wondering though, do you know why it is different from pgdump -N behavior (Do not dump any schemas matching pattern) ?

Julien ROCHER
Développeur Team Data - Migration

Emeria Technologies
76-78 Avenue des Champs Elysées – 75008 Paris
06 17 17 60 64
julien(dot)rocher(at)emeria(dot)eu<mailto:julien(dot)rocher(at)emeria(dot)eu>

De : ROCHER Julien <julien(dot)rocher(at)emeria(dot)eu>
Date : mercredi, 11 janvier 2023 à 15:16
À : Julien Rouhaud <rjuju123(at)gmail(dot)com>
Objet : Re: TR: Issue: --exclude-schema flag not working with pgrestore
Ok thank you for you feedback

Julien ROCHER
Développeur Team Data - Migration

Emeria Technologies
76-78 Avenue des Champs Elysées – 75008 Paris
06 17 17 60 64
julien(dot)rocher(at)emeria(dot)eu<mailto:julien(dot)rocher(at)emeria(dot)eu>

De : Julien Rouhaud <rjuju123(at)gmail(dot)com>
Date : mercredi, 11 janvier 2023 à 14:27
À : ROCHER Julien <julien(dot)rocher(at)emeria(dot)eu>
Objet : Re: TR: Issue: --exclude-schema flag not working with pgrestore
On Wed, Jan 11, 2023 at 10:43:10AM +0000, ROCHER Julien wrote:
>
> Indeed this partially solved the problem. However, although it doesn’t try to
> restore the “country.number" table, it still tries to create the “country”
> schema. Do you think it’s wanted ?

Yes that's the wanted behavior. Per documentation:

-N schema / --exclude-schema=schema
Do not restore objects that are in the named schema

So it filters objects **in** the schema but not the schema itself.

If you want to also ignore the CREATE SCHEMA order, or some fancier behavior,
you need to use the --list / --use-list and cherry pick the parts you want to
keep or discard.