From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: pgsql-admin@postgresql.org
Subject: Data duplication when moving datafiles from one server to another.
Date: Mon, 20 Dec 2010 20:22:40 +0100
Message-ID: <1292872960.20992.8.camel@deimos> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: imartinez@vectorsf.com
Subject: Re: Data duplication when moving datafiles from one server to another.
In-Reply-To: <1292872960.20992.8.camel@deimos>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox