Stack Overflow
Stack Overflow

Questions tagged [repmgr]

repmgr is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases.

repmgr is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases.

By taking advantage of the Hot Standby capability introduced in PostgreSQL 9, repmgr greatly simplifies the process of setting up and managing database with high availability and scalability requirements.

repmgr simplifies administration and daily management, enhances productivity and reduces the overall costs of a PostgreSQL cluster by:

  • monitoring the replication process;
  • allowing DBAs to issue high availability operations such as switch-overs and fail-overs.

Home: http://repmgr.org/

49 questions
0
votes
2 answers

Option to exclude files in pg_basebackup command Postgres

When cloning a standby, how can I prevent pg_basebackup from copying postgresql.conf and pg_hba.conf from the master to /var/lib/pgsql/9.9/data directory? Currently I am using this command [root@xyz..]# pg_basebackup -h {master ipAddr} -D…
Gautham.R
  • 29
  • 6
0
votes
1 answer

Is it possible to demote a master node without using "repmgr standby clone" and pg_rewind

I am currently using postgresql with log shipping replication. I use a master/slave resource of pacemaker to deal with postgresql failover. I was asking if there is a way to demote a master, set it as standby and keep synchronized without using…
moonbossa
  • 60
  • 2
  • 6
0
votes
1 answer

PostgreSQL repmgr Standby Server fail to Start

In repmgr, I had register the master server, but at the Standby server, i had cloned the Master backup to Standby data directory sucessfully. But after cloning while starting the Standby server, I got the following error. Use of uninitialized…
Rajiv
  • 582
  • 2
  • 8
  • 18
0
votes
1 answer

Will RepMgr supports different versions of postgresql in master and slave

For an application which is developed by Django and database is Postgres. Now we have to implement replication. We selected RepMgr because it will supports dynamic partition table's replicaton. But we have different Postgresql versions in master and…
Girish Ns
  • 281
  • 1
  • 3
  • 8
1 2 3
4