On Fri, 7 Dec 2007, Alex Vinogradovs wrote:
How about writing a C function (invoked from a trigger) that will send the serialized tuple using say UDP protocol (considering you're syncing on a reliable LAN), and then a simple UDP-listening daemon that will perform the insert into the slave one. If you have multiple slaves, can use that with broadcasting....
I think you are on your way to reinventing "Statement-Based Replication Middleware" using triggers and UDP. The great part is that you can look into the future and predict the problems you'll run into by reading that section of http://www.postgresql.org/docs/current/interactive/high-availability.html rather then waiting until you run into them yourself.
Seriously, though, not trying to knock you from taking a stab at the solution you suggest. Just pointing out that you'll be facing a bit more than just a trigger and getting the data moved over the LAN before you're done.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
