Questions tagged [postgresql-replication]
26 questions
0
votes
1 answer
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 base backup for the hot standby by running…
Leah Sapan
- 189
- 1
- 2
- 15
0
votes
1 answer
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 it gets started. As I start 2nd slave, it does…
deepankardixit90
- 153
- 2
- 7
0
votes
1 answer
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 some computationally intensive calculations on the…
Amandasaurus
- 31,471
- 65
- 192
- 253
0
votes
0 answers
How can I still be able to write to primary postgresql while replication is absent?
My goal is to let the master server still be able to process write request while standby is in failure. I have noticed synchronous_commit = can be manually set to off and then reload the primary server.
Other configuration includes repmgr.conf for…
George Y
- 528
- 6
- 16
0
votes
0 answers
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 databased are newly created. What is not…
xm22
- 1
0
votes
0 answers
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, changes are stored in the agent DB, and then…
RedNet
- 101
0
votes
0 answers
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 the replication, gvmd service & gsad service goes…
xchan4
- 1
0
votes
0 answers
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 roles on two servers.
for this I the…
Red Hat
- 15
- 2
0
votes
1 answer
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 the cluster, but it didn't configure a new one.…
maar
- 485
- 6
- 20
0
votes
0 answers
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-11.1-1PGDG.rhel7.x86_64
rpm -i…
Pepe
- 1
0
votes
1 answer
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?
Thanks!
Michael Gee
- 1
- 1