Alan Hodgson wrote:
> On Tuesday 02 June 2009, "Carlos Oliva" <CarlosO(at)pbsinet(dot)com> wrote:
>
>> 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.
>>
>
> You can put them in their own tablespace, but backing them up would not be
> useful. Filesystem backups of the cluster must include the whole database
> to be useful (and see the documentation on PITR for how to do it right).
>
> You can easily back up single databases with pg_dump, though.
>
>
And pg_dump has a parameter to dump only a particular schema.
I'd also suggest that a schema is a unit of logical partitioning whereas
a tablespace is unit of physical partitioning and the need to back up
only certain tables suggests a difference /requirement at the logical
level to me, so I suspect schema is the more appropriate design choice
anyway.