Re: Using pg_start_backup() and pg_stop_backup() - using 9.1.2.2

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