Stack Overflow
Stack Overflow

Questions tagged [slony]

SLONY is a trigger-based replication engine for the PostgreSQL database.

In its primary website's own words, Slony-I is a "master to multiple slaves" replication system for PostgreSQL. It can replicate database clusters (or only selected objects) between different PostgreSQL versions and different hardware.

Documentation and tutorials can be found here. A comparison of available replication solutions in the PostgreSQL manual.

40 questions
9
votes
1 answer

Slony and PGPool for fail-over

We're considering Slony and PGPool as alternatives to handle failover in our application -and it seems like since we're gonna need at least two DB servers, we could take advantage of load balancing too- Under which circumstances Slony is better than…
SDReyes
  • 9,798
  • 16
  • 53
  • 92
4
votes
2 answers

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 ActiveRecord counter_cache. For clarity, assume the…
Christopher Foy
  • 758
  • 5
  • 13
4
votes
3 answers

Ruby On Rails Master-Slave Postrgres Databases

I am currently setting up a master-slave app using Ruby on Rails that needs to have a Master-Slave backend. I'm currently looking at using Slony for the replication component, and Masochism for handling the read/write connections to the different…
Chelsea
  • 6,751
  • 5
  • 29
  • 31
3
votes
3 answers

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 the data from MASTER to SLAVE: FATAL …
Experiment.Fail.Learn.Repeat.
  • 81
  • 1
  • 8
3
votes
1 answer

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 # slony_example #-- cluster name = $CLUSTERNAME; #-- # admin conninfo's are used by slonik to connect to the nodes one…
Gaurav
  • 157
  • 1
  • 2
  • 8
3
votes
1 answer

Replication with pgadmin+slony+ubuntu

I am using postgres 9.2 and slony1-2.0.0-rc1.The problem is that whenever i create slony-I cluster it shows slony-I creation scripts not available, only joining possible. I have also set the binary path usr/bin/postgresql but still its not…
Priyatam Roy
  • 431
  • 1
  • 5
  • 11
3
votes
2 answers

Automatically dropping PostgreSQL tables once per day

I have a scenario where I have a central server and a node. Both server and node are capable of running PostgreSQL but the storage space on the node is limited. The node collects data at a high speed and writes the data to its local DB. The server…
babcoccl
  • 159
  • 1
  • 7
2
votes
1 answer

Slony - slonik syntax issue

I'm trying to use the example that comes in the slony tutorial but it looks like there is a syntax error in their example. I've tried finding more documentation online but I've yet to really find good documentation showing how to use the slonik…
WildBill
  • 9,143
  • 15
  • 63
  • 87
2
votes
1 answer

Problems with Slony, pgAdmin and cluster replication

I'm having some problems with replication in pgAdmin. It says: Slony creation scripts not available. I use File > Options and indicate the path "usr/share/slony" where I suppose they are. Because that directory has xxid.v80.sql and all of them. My…
Ron
  • 2,215
  • 3
  • 22
  • 30
2
votes
0 answers

ERROR: Slony-I: Table is replicated and cannot be modified on a subscriber node

I recently restored a db (postgresql ver.9.3.5) from backup that was taken from a slony standby. The restored db is in separate environment from the backup source. But am getting below error when i attempted to insert a row. ERROR: Slony-I: Table…
v-node
  • 21
  • 1
2
votes
1 answer

PostgreSQL Slony replication - scheduled sync

I am migrating Oracle database into Postgres and I need to implement replication of the master database to multiple slave dbs. The replication should be executed once a day at specified time (to take the load off the dbs) and only replicate the data…
mix
  • 21
  • 4
2
votes
0 answers

Slony sync to 14 slaves, 13 slave works great, but 1 slave slow

I setup Slony on my 15 machines, all slon --version is 2.2.2, I download source code and compile the slon and slonik by myself. 1 Master and 14 Slaves, the slaves are located at diff office and connection are all via internet 13 slaves works great,…
wenchiching
  • 455
  • 7
  • 19
2
votes
2 answers

Slony "duplicate key value violates unique constraint" error

I have a problem which goes on for longer time. I use slony to replicate database from master to slave and from that slave to three other backup servers. Once a 2-3 weeks there is a key duplication problem that happens only on one specific table…
zordax
  • 35
  • 4
2
votes
2 answers

postgresql slony-i replication setup

Postgresql version: 9.1.2 PgAdmin iii version: 1.14.0 Operating system used: ubuntu 10.04 i have searched over the net to install and implement slony-i replication, but i couldn't find any proper guide to it..., i have went through some guides but…
MAHI
  • 9,263
  • 11
  • 36
  • 47
1
vote
1 answer

PostgreSQL : terminating connection due to administrator command postgresql

I found this error occurred after SQL insert statement was running. The SQL is called by store procedure which executed from Java. Please see as below. === 2012-03-23 20:39:13 Insert statement procedure executed === 2012-03-23 21:16:01…
Sathapanic Sriprom
  • 355
  • 2
  • 8
  • 15
1
2 3