Skip to main content

Questions tagged [slony]

Slony is a popular, trigger-based replication solution for PostgreSQL.

Filter by
Sorted by
Tagged with
14 votes
2 answers
5k 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 ...
Saurabh's user avatar
  • 141
7 votes
1 answer
4k views

Partial (filtered) replication in PostgreSQL

My setup looks something like this: I have a primary server (Postgres 9.6) that continually scrapes a bunch of data from the web. I'd like to be able to stream a subset of tables or databases from ...
jeancochrane's user avatar
3 votes
0 answers
1k views

Slony with Amazon's RDS service?

Is it actually possible to somehow use Slony with Amazon’s RDS service? I’m aware that there’s no such thing as a host that you can log into to make Slony’s configurations, but perhaps it can be done ...
Gonzalo Vasquez's user avatar
2 votes
2 answers
652 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 ...
Zac B's user avatar
  • 526
2 votes
2 answers
3k 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'; ...
WildBill's user avatar
  • 535
2 votes
3 answers
2k 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 ...
MortenSickel's user avatar
2 votes
1 answer
3k views

How to install Slony for 64-bit PostgreSQL 9.3 on Windows?

I have installed 64-bit version of PostgreSQL 9.3.5 from EnterpriseDB installer. Now I want to install Slony-I through Application Stack Builder, but it offers only 32-bit version of Slony, ...
Pavel V.'s user avatar
  • 747
2 votes
1 answer
128 views

Slony Replication: Will data eventually be 100% replicated if daemon dies for long period?

I am using Slony to replicate a Postgres database. If my slony daemon exits for whatever reason, and doesn't start up hypothetically until 1 month later, will all the data that has accumulated in the ...
Henley Wing Chiu's user avatar
2 votes
2 answers
329 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 ...
Gonki's user avatar
  • 121
2 votes
0 answers
3k views

Slony-I creation scripts not available; only joining possible

I try to start Slony replication. I have PostgreSQL 9.3.4, PgAdmin III 1.18.1 and Slony-I 2.2.0-1. I have set the path to Slony to D:\GIS\PostgreSQL\9.3\share where I have the Slony files. Whenever I ...
Pavel V.'s user avatar
  • 747
1 vote
1 answer
563 views

Replicating from master to slaves and from slaves to master

I have a master and multiple slave machines. All SQL operations on the master node should be sent to the slave nodes. But the tables on the slave nodes may also be written to locally. These local ...
Alptugay's user avatar
  • 145
1 vote
2 answers
471 views

Slony Replication in PostgreSQL

Objective : Set up two DB server if first server down then second can be up and running provided condition is that at evening time both server need to sync. with each other I am new in DBA and we are ...
Sunil's user avatar
  • 125
1 vote
1 answer
626 views

PostgreSQL Replication on a daily basis

With PostgreSQL, I want to replicate a subset of all tables from Database A to B, but only once a day. Since I do not know what to search for: is there a technical term for such a scenario? Does e.g. ...
Matthias's user avatar
  • 127
1 vote
1 answer
480 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 ...
Zac B's user avatar
  • 526
1 vote
1 answer
344 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 ...
smccloud's user avatar
  • 111
1 vote
0 answers
308 views

PostgreSQL Multi Master Single Slave Replication

I have multiple transaction PostgresQL 9.4 databases and a single publication read-only database. Is there any replication mechanism (asynchronous) to push every updated transaction from every ...
Papios's user avatar
  • 11
1 vote
0 answers
565 views

pgAdmin Slony Creation Scripts

I have installed pgAdmin 1.18.1 but whenever I am trying to create a new cluster using Slony-I, it is always saying that it is missing some scripts. I have copied some .sql scripts from my Slony ...
Doron's user avatar
  • 11
0 votes
2 answers
1k 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 (...
user1159389's user avatar
0 votes
1 answer
253 views

Postgres Replication

Is there any technology to replicate a table from public schema on the master server to a table on the slave server but not in the public schema. MASTER SERVER SLAVE ...
Charif DZ's user avatar
  • 101
0 votes
1 answer
342 views

Slony-I replication stopped working

I inherited a 5 node postgres cluster running postgres 8.4 and slony 1.2.21. We are in the process of migrating the application to all new code and have not wanted to do very little maintenance on the ...
Chris Hinshaw's user avatar