1
vote
1answer
114 views

How can I set up an Amazon RDS for PostgreSQL database to act as a replica to a non-RDS PostgreSQL database?

I'm trying to set up an PostgreSQL database on Amazon RDS as a replica to another PostgreSQL database that lives on a regular server. Most of the instructions I've found online require shell access so ...
1
vote
1answer
81 views

Postgresql replicas stuck in recovery (archive_command won't run on replicas)

We're currently running a master -> slave, slave, slave, slave set up using postgresql 9.2.8 with streaming and WAL-E/S3 for handling wal segments. Should all of the replicas currently be "in ...
1
vote
1answer
189 views

PostgreSQL master constantly demoted by pacemaker with repmgr

I'm in the process of setting up a PostgreSQL 9.2.8 cluster made of 2 nodes, one master, and one slave. I use streaming replication and repmgr 2.0. My platform is RHEL 6.3. Master and slave can be ...
2
votes
1answer
151 views

Postgresql WAL-E - Replication falling behind + can't catch up

Does anyone know how I can have my replications process the WAL segments faster while using WAL-E? https://github.com/wal-e/wal-e I have one master that leverages WAL-E to upload to S3, and I have 6 ...
2
votes
1answer
351 views

Postgres replication falling behind - master -> slave, slave, slave

I currently have 1 master server (a) and 3 replication servers (b, c, d) that come directly from the master, the archive_command I use is the following script: https://gist.github.com/Geesu/8640616 ...
2
votes
2answers
236 views

pg_archivecleanup not found Postgres 9.1, even though it is installed?

I have streaming replication setup on 2 Postgres 9.1 servers. Everything is ok apart from the archivecleanup. In the logs it says: sh: 1: pg_archivecleanup: not found 2013-11-19 09:17:37 GMT WARNING: ...
3
votes
2answers
208 views

postgresql slave to master table replication

I currently have a few dozen sites pushing data to a central database over VPN with rsyslog. All these records are going into one table (there are roughly 20 - 30 per second being inserted per site). ...
1
vote
1answer
738 views

how to install pg_archivecleanup for postgresql 9.3 on Ubuntu

I am trying to get streaming replication working with postgresql 9.3 on Ubuntu 13.04 (Raring Ringtail). I installed postgresql on master and slave by doing: apt-get install postgresql I believe ...
1
vote
1answer
107 views

Best PostgreSQL HA strategy for 99% read scenario?

I'm in the process of building out a new PostgreSQL (9.3) environment in which traffic hovers around 99% read. We'll have 2 very powerful machines, connected via 1Gb ethernet. With the multitude of ...
0
votes
0answers
78 views

postgresql streaming replication not replicating until it reaches archive_timeout

Working primarily from this blog post I have managed to get replication working between two test servers. The master/server are supposedly set up to do streaming replication, with WAL archiving as a ...
1
vote
1answer
3k views

How do I fix issue causing “incomplete startup packet” log message trying to implement replication in Postgresql?

I've got two cloud servers running Ubuntu 13.04 and PostgreSQL 9.2. I've primarily used this blog post to aid me in setting things up. However, to do the initial database dump to the slave I'm using ...
1
vote
1answer
160 views

What are the options for any SQL Multi Master Master replication?

I am looking for a proper way to do Multi Master Master replication. I am currently using MySQL but open to switching to Postgres or Oracle if needed. So far the only solution I find is ...
1
vote
1answer
337 views

“Could not create IPv6 socket” postgresql standby error

I'm trying to create Postgresql 9.1 hot-standby using following steps: Configured 2 virtual linux machines. Master's ip: 10.10.10.1, Standby's ip: 10.10.10.2. Ping test passed. Restored the same db ...
2
votes
2answers
88 views

What's the most convenient method to ensure that PostgreSQL 9.x hot standy replication is still functioning properly

Assuming that I've got it hot server replication all set up nicely, what's the easiest or most convenient steps I can take periodically to ensure that the hot server replication is still working fine ...
1
vote
1answer
360 views

postgreSQL replication and failover with repmgr on Ubuntu

I'm new to Linux and have been tasked with setting up a redundant Linux DB server with PostgreSQL. preferably the fail-over needs to be automatic, but a manual process will be fine for now. What I ...
1
vote
1answer
125 views

Postgres 9.1 replication - force select operations to specific slave

I've configured postgres stand by replication using 1 master and 2 slaves. Master and slave1 are located in USA datacenter while slave2 is located in a datacenter in London. Is there any way of ...
1
vote
2answers
465 views

Postgres: Replicating over ssh at specific time frames

Can someone help me with the most common stable replication mechanism for postgres that I can run at specific times of a day(know it sounds weird) postgres that can run over ssh? Over ssh is ...
1
vote
2answers
703 views

Best PostgreSQL replication solution that minimizes network costs

I'm looking into PostgreSQL replication solutions. I know two varieties of these solutions Low level - which involves streaming log-shipping, hot-standby features available in PostgreSQL 9.x High ...
1
vote
0answers
169 views

PostgreSQL 1 master, multiple slave replication over slow links

I have a current use case in which remote computers query a central PostgreSQL database over a internet connection (read-only). We would like to implement a "stand-alone" system for these terminals so ...
3
votes
3answers
535 views

MySQL to PostgreSQL replication

Is there way to replicate in near-realtime MySQL changes to equal PostgreSQL database?
5
votes
2answers
637 views

How to scale out OpenStreetMap data efficiently

For over a year now, I'm running an in-house PostGIS server filled with OSM data, used for both Mapnik-based tile generation and Nominatim-based geocoding, updated with day replicates. This works ...
0
votes
2answers
206 views

Fault tolerant DBMail with PostgreSQL Replication - what are my options here?

I'm currently planning a more fault tolerant setup for my organizations Mail setup. We currently have two machines available in different datacenters, that we're planning to use for this, one being a ...
2
votes
2answers
759 views

Safe initial sync for SQL Server OLEDB/ODBC Replication

I am trying to setup one-way, transactional replication from SQL Server 2008 R2 to PostgreSQL 9.1. I'm trying out the PGNP OLE DB provider. I can successfully create a subscription, and transactions ...
2
votes
1answer
671 views

pg_basebackup: could not get WAL end position from server

I want to create a Base Backup with the pg_basebackup tool of postgres 9.1. After some seconds I receive: `pg_basebackup: could not get WAL end position from server What can be the reason for this ...
1
vote
1answer
534 views

Bucardo what to do on the remote side?

I'm trying to set-up bucardo in a master-slave setup with pushdelta, however I keep running into the following error when trying to create the sync. bash-4.1$ bucardo_ctl add sync dns ...
1
vote
1answer
235 views

PostgreSQL replication

I am looking at replication of the master database (PostgreSQL) and this is the configuration I have to setup master -- hot-standby (hs) | | --- read only slave (r1) | | --- read only slave (r2) My ...
0
votes
2answers
363 views

migrating from postgres 8.1 to 9.0

We are moving from one server with postgres 8.1 on it to another with 9.0 on it. We were looking to use slony to replicate between the two and already have slony-I 2 on that new server. However, it ...
1
vote
1answer
814 views

Replication in PG 9 between Windows and Linux boxes

I have PostgreSQL 9 running on Windows 2003 SP2. I am trying to replicate it on a Fedora 12 system running PostgreSQL 9 as well. I am hitting this error message: /usr/pgsql-9.0/bin/postgres -D ...
12
votes
7answers
9k views

USABLE multi-master replication for Postgres?

I tried Postgres-XC and it doesn't implement full SQL yet (like SERIAL) Postgres-R looks interesting but it's "not production ready" according to developers. So I used pgpool-II 3.0.1. Yes, it ...
2
votes
1answer
976 views

How do I remove Slony from a restored PostgreSQL database?

I've restored a database which came from a server on which Slony was running. The server on which the database has been restored does not have Slony installed. When the database restored, there were ...
5
votes
1answer
1k views

PostgreSQL 9: Does Vacuuming a table on the primary replicate on the mirror?

Running PostgreSQL 9.0.1, with streaming replication keeping one read-only mirror instance up to date. Auto-vaccuum is on on the primary, except for a few tables which are not vacuumed by the ...
3
votes
1answer
482 views

Current replication techniques in PostgreSQL

I'm planning to migrate from MySQL to PostgreSQL, but worried about the apparent luck of replications solutions there. Are there any current replication techniques that can be used out of box? ...
0
votes
2answers
4k views

How to use a distributed PostgreSQL database on a web site?

I want to host a web site, the back end will be a PostgreSQL database server. I would like to have multiple web servers, in different data centers for redundancy. I would then round robin DNS each web ...
2
votes
1answer
192 views

Shadowing MySQL and PostgreSQL to each other

I have a project currently based on PostgreSQL 8.1. However, some of the data processing for it needs to happen on a server for which 7.4 is the latest version (for now, only official packages via yum ...
2
votes
2answers
1k views

How do MySQL logs compare to Postgresql logs?

MySQL has quite a few logs: InnoDB transaction log Binary log General query log Error log Slow query log I know about Postgresql's WAL, which is equivalent to InnoDB's transaction log (correct?). ...
1
vote
3answers
775 views

Is MySQL Replication on Windows reliable?

We played a bit with postgresql and slony for a master-slave-slave replication setup on windows. But we hit a wall with failover/switchover which is very unreliable. How about MySQL? How reliable is ...
40
votes
10answers
5k views

PostgreSQL Replication

We constantly bat this around the office, and the question continues to come up. How do you deal with PostgreSQL replication? I'm not even necessarily talking about advanced clusters, just keeping it ...