On 07/03/2016 11:42 AM, Andy Colson wrote:
>
> Now that I think about this more, I think you're on to something.
> I'm trying to get an _exact_ copy of the master db onto the slave.
> Checking rsync man, it matches only on size and modified time, and I
> didn't include deletes.
>
> I'm going to re-try with this:
>
> select pg_start_backup('clone',true); rsync -av --delete --checksum
> --exclude pg_xlog --exclude postgresql.conf /pub/pg95/*
> web2:/pub/pg95/ select pg_stop_backup(); rsync -av --delete
> --checksum /pub/pg95/pg_xlog web2:/pub/pg95/
>
> That should make sure the copies are exact.
>
>
> -Andy
>
>
>
That seemed to have worked. Took forever, but once I started the slave on web2 I was able to login and run queries
withoutany errors or problems.
Thanks Adrian,
-Andy