Greg,
I managed to get 2.0.4 running on PostgreSQL 8.4. Using this setup the changes
are replicating out. It must have been something in Slony 1.x & PostgreSQL 8.3
that was the issue.
Shaun McCloud – Associate Software Developer
Geo-Comm, Inc
601 W. Saint Germain St., Saint Cloud, MN 56301
Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666
click here to visit www.geo-comm.com
Think before you print!
Microsoft Certified Desktop Support Technician (MCDST)
Do or do not, there is no try.
-Yoda
-----Original Message-----
From: Greg Sabino Mullane [mailto:[email protected]]
Sent: Thursday, February 23, 2012 11:40
To: Shaun McCloud
Cc: [email protected]
Subject: Re: [Slony1-general] Slony not replicating changes
On Tue, Feb 21, 2012 at 02:25:39PM +0000, Shaun McCloud wrote:
> Greg, I populated one table with 100000 bogus records and that worked
> fine. If I add a second table it stops working.
>
> The setup is as follows. We use ESRI replication technology to get
> data from one ArcSDE instance into a PostgreSQL + PostGIS ArcSDE
> instance on our server. We then do a data only pg_dump on that
> database and a psql load on our "live" database. Slony is then
> supposed to replicate the data out to the "live" database on our other
> servers. The problem is occurring on the last step :(
Yeah, can't think of what else it might be. Probably the only thing to do at
this point, unless others on the list can think of things, is to edit one of
the dumps to limit to a few rows, load it via psql, then check the slony tables
(e.g. sl_log_1) to see if the triggers fired and how far it got. In other
words, where is it breaking down? My guess is that the triggers are not
populating the Slony tables for some reason, but there are other steps in which
it could break down.
--
Greg Sabino Mullane [email protected]
End Point Corporation
PGP Key: 0x14964AC8
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
