slony
postgres slony-i master node tables can't be written after running for few days
I set up slony to replicate 3 tables from one opensuse pc (master node) to another opensuse pc (slave node). It works well at first. After running for few days, it suddenly come out the error message[详细]
2023-03-15 01:35 分类：问答PostgreSQL - Slony > FATAL ERROR: duplicate key value violates unique constraint "sl_nodelock-pkey"
Just posting this here and might help the others: I got this error when we had an outage a while ago, and tried to restart the slon replication service as the replication is NOT really replicating th[详细]
2023-01-16 08:27 分类：问答Postgres Slony-I question
Sample slonik command on the 1st node: slonik <<_EOF_ #-- # define the namespace the replication system uses in our example it is[详细]
2022-12-20 15:20 分类：问答ActiveRecord counter_cache giving stale count with multi_db gem
I\'m using the multi-db gem with Slony-I replication on PostgreSQL in a Rails app. This mostly works perfectly, but there is a bit of a replication lag in certain cases. One of the cases involves an A[详细]
2022-12-08 09:07 分类：问答
![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif)
加载中,请稍侯......