Tagged Questions
0
votes
0answers
19 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 ...
1
vote
1answer
31 views
How can I seperate reads and writes with a multi-db setup with django & postgresql?
as some of you are aware Django has multi-db support. This can be achieved by writing a dbrouter to send writes to the master database and all the reads to the slave, but as stated on the Django Docs ...
5
votes
1answer
215 views
PostgreSQL replication with rubyrep
I'm new to rubyrep and currently using rubyrep-1.2.0 version for PostgreSQL Master-Master replication. All data types except bytea are getting replicated properly. While replicating bytea column, it ...
-1
votes
1answer
39 views
Implementing High Availability, Load Balancing, and Replication using Warm Standby Using PUT method in windows platform [closed]
I have installed postgres SQL 9.0 version in my PC having window 7 OS.I want to implement the "High Availability, Load Balancing, and Replication" using Warm Standby Using PITR method
My system IP ...
0
votes
1answer
167 views
Bucardo add sync to replicate data
I am using Bucardo to replicate data in a database. I have one database, called mydb, and another called mydb2. They both contain identical tables, called "data" in both cases. Following the steps on ...
2
votes
3answers
57 views
Two or more tables that are mostly synchronized in database
I'm using PostgreSQL and I need to have two or more tables that are mostly synchronized in my database, such that an Add/Delete/Update to a row in sub table is made to the master table.
I'm not sure ...
2
votes
2answers
185 views
Data structure design for database replication support
I'm developing a small ad-hoc replication framework (for a reatil company), which replicates only certain records of certain tables (about 200) depending on specific domain-level logic.
In order to ...
0
votes
2answers
820 views
PostgreSQL Replication Tools
On the postgreSQL's wiki, on the "Replication, Clustering, and Connection Pooling" page ( http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling) , it shows the following ...
2
votes
3answers
986 views
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 ...
1
vote
2answers
286 views
Which built-in Postgres replication fits my Django-based use-case best?
I've noticed that Postgres now has built-in replication, including synchronous replication, streaming replication and some other variants. it even provides the ability to control synchrony for ...
1
vote
2answers
3k views
How to set up synchronous streaming replication in postgres?
I am trying to set up synchronous replication with Postgres 9.1, but I cannot get it to work. I was able to configure streaming replication, but not synchronous.
I hope I have not missed anything ...
0
votes
0answers
95 views
PostgreSQL Time-Based Database Replication [closed]
I'm evaluating solutions for multimaster database replication, and I have a question about scheduling time-based replication. I have two production environments in the cloud (Amazon EC2 instances) ...
1
vote
3answers
2k views
Error from postgresql 9.0 archiving while configuring hot streaming replication
I am trying to get streaming replication running on postgresql 9.0. I am following the steps as mentioned in the link : ...
5
votes
1answer
311 views
MongoDB Capped collection equivalent in PostgreSQL
The very basics of MongoDB capped collections is that they let you set maximum size of the table and the system will clear old data when the size limit is reached.
Has anyone came up with the similar ...
2
votes
1answer
771 views
PostgreSQL 9.1 streaming replication restore_command: special meaning of exit code 255?
I have a PostgreSQL 9.1.3 streaming replication setup on Ubuntu 10.04.2 LTS (primary and standby). Replication is initialized with a streamed base backup (pg_basebackup). The restore_command script ...
