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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
