Tagged Questions
2
votes
2answers
111 views
Teaching Slony replication to select slave nodes
There is a system with up to 256 nodes in db cluster. We need to replicate some data from one of them across to all others. But for every row to replicate there is a list of nodes where it must be ...
1
vote
1answer
238 views
Slony initial subscription is causing out-of-memory kernel panics. Why?
Context:
We run Slony 2.0 with Postgres 8.4 on two CentOS 6 servers--one master, and one slave. Our database is about 30GB in size, which isn't unusual, but we do have a couple of tables that are ...
1
vote
2answers
156 views
Can I replicate views with Slony?
Can I feed some SQL that creates a view to Slony?
I have some SQL that does CREATE OR REPLACE VIEW name_of_view and so on, passes it to slonik_execute_script, and then tries to run slonik_create_set ...
0
votes
1answer
129 views
Slony - Wait for Event
What is the behavior of Slony waiting for an event after lock set command?
Basically I am trying to do a switchover and it takes a lot of time. We are following these steps:
Lock Set
Wait for Event ...
6
votes
2answers
1k views
Streaming replication and failover on PostgreSQL
I am doing a proof of concept on PostgreSQL replication. After the discussion on forum we decided to go with streaming replication as the performance is good compared to other solutions. PostgreSQL is ...
