From: Joshua D. Drake <jd@commandprompt.com>
To: David Wilson <david.t.wilson@gmail.com>
Cc: John Smith <sodgodofall@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Backup/Restore of single table in multi TB database
Date: Wed, 7 May 2008 13:16:35 -0700
Message-ID: <20080507131635.436b6085@jd-laptop> (raw)
In-Reply-To: <e7f9235d0805071309o6d6d7778r6920e5df03a55d3b@mail.gmail.com>
References: <b88f0d670805071302h469141e0ke29413edddb444e0@mail.gmail.com>
<e7f9235d0805071309o6d6d7778r6920e5df03a55d3b@mail.gmail.com>
On Wed, 7 May 2008 16:09:45 -0400
"David Wilson" <david.t.wilson@gmail.com> wrote:
> I'm fairly certain that you have to be very careful about doing simple
> file copies while the system is running, as the files may end up out
> of sync based on when each individual one is copied. I haven't done it
> myself, but I do know that there are a lot of caveats that someone
> with more experience doing that type of backup can hopefully point you
> to.
Besides the fact that it seems to be a fairly hacky thing to do... it
is going to be fragile. Consider:
(serverA) create table foo();
(serverB) create table foo();
(serverA) Insert stuff;
(serverA) Alter table foo add column;
Oops...
(serverA) alter table foo drop column;
You now have different version of the files than on serverb regardless
of the table name.
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donateAttachments:
signature.asc (application/pgp-signature, 188B) download
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-performance@postgresql.org
Cc: jd@commandprompt.com, david.t.wilson@gmail.com, sodgodofall@gmail.com, pgsql-general@postgresql.org
Subject: Re: Backup/Restore of single table in multi TB database
In-Reply-To: <20080507131635.436b6085@jd-laptop>
* 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