On Wed, 7 May 2008 16:09:45 -0400 "David Wilson" <david.t.wilson@xxxxxxxxx> 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/donate
Attachment:
signature.asc
Description: PGP signature
