Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [postgresql-replication]

23 questions
3
votes
2 answers

Enable logical replication on Google Cloud Postgres

Is there anyway to enable logical replication wal_level = logical on Google Cloud Postgres instance? I want to do CDC (change data capture) to stream WAL Record to Apache Kafka. Thanks for your help!
Kevin
  • 133
  • 4
3
votes
0 answers

Sync Local Postgres Database with Remote Database

My company is looking at creating a consolidated server that will serve as a backup for many remote servers who have separate data from one another, and provide an application where the aggregate data can be used for research purposes. I was going…
Caleb
  • 31
  • 4
3
votes
2 answers

How to store postgresql.conf outside of data dir?

I have used these steps to setup database replication on Postgresql 9.4. But, when using pg_basebackup, my entire database dir is copied, including the postgresql.conf file. However, that file is different for master and slave, so changes will be…
Bart Friederichs
  • 353
  • 1
  • 6
  • 23
2
votes
0 answers

Postgres-Repmgr node is marked as inactive after reboot

I'm using using a cluster with 2 psql servers. I'm using repmgr to manage replication and failover. Replication works fine, and when my master fail, the standby takes the lead. My problem is when I try to reup master as a slave. I use this…
Tartempion34
  • 143
  • 3
2
votes
1 answer

How can I start replication of on premise Postgres 8.4 into AWS RDS Postgres 9.x?

I wonder if you can help. I need to replicate a Postgres 8.4 database (master-slave style) from an on-premise server to an RDS instance on AWS running Postgres 9.x. I've read that Postgres > 9.0 has a nice replication mechanism, but before that…
migueldavid
  • 31
  • 4
2
votes
0 answers

How to automate failover of master in PostgreSQL 9.5 on Windows?

I have 4 nodes (version - PostgreSQL 9.5 Beta) in a slot replication set up. Recently the master node, due to less disk space available, PostgreSQL started throwing errors and crashed in the end. As I did not have any failover mechanism in place,…
deepankardixit90
  • 153
  • 2
  • 7
2
votes
1 answer

Slot replication not working in Postgres 9.4

I am using Postgres 9.4 on Windows 2008 server. There are three such instances that I am using. One as master and the rest of the two are slave/standby. The version of Postgres is 9.4 in all the three instances. I have set up replication using…
deepankardixit90
  • 153
  • 2
  • 7
1
vote
0 answers

zabbix 3.0 + pg_monz 2.0 + PostgreSQL streaming replication

I have a Zabbix 3.0 instance on CentOS 7.2, I've added the pg_monz extension for monitoring my PostgreSQL streaming replication. I currently have this in my Zabbix interface; DB1 host_groups PostgreSQL Linux Servers templates Template OS…
Michael
  • 11
  • 1
1
vote
1 answer

Why should postgresql.conf not be in the same dir as recovery.conf?

Apparently, I should put postgresql.conf in a separate directory, according to this: # Note that recovery.conf must be in $PGDATA directory. # It should NOT be located in the same directory as postgresql.conf Is there any particular reason? I've…
Parthian Shot
  • 1,155
  • 3
  • 16
  • 32
1
vote
0 answers

Postgresql - Master\Slave Async Replication - How to quickly fail back and forth?

I have two hosts set up as very simple master\slave. All servers connect to the floating IP 10.1.1.10. Host A: Designation: Master Floating IP - 10.1.1.10 Standard IP - 10.1.1.11 relevant pg_hba.conf - these match so I can fail back\forth host…
NOC_Ninja982134
  • 13
  • 3
0
votes
0 answers

PostgreSQL recovery.conf archive_cleanup_command parameter

I have a setup of PostgreSQL 9.6 under windows and a hot stand by under windows too. In the recovery.conf file I've setted up archive_cleanup_command = '"C:\Program Files\PostgreSQL\9.6\bin\pg_archivecleanup.exe" "C:\Replication\ARCHIVELOG\"…
Luciano César Natale
  • 65
  • 2
  • 10
0
votes
1 answer

Postgres initial replication taking long time

My Master postgres db is currently < 100 mb. I am doing the initial replication on another machine, using command pg_basebackup -h 'masters_ip' -D /1TBdisk/postgres/ -U replica -v -P But its going very slow, and appears to be downloading a huge…
NRJ
  • 101
  • 2
0
votes
0 answers

Postgres Shared Memory Issue

I'm unable to restart my postgres server. I believe it is related to it's attempted usage of shared memory. Host is Ubuntu 14.04.05 LTS Postgres is 9.5 root@host:/# ls -lah /run/shm/ total 0 drwxrwxrwt 2 root root 40 Oct 21 17:42 . drwxr-xr-x…
bearrito
  • 381
  • 3
  • 16
0
votes
2 answers

Postgresql HA PITR

I've had success in the past with MySQL's delayed replication feature which allows you to stop replication, inspect the bin log to find a bad query and SLAVE UNTIL just before said query and skip over it. Since Postgresql introduced the…
Jason
  • 163
  • 1
  • 1
  • 7
0
votes
0 answers

postgresql log shipping doesn't seem to work

There are two servers. One is the on-site database server; the other is the off-site backup server. Since the on-site database server already contains just shy of 900G of data, backups are important. Originally, we used a daily pg_dumpall, but for…
Wouter Verhelst
  • 418
  • 3
  • 8
1
2