On 2013-09-02 14:34, Michelle Sullivan wrote:
Christian Ritter wrote:
bucardo version is 4.5.0 <-got that from bucardo_ctl
-- Schema for the main Bucardo database
-- Version 4.5.0
The logs are from postgres, and there is no copy in the logs, only 2
inserts
Good... That should make things easier....
What do you get when you do:
SELECT DISTINCT d.rowid AS "BUCARDO_ID",
t.id ,host_ip,"prüfsumme"
FROM bucardo.bucardo_delta d
LEFT JOIN public.testtable t ON (t.id::int4 =
d.rowid::int4)
WHERE d.tablename = 28039::oid
AND NOT EXISTS (
SELECT 1
FROM bucardo.bucardo_track
bt
WHERE d.txntime = bt.txntime
AND bt.targetdb =
'testb'::text
AND bt.tablename =
28039::oid
);
on the source (should be one row) and:
SELECT DISTINCT d.rowid AS "BUCARDO_ID",
t.id ,host_ip,"prüfsumme"
FROM bucardo.bucardo_delta d
LEFT JOIN public.testtable t ON (t.id::int4 =
d.rowid::int4)
WHERE d.tablename = 28047::oid
AND NOT EXISTS (
SELECT 1
FROM bucardo.bucardo_track
bt
WHERE d.txntime = bt.txntime
AND bt.targetdb =
'testa'::text
AND bt.tablename =
28047::oid
);
On the target (should be no rows)?
Then what do you get when you do:
SELECT id::text AS id FROM public.testtable WHERE (id) IN (1);
on the source?
Also what OS and PostgreSQL version are you using?
Michelle
source:
BUCARDO_ID | id | host_ip | prüfsumme
------------+----+-------------+-----------
1 | 1 | 192.168.1.1 | foobar
(1 row)
target:
BUCARDO_ID | id | host_ip | prüfsumme
------------+----+---------+-----------
(0 rows)
source:
testa=# SELECT id::text AS id FROM public.testtable WHERE (id) IN (1);
id
----
1
(1 row)
OS is Ubuntu 12.04 and Postgres is Version 9.1.9, but was the same on
Slackware 14 and Postgres 9.2.1
Cheers
Christian
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
