Questions tagged [repmgr]

Replication Manager for PostgreSQL clusters

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

Repmgr : It automatically promotes to new master but other standby stopped

I'm trying to setup postgre with repmgr and here is the rsult The scenario is, i tried to spinup 1 primary and 2 standby. then i stop the primary so the postgres-2 got promoted. Unfortunately the ...
0
votes
1answer
17 views

Why use synchronous_standby_names = 'barman_receive_wal' will cause database aberrant?

Use barman's synchronous_standby_names feature in PostgreSQL's postgresql.conf file synchronous_standby_names = 'barman_receive_wal' Can't do these operations: createuser(hanging) createdb(hanging) ...
0
votes
1answer
21 views

How to use repmgr with PostgreSQL 10?

Followed the official repmgr document, I set these items to the configuration file: shared_preload_libraries = 'repmgr' max_wal_senders = 10 max_replication_slots = 10 wal_level = 'hot_standby'...
0
votes
0answers
25 views

HAPROXY for Postgres Failover Master/Replica

I have successfully set up a postgres master-replica with repmgr for automatic failover which can be found over here https://github.com/mgonzaga1990/pg-rpi-failover Now what I'm planning to do next is ...
0
votes
1answer
11 views

how long can your replica be offline when using repmgr with Barman?

I'm setting up some postgres database EC2 instances that I'd like to use for load balancing. The application I'm running has some very expensive and very unique queries so CPU usage is a concern. ...
0
votes
0answers
59 views

How to stop or delete repmgr service?

I installed repmgr10 on PostgreSQL server before. But now will reinstall them. Deleted postgresql's data folder: /var/lib/pgsql/10/data/. Stoped postgresql-10 service: sudo systemctl stop postgresql-...
0
votes
0answers
16 views

Why got pending status when use createuser command with PostgreSQL?

Using PostgreSQL 10 on RHEL 7.7. Start service and login to postgres user: $ sudo su - postgres -bash-4.2$ Create a user -bash-4.2$ createuser -s repmgr It will pending and wait for a long time can'...
0
votes
0answers
13 views

Why repmgr didn't failover automatically?

Installation - name: Install repmgr repository get_url: url: https://dl.2ndquadrant.com/default/release/get/10/rpm dest: /var/lib/pgsql/repmgr - name: Install repmgr rpm shell: bash /var/...
0
votes
2answers
48 views

Is it possible to make a high availability PostgreSQL database cluster by open source softwares?

If use these tools can make a great modern database cluster with full features: pgbouncer (with HAProxy for HA) repmgr barman The main database will run on the repmgr servers. It has primary and ...
0
votes
0answers
96 views

How to promote a PostgreSQL standby server by repmgr automatically with pgbouncer and barman?

Now using these servers: Node1: pgbouncer1 Node2: pgbouncer2 Node3: repmgr primary Node4: repmgr standby Node5: repgmr standby Node6: repmgr standby Node7: barman primary Node8: barman passive ...
0
votes
0answers
35 views

Is it possible to create 2 pgBouncer servers and automaticly notify changed repmgr master to Barman?

