Data duplication when moving datafiles from one server to another.

Поиск
Список
Период
Сортировка
От Iñigo Martinez Lasala
Тема Data duplication when moving datafiles from one server to another.
Дата
Msg-id 1292872960.20992.8.camel@deimos
обсуждение исходный текст
Ответы Re: Data duplication when moving datafiles from one server to another.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Data duplication when moving datafiles from one server to another.  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
Good evening.

Yesterday we experienced some data duplication in several database tables after one sysadmin decided to test in a production environment an rsync script in order to migrate a database from one server to another one.
Postgresql (8.2) was running in source server and rsync script was launched from second one. Second one server had a one day old copy of the same database. Rsync script create a datafile replica in destination server.
Our sysadmin swear he didn't launch the script in a reverse way (that is, from destination to source)... so my question is
How this data duplication could happen? Due to an rsync lock in checkpoint segment or transaction logs? Or he has mistaken source with destination server?

Thans in advance.


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Is any 'upgrade' required to move a 9.0.1 cluster to 9.0.2?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Data duplication when moving datafiles from one server to another.