Questions tagged [postgresql-replication]
The postgresql-replication tag has no usage guidance.
28
questions
0
votes
0
answers
11
views
Unable to setup pglogical replication between 2 GCP CloudSQL instances
I'm currently trying to setup pglogical replication between 2 GCP CloudSQL Postgres instances, in order to quickly migrate data between regions.
I've following the GCP docs[1] by creating a replicator ...
0
votes
0
answers
21
views
pg_rewind: ERROR: could not fetch remote file "global/pg_control": ERROR: permission denied
I came across this error notice when trying to execute pg_rewind through repmgr's old primary demotion to standby after recovery. (the old standby @192.168.1.2 has already executed repmgr standby ...
- 530
0
votes
0
answers
32
views
How can I still be able to write to primary postgresql while replication is absent?
It turned out to be my script failed to reload postgresql due to authentication error. So everything below is a false issue of postgresql. After I fixed the bug, postgresql allowed me to write to the ...
- 530
0
votes
0
answers
29
views
Why are changes not synced to replica instances on Kubegres Cluster?
I have set up a Postgres on Kubernetes cluster with Kubegres with 3 instances - 1 master and 2 replicas. Now, I am facing the problem that the replication doesn't really work. What is synced, is when ...
- 1
0
votes
0
answers
82
views
PostgreSQL Subscribers and Publishers (Multi-Master Scenario)
I'm currently trying to develop a solution that would be trying to focus on Multi-Master Databases
So here is how it's supposed to operate
I want so that whenever an Agent makes a change to a database,...
- 101
0
votes
0
answers
919
views
gvmd service not starting after postgresql replication - openvas
I deployed two openvas servers on two distinct VMs (Debian 10) with postgresql version 11. I replicated the postgres 11 using with hot standby configuration, the data is getting replicated but after ...
- 1
1
vote
0
answers
450
views
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....
0
votes
0
answers
823
views
How to switch standby to master on postgresql 13?
For High Availability on DB was build Active-Standby(replica) cluster on Postgresql-13. Inserting data correctly transfer to 'replica' server, it is ok.
Now, I want check case, how i can make change ...
- 15
0
votes
1
answer
341
views
repmgr for streaming replication - standby register
I'm testing repmgr tool and I'm a little bit confused. Everything's fine until standby register step.
What should I have configured on standby server? From docs I assumed that standby should't have ...
- 485
0
votes
0
answers
68
views
I can't get the postgres installation correctly
I have spent quite a bit of time to install postgresql 11 on the high side production, but I just can't quite get it installation and configured correctly after I yum install
rpm -i postgresl11-server-...
- 1
0
votes
1
answer
218
views
Can system load on a postgresql replica impact the performance of the source database?
I've created a postgresql replica database to mirror the content of my production database and want to be sure that queries against the replica can never impact the production server. How safe am I?
...
0
votes
0
answers
241
views
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\...
3
votes
2
answers
2k
views
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!
google-cloud-platform
3
votes
0
answers
1k
views
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 ...
- 31
0
votes
1
answer
101
views
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 ...
- 101
3
votes
2
answers
496
views
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 ...
- 353
2
votes
0
answers
2k
views
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 ...
- 143
0
votes
0
answers
669
views
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
...
- 380
0
votes
2
answers
114
views
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 ...
- 163
2
votes
1
answer
1k
views
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 ...
- 131
0
votes
0
answers
132
views
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. ...
- 438
1
vote
0
answers
630
views
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
...
- 11
1
vote
1
answer
643
views
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 ...
- 1,165
0
votes
1
answer
1k
views
Setting up Postgres hot standby in AWS
We have a Posrgres 9.5 database running on an EC2 in AWS and we're trying to set up a hot standby. The server has around 3TB of data, so backing up is not a quick task.
I initially tried to create a ...
- 189
2
votes
0
answers
701
views
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 ...
- 163
0
votes
1
answer
3k
views
Postgres 9.5 server not starting due to already active replication slot
I have a Postgres (version - 9.5 Beta) server replication set up where there are 3 slaves and a primary server. After all required configuration is done, I start 1st slave after taking base backup and ...
- 163
3
votes
1
answer
5k
views
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 ...
- 163
0
votes
1
answer
1k
views
Slony PostgreSQL replication - Can I create an index on a table on a slave that isn't on the master?
I have just set up a slony replication set up between 2 postgres servers. One master, and one slave host. Data is being copied. We don't want to use this for data backup or anything, but want to do ...
- 31.6k
Related Tags
postgresql × 24
database × 3
replication × 3
slony × 2
zabbix × 1
sql × 1
psql × 1
amazon-rds × 1
openvas × 1
kubernetes × 1
kafka × 1
google-cloud-sql × 1
debian × 1
more related tags
Hot Network Questions
- Is this revision of the level 2 Transmutation Wizard feature balanced? [Version 3]
- What was the big pillar-shaped Beholder in 3.5?
- "Premove" in OTB game
- How do I properly address and handle work burnout?
- How to move forward after microaggression allegations against my TA
- Extract data from ragged arrays
- What's the meaning of "Courtesy: [Name]" in an advertisement?
- Is 明朝 a typo for 早朝?
- How many recipients can fit in a single Ark shared output?
- I have a distribution block buried under my center console. Would getting 12v from that line vs directly from the battery present any fire hazard?
- Why does Robin Williams have a dark beard in the poster?
- I need locks on main bedroom double doors. Problem is the door is only 1 1/4" thick. All handle/lock sets I find require 1 3/8" min. What can I do?
- Does Sonoma encrypt a disk without asking?
- Do airliners respond to mild turbulence in real time?
- Blender Accessibility Features
- Naive question: Origin of the Holy Ghost
- Why is Trump's alleged fraud in New York not prosecuted as a criminal offense?
- My husband (her father) jokes/plays in ways my daughter doesn't always find funny, he says he should be able to do it if he wants
- An accumulated moving average
- Is size or electronegativity more important in acidity?
- I (rev)?(pal)? the source code, you (rev)?(pal)? the input!
- Close a file created using GDAL
- Does a company have to have your login information to verify your identity?
- Is it illegal to have a product delivered to a different ZIP code to pay less sales tax?