Creating schema, database, or table in different folder.
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the
database to tape and one to exclude some tables from this backup. We
can selectively backup folders of the file system so we figure that if
we can create a schema or database or table in its own folder, we can
backup our database and exclude the tables selectively. We are using
Linux RedHat. Thank you.
Carlos Oliva wrote:
Is there a way to create a database or a table of a database in its own
folder?
You could use tablespaces for that bit, BUT:
We are looking for ways to backup the sytem files of the
database to tape and one to exclude some tables from this backup.
you can't do that with tablespaces. The write-ahead log is shared across
ALL the databases and all tablespaces. If your restore is missing some
files, the replay of the write-ahead log won't succeed. Your catalog
would also be out-of-sync with the actual data files. Your backup would
be broken.
If you want to do selective backups, use pg_dump, which has options to
include/exclude some tables.
(This needs a FAQ entry)
--
Craig Ringer