Re: How to create directory format backup

Hi!


>> How to create backup in format from which tables can selectively restored?
> Dump as custom-format archive (-F custom) and use that with pg_restore and
> options --table or --list/--use-list to select what should be restored.

How to select tables interactively like pgAdmin allows to select when 
directory format is used ?

Database contains hundreds of schemas. I need to restore public and 
other other schema.

Whole backup file is scanned to restore only two schemas. It takes lot 
of time.

Also directory format allows to use all cores with --jobs=32 parameter. 
Dump and partial restore using custom format are much slower.

Andrus.


> --
> Erik