Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time.
ERROR: cannot execute DELETE in a read-only transaction

I kept getting errors like that but I didn't think anything had changed with my company's PostgreSQL installation.  It turned out that there was a VIP that got applied to a secondary server (slave perhaps, made it a duplicate VIP) so nine times out of ten I was hitting the wrong server.  I hope this helps somebody in the future since I found no help on Google.
Posted on Monday, April 14, 2014 4:18 AM all tech stuff | Back to top

Comments on this post: postgres vip pointing to two servers

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Alex Bransky | Powered by: