Re: Schema, databse, or tables in different system folder - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Schema, databse, or tables in different system folder
Date
Msg-id 200906050807.43592@hal.medialogik.com
Whole thread Raw
In response to Schema, databse, or tables in different system folder  ("Carlos Oliva" <CarlosO@pbsinet.com>)
List pgsql-general
On Tuesday 02 June 2009, "Carlos Oliva" <CarlosO@pbsinet.com> wrote:
> Thank you for your response.  The tablespace should work for us.  Perhaps
> you can help me with the following questions:
>
> 1) If we were to create a different table space for a database that has
> archival tables -- they will be backed up once, is it sufficient to
> backup the tablespace folder once?  We want to make sure that we can
> restore from tape the tablespace folder and we will in fact restore the
> full database and data
>

This will absolutely not work.

--
I contend that for a nation to try to tax itself into prosperity is like a
man standing in a bucket and trying to lift himself up by the handle.
 -- Winston Churchill

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Schema, database, or tables in different folders?
Next
From: Vick Khera
Date:
Subject: Re: invalid byte sequence for encoding "UTF8": 0xab