From: Scott Marlowe <scott.marlowe@gmail.com>
To: chester c young <chestercyoung@yahoo.com>
Cc: sql pgsql <pgsql-sql@postgresql.org>
Subject: Re: backup database tablespace with rsync?
Date: Sat, 20 Oct 2007 04:01:20 -0500
Message-ID: <dcc563d10710200201p60165b55uc98ca82ef1fb4ead@mail.gmail.com> (raw)
In-Reply-To: <451865.61216.qm@web54302.mail.re2.yahoo.com>
References: <451865.61216.qm@web54302.mail.re2.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scott.marlowe@gmail.com, chestercyoung@yahoo.com
Subject: Re: backup database tablespace with rsync?
In-Reply-To: <dcc563d10710200201p60165b55uc98ca82ef1fb4ead@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox