Re: backup database tablespace with rsync?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "chester c young" <chestercyoung(at)yahoo(dot)com>
Cc: "sql pgsql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: backup database tablespace with rsync?
Date: 2007-10-20 09:01:20
Message-ID: dcc563d10710200201p60165b55uc98ca82ef1fb4ead@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 10/19/07, chester c young <chestercyoung(at)yahoo(dot)com> wrote:
> postgres A, db 'test', tablespace /pg/test1
> postgres B, db 'test', tablespace /pg/test2
>
> tablespace /pg/test1 only has A db 'test'
> tablespace /pg/test2 only has B db 'test'
>
> if
> - A and B shut down
> - /pg/test1 copied to /pg/test2
> - A and B restarted
>
> would B db 'test' be running the data that was in A db 'test'?

You can't rsync just pieces of the db. you have to copy the whole database

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2007-10-20 10:58:24 Re: [SQL] two queryes in a single tablescan
Previous Message Mike Adams 2007-10-20 05:45:11 Re: Refactored queries needing validation of syntactic equivalence