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 <[email protected]>
To: [email protected]
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
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