For a database cluster design as below: In order to do high availability, prepare 2 pgBouncer servers. If the first server down, then the second server act as new connection pool, use HAProxy(Load ...
0
votes
0answers
78 views

install postgresql without creating instance (for use with repmgr)

I'm trying to get REPMGR setup, and I'm following the steps at https://repmgr.org/docs/current/quickstart-standby-preparation.html to get the standby setup. I noticed it warns On the standby, do not ...
0
votes
1answer
272 views

Is it possible that the old primary follow the new secondary?

I need to change the roles between two nodes. Circumstance: 2servers: primary: psql01 and standby: psql02 After psql01 stops, psql02 becomes the new primary. After a while, start psql01 On ...
0
votes
1answer
230 views

How to do automatic failover for PostgreSQL with application automatic switch?

There are two ways to try. Method 1 Use JDBC connect the PostgreSQL cluster (primary, standby 2 servers only): jdbc:postgresql://192.168.0.1:5432,192.168.0.2:5432/jiradb But failed: The ...
-1
votes
1answer
688 views

repmgr on PostgreSQL 10 failed, recovering

I'm running a 3 nodes PostgreSQL 10 + repmgr 4.4 cluster: 1 master node (postgres1.domain.local) 2 stabdby nodes (postgres2.domain.local and postgres2.domain.local) The cluster was running fine ...
1
vote
1answer
28 views

repmgr 4.4 upgrade

I did apt-get install repmgr and tried to upgrade repmgr from 4.3 to 4.4 root@node-01:~# apt-get install repmgr Reading package lists... Done Building dependency tree Reading state information... ...
1
vote
0answers
106 views

pg_dump does not return schema for repmgr objects

While trying to browse repmgr.monitoring_history, I noticed it has many tens of millions of records. Wanting to get a peak at the indexes that (may or may not) already exist on the table, I try a ...
0
votes
1answer
62 views

How to install repmgr 4.2 (ubuntu)

apt-get install postgresql-10-repmgr give me repmgr 4.3. However, my primary server is still on 4.2. How do I install repmgr version 4.2? Thanks in advance!
0
votes
1answer
97 views

PostgreSQL cluster has two primary databases after network glitch

My test environment had network glitch over the weekend and I ended up having two Primary databases up and running in the cluster. ID | Name | Role | Status | ...
2
votes
1answer
397 views

pg_hba error while setting up repmgr

Please help me to figure it out, help is much appreciated! ERROR: FATAL: no pg_hba.conf entry for replication connection from host "172.18.0.4", user "repmgr", SSL on The following is a list of my ...
0
votes
1answer
506 views

Postgresql Replica is in sync but repmgr says node unattached

I've set up a replica of a Postgresql instance using repmgr, and the replica is totally in sync with the master instance and have been in sync since some days, but repmgr tells me replica isn't ...
1
vote
0answers
280 views

PGpool not properly detecting which postgres server is master

I am in the process of building a resilient database cluster and currently have 3 database servers running postgres 10 and repmgr. repmgr is taking care of the streaming replication including ...
1
vote
1answer
60 views

Replication with Repmgr + native streaming replication

I have an environment where the old DBA used the repmgr. And now I need to add a second replica to use as a "dump server". But my question is regarding using the native mode of PostgreSQL via stream ...
2
votes
1answer
724 views

Repmgr: Error to promote Standby Cluster to Master Cluster in failover

I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover. Following my configurations, this ...
3
votes
1answer
433 views

Trying to replicate 2 or more Postgres instances to one standby host

My setup has 2 Postgres hosts: host SRV1 as primary with 2 instances and IP 192.168.1.241 Instance A listening on port 5432 Instance B listening on port 5433 host SRV2 as standby with instance C ...
0
votes
2answers
2k views

Postgres repmgr - downstream nodes not attached

I'd configured repmgr replication on node1 and node3 (primary and standby respectively), and the setup worked sucessfully creating new records and objects on standby as expected. But after some weeks ...
0
votes
0answers
102 views

rh-postgresql96(Red Hat provided postgresql) vs postgresql-9.6 (community postgresql)

Our client has provided us Red Hat machine for setting up PostgreSQL. We are allowed to install red hat provided packages only. So we have to install red hat provided postgresql (rh-postgresql96) ...
0
votes
0answers
240 views

Postgresql - Is this possible to setup a Zero downtime PostgreSQL Cluster?

I have already asked here about PostgreSQL HA setup, and I got many possible answers. But the bad thing is, even though if I use any third party software like PGpool, Repmgr, pacemaker are asking for ...
1
vote
1answer
515 views

pg_repack slows down PostgreSQL replication

I have a master PostgreSQL 9.5 server and a standby server. For replication I use repmgr (WAL streaming). Typically the delay between master and standby is <5s: $ psql -t -c "SELECT extract(epoch ...
4
votes
1answer
1k views

How to restore PostgreSQL standby server from archive?

I have a PostgreSQL 9.5 cluster with master and standby server that are replicated using repmgr. Master is configured to keep 4000 WAL files: wal_level = logical hot_standby = on archive_command = '...
1
vote
0answers
527 views

PostgreSQL: Removing standby from streaming replication

I have PostgreSQL 9.4 streaming replication setup between three nodes (master and two hot standbys). I use repmgr to control the replication cluster. I need to retire one of the standbys and remove it ...
3
votes
2answers
5k views

Postgres requested WAL segment has already been removed (however it is actually in the slave's directory)

I am using repmgr as my replication tool. On the slave I keep getting an error: requested WAL segment has already been removed When I check the Master indeed it is not there; however, it is in ...
2
votes
1answer
2k views

Automatic recovery of the failed postgresql master node is not working with pgpool II

I am new to Postgresql and Pgpool II setup. I have configured the Postgresql HA/Load balancing using Pgpool II and Repmgr. I have followed the link to do the setup. The setup consist of 3 nodes and ...
0
votes
1answer
715 views

repmgr 3.0.4 and postgres 9.4 on ubuntu (ERROR: replication slot “repmgr_slot_2” does not exist)

I'm not a DBA but I have been tasked with setting up a database and streaming replication and repmgr is the tool I have decided to use. The master goes on fine and I can see it registered in the ...
1
vote
1answer
351 views

postgresql: PANIC: cannot operate with inconsistent data

I'm trying to setup a replica using repmgr: repmgr -D /var/lib/postgresql/9.3/main -p 5432 -U repmgr -R postgres \ --verbose standby clone psql.master.example.com repmgr --verbose standby register ...
3
votes
1answer
5k views

Removing a FAILED node from repmgr cluster

How do I remove failed node from a PostgreSQL cluster? postgres@db-prod-ms47ox-10-3-104-92:~$ repmgr -f /etc/repmgr/repmgr.conf cluster show Role | Connection String * master | host=db-prod-...
1
vote
1answer
368 views

Connection pooling with 3 databases but 1 database as master for repmgr replication?

I'm using pgbouncer for connection pooling against 3 database on different servers, now I'm planning to use repmgr for replication, my question is, can I keep doing connection pooling on these 3 ...
0
votes
1answer
789 views

repmgr: Can I replicate databases from two different masters to a third slave?

If I have a master node 1 (with database A) and a master node 2 (with database B) can I use repmgr and have both A and B replicated to a hot standby node 3 ? [ EDIT: They would all be running ...
0
votes
1answer
1k views

Taking hot backup of slave node in postgres (master-slave config with repmgr)

I have a postgresql setup with master-slave configuration using repmgr. I'm struggling with taking a consistent snapshot backup (pg_start_backup) of the slave node, this is due the fact that the slave ...
3
votes
1answer
2k views

Can't set up witness in Repmgr 2.0

I am trying to setup repmgr using the autofailover quick setup tutorial provided on Github Link But I am kind of stuck on the witness section, when trying to create the witness with repmgr -d repmgr -...
3
votes
1answer
526 views

Witnessing standby failure with repmgr

We're setting up a PostgreSQL cluster, and we're looking at using repmgr to handle standby promotion and so on. Our cluster has one master and a hot standby, and uses the streaming replication ...
6
votes
1answer
6k views

PostgreSQL: Unable to run repmgr cloned database

I'm running tests with PostgreSQL hot standby with 1 master, and exactly 1 slave. I am using the instructions on this guide: http://www.howtoforge.com/how-to-set-up-a-postgresql-9.0-hot-standby-...
14
votes
2answers
5k views

Streaming replication and failover on PostgreSQL

I am doing a proof of concept on PostgreSQL replication. After the discussion on forum we decided to go with streaming replication as the performance is good compared to other solutions. PostgreSQL is ...