Slony is a popular, trigger-based replication solution for PostgreSQL.
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 ...
2
votes
3answers
235 views
Postgresql sync databases
I am having a postgres database on my portable and on a server. I would like to keep those two in sync as easy as possible. I know about slony but I am not able to figure out:
Does it work when the ...
2
votes
2answers
476 views
Slony lib not found
Trying to run the example slony config script in the documentation but getting the following error:
postgres$ /tmp/slonik_example.sh
<stdin>:8: PGRES_FATAL_ERROR load '$libdir/slony1_funcs'; ...
2
votes
2answers
112 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
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 ...
1
vote
1answer
243 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
1answer
145 views
Slony not replicating changes from a dump file
I’m working on a project where we are using pg_dump to get the data out of one database and then using psql to load it into another. The second database is the master db in a Slony replication ...
0
votes
1answer
132 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 ...
0
votes
0answers
22 views
Issue with slony-I replication on postgres master and slave database
I have two system with OS windows 8 and windows XP. I installed the postgres plus advance server for database replication on both system. I followed this link for whole process. But there is one issue ...
