On 06/14/2014 11:15 AM, Kevin Grittner wrote:
Khangelani Gama <kgama@xxxxxxxxxxxx> wrote:
I am doing the following between master and the backup server
using archive_command,
I'm not sure what that means. Do you mean that while performing
the steps you describe, an archive command was active, copying WAL
files to an archive directory?
This is a follow up to a thread the OP started last week:
http://www.postgresql.org/message-id/ce3ab4298e3cc6f2751653d6f50f0342@xxxxxxxxxxxxxx
The relevant portion for the above is:
http://www.postgresql.org/message-id/36e864716fcb063194f5f95e5fc0b35c@xxxxxxxxxxxxxx
where the archive_command is:
while [ $test = "false" ]
do
rsync -a /pgsql2/data/${src}
postgres(at)10(dot)58(dot)101(dot)10:/pgsql2/walfiles/${dest} >>
/tmp/run_replication.sh.out 2>> /tmp/run_replication.sh.out
test=`ssh AB_CDS3 "if [ -f /pgsql2/walfiles/${dest} ];then echo
'true' ;else echo 'false';fi"`
if [ ${test} = "false" ]
then
echo "Test is false for CDS3, sleeping 10" >>
/tmp/run_replication.sh.out
sleep 10
cnt=$(( $cnt + 1 ))
if [ ${cnt} -ge 60 ]
then
message="Replication ERROR: Unable to send WAL
file(${desc}) from CDS to CDS3"
echo "`date` : ${message}" >>
/tmp/run_replication.sh.out
sendsms
fi
fi
done
So yes it would seem the OP has two rsync processes going on at the same
time.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
