Hi
In our production environment we use pg_dumpall to backup all the
databases of a cluster as there are 200+ databases in a cluster. Some
times there is a situation where we have to restore a single database
from a cluster. According to the postgres docs there is a pg_restore
utiltity which can be used to restore individual tables, schemas,
databases etc. But pg_restore requires the pg_dump to be in archive
format. With pg_dump we can use option -Fc to make the dump in non-plain
text format but I cannot use -Fc option with pg_dumpall. Is there a way
to import a single database from an export dump of a cluster? Your help
or guidance will be highly appreciated.
Thanks
Paramjeet Kaur
Professional Services and Motorola Broadband Solutions Group