From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Kevin Grittner <kgrittn(at)ymail(dot)com>, Khangelani Gama <kgama(at)argility(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Using pg_start_backup() and pg_stop_backup() - using 9.1.2.2 |
Date: | 2014-06-14 19:03:45 |
Message-ID: | 539C9C91.9090302@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 06/14/2014 11:15 AM, Kevin Grittner wrote:
> Khangelani Gama <kgama(at)argility(dot)com> 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@mail.gmail.com
The relevant portion for the above is:
http://www.postgresql.org/message-id/36e864716fcb063194f5f95e5fc0b35c@mail.gmail.com
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-06-14 19:12:55 | Re: Using pg_start_backup() and pg_stop_backup() - using 9.1.2.2 |
Previous Message | Rich Shepard | 2014-06-14 19:03:11 | Re: Designing a DB for storing biological data |