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