[Pgpool-general] Copying databses in replication mode

[WC]

Yes, you can use rsync. There is even an example of it in Postgresql 9.1's Streaming Replication tutorial

http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial

rsync -av --exclude pg_xlog --exclude postgresql.conf data/* 192.168.0.2:/var/lib/postgresql/data/


________________________________
From: Аnton Тeihrib <teihrib at gmail.com>
To: pgpool-general at pgfoundry.org
Sent: Monday, October 24, 2011 7:49 PM
Subject: [Pgpool-general] Copying databses in replication mode


In replication tutorial for copying database from one host to another (on first stage of recovery)
"tar" and "cp" commands used. But for large databases it will be a lot of data to copy and 
overal process will consume from hours to days... So the question: is it possible to use rsync 
on pgdata folder instead of full cp? 
I suppose that in case of usual maintainance it will be not so much differneces between one server and another.
Best regards!

_______________________________________________
Pgpool-general mailing list
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20111024/e439ad1f/attachment.html>