User: Password:
|
|
Subscribe / Log in / New account

PostgreSQL 9.0 arrives with many new features

PostgreSQL 9.0 arrives with many new features

Posted Sep 22, 2010 17:28 UTC (Wed) by captrb (subscriber, #2291)
In reply to: PostgreSQL 9.0 arrives with many new features by smurf
Parent article: PostgreSQL 9.0 arrives with many new features

That seems like a fragile way to do things. Rather than have stored procedures cause side effects outside the database, what if you published events to a listen/notify queue, then have external processes reading the queues and cause the external state change. Have multiple queues for multiple recipients. The master and backup server would read the events from the currently-active database, failing over like the rest of your applications.


(Log in to post comments)

Slave servers vs. Stored Procedures

Posted Sep 22, 2010 18:55 UTC (Wed) by smurf (subscriber, #17840) [Link]

The operative word here is "queue". If I want to keep the database and the external world in sync, I can't queue my changes.

Of course, it's a trade-off, and has its own pitfalls (what if the stored procedure works on the master but fails on the slave?). But so has every other solution.


Copyright © 2017, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds