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@argility.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.klaver@aklaver.com