Re: backup database tablespace with rsync? - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: backup database tablespace with rsync?
Date
Msg-id dcc563d10710200201p60165b55uc98ca82ef1fb4ead@mail.gmail.com
Whole thread Raw
In response to backup database tablespace with rsync?  (chester c young <chestercyoung@yahoo.com>)
List pgsql-sql
On 10/19/07, chester c young <chestercyoung@yahoo.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


pgsql-sql by date:

Previous
From: Mike Adams
Date:
Subject: Re: Refactored queries needing validation of syntactic equivalence
Next
From: Markus Schaber
Date:
Subject: Re: two queryes in a single tablescan