Re: Schema, databse, or tables in different system folder

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Schema, databse, or tables in different system folder
Date: 2009-06-05 15:07:43
Message-ID: 200906050807.43592@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday 02 June 2009, "Carlos Oliva" <CarlosO(at)pbsinet(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2009-06-05 15:10:26 Re: invalid byte sequence for encoding "UTF8": 0xab
Previous Message Alan Hodgson 2009-06-05 15:07:11 Re: Schema, database, or tables in different folders?