repmgr faiover question

From: John Wiencek <jwiencek3(at)comcast(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: repmgr faiover question
Date: 2016-02-23 03:01:06
Message-ID: D2F12792.E94D%jwiencek3@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

I have a three node postgresql 9.4 cluster configured with one standby in
sync mode and the other in asynch mode.

If the master datbase is shutdown the pg promote happens as expected.
However on the remaining standby node the RECOVERY.CONF file is
misconfigured when issuing the command:

Repmgr ­f ./etc/repmgr/repmgr.conf ‹verbose standby follow

The recovery.conf file get created like this:

primary_conninfo = 'port=5432 host=10.999.99.999 user=repmgr
application_name=postgres-1d-01.node.us-east-1.yyyy.xxxxx.com¹

When it should look like thisŠ

primary_conninfo = 'host=postgres-1c-01.node.us-east-1.yyyy.xxx.com
port=5432 user=replication password=<top secret password>¹

Where is it picking up the user and application_name?

This same this is happening when I use rampager to reclone my former master
as a standby database.

Regards

John

Browse pgsql-general by date

  From Date Subject
Next Message John Wiencek 2016-02-23 03:02:06 Re: synch streaming replication question
Previous Message Thomas Munro 2016-02-23 02:25:59 Re: synch streaming replication question