Re: Backup/Restore of single table in multi TB database

--Sig_/3S/2EzfhARb6dUMDHz.HiPU
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

On Wed, 7 May 2008 16:09:45 -0400
"David Wilson" <david.t.wilson@[EMAIL PROTECTED]
> 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

=20


--=20
The PostgreSQL Company since 1997: http://www.commandprompt.com/=20
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/donate



--Sig_/3S/2EzfhARb6dUMDHz.HiPU
Content-Type: application/pgp-signature; name=signature.asc
Content-Disposition: attachment; filename=signature.asc

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIIg4jATb/zqfZUUQRApc0AJ0aAJcFUApUt8vfavAcIB4AYvVVSQCgpd7m
ALH+e2F+Cp6FgCvNrzo+Am0=
=nM2I
-----END PGP SIGNATURE-----

--Sig_/3S/2EzfhARb6dUMDHz.HiPU--