Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Backup/Rest...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 12 Topic 15485 of 17437
Post > Topic >>

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

by jd@[EMAIL PROTECTED] ("Joshua D. Drake") May 7, 2008 at 01:16 PM

--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--
 




 12 Posts in Topic:
Backup/Restore of single table in multi TB database
sodgodofall@[EMAIL PROTEC  2008-05-07 13:02:57 
Re: Backup/Restore of single table in multi TB database
david.t.wilson@[EMAIL PRO  2008-05-07 16:09:45 
Re: Backup/Restore of single table in multi TB database
jd@[EMAIL PROTECTED] (&q  2008-05-07 13:11:25 
Re: Backup/Restore of single table in multi TB database
jd@[EMAIL PROTECTED] (&q  2008-05-07 13:16:35 
Re: Backup/Restore of single table in multi TB database
simon@[EMAIL PROTECTED]   2008-05-07 22:28:44 
Re: Backup/Restore of single table in multi TB database
tgl@[EMAIL PROTECTED] (T  2008-05-07 17:41:01 
Re: Backup/Restore of single table in multi TB database
sodgodofall@[EMAIL PROTEC  2008-05-07 15:24:22 
Re: Backup/Restore of single table in multi TB database
simon@[EMAIL PROTECTED]   2008-05-08 07:25:16 
Ubuntu question
theqmaster@[EMAIL PROTECT  2008-05-08 01:52:17 
Re: Ubuntu question
kleptog@[EMAIL PROTECTED]  2008-05-08 09:01:02 
Re: Ubuntu question
justin@[EMAIL PROTECTED]   2008-05-08 03:48:43 
Re: Backup/Restore of single table in multi TB database
simon@[EMAIL PROTECTED]   2008-07-19 10:02:32 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 12:18:33 CST 2008.