Re: Replicate PostgreSQL with rsync

Поиск
Список
Период
Сортировка
От Sander Steffann
Тема Re: Replicate PostgreSQL with rsync
Дата
Msg-id 003801c3ae7f$9d8dc760$64c8a8c0@10ww.steffann.nl
обсуждение исходный текст
Ответ на Replicate PostgreSQL with rsync  (Jérôme Kestener <jkestener@yahoo.fr>)
Список pgsql-admin
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.

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Stef
Дата:
Сообщение: Re: Point-in-time data recovery - v.7.4
Следующее
От: Raquel Vieira
Дата:
Сообщение: Re: using vacuumdb in crontab