Hi,
I am trying to replicate a PostgreSQL database with rsync.
Does anyone have a experience with that?
We wanted to transfer a database to another machine with the minimum amount of downtime. We used rsync to make a copy of the database while PostgreSQL was running. this ofcourse is NOT a consistent copy. Then we shut down the database and we used rsync to copy all the differences from the first machine to the second, to make sure that the second machine had a consistent database.
You'll have to shutdown the database to make the final transfer, but you can use rsync to do a lot of work while the database is still running.
Good luck,
Sander.
