[check_postgres] ERROR: Cannot test replication: values are not the same

[Greg Sabino Mullane]

On Wed, Nov 26, 2014 at 10:20:17AM +0530, Juned Khan wrote:
> I have setup replication using Bucardo.I have checked the values in both
> databases it it different  also when I tried to make it same manually but
> it keeps changing.

Not sure what you mean by it keeps changing?

> check_postgres.pl --action=replicate_row  --host=localhost,192.168.1.15
> --dbname=mydb --warning=10 --repinfo=ip_map,id,44399,name,slon,nols
> 
> Any thoughts on this how to fix this problem ?

The message means that in the ip_map table, the value of the "name" 
column is not the same for the row identified by a pk value of 44399 
in the id column. You need to get both the same, either by running this 
on both databases:

UPDATE ip_map SET name = 'slon' WHERE id = 44399;

Or just running it on one that is being used as a source and letting Bucardo 
push the changes to the other side.

The idea is to use a row that is normally not changed by any external action, 
such that check_postgres is the only thing manipulating that row. Usually this 
means a test or dummy row in the table in question.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20141126/886f0970/attachment.sig>