pg_rewind

From: <soumik(dot)bhattacharjee(at)kpn(dot)com>
To: <pgsql-admin(at)lists(dot)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: pg_rewind
Date: 2020-01-23 15:39:20
Message-ID: 2A91BEF8171A5349931391E0C721CC537D787037@CPEMS-KPN501.KPNCNL.LOCAL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Experts,

Initial setup was done using streaming replication and then promoted the STANDBY to MASTER.

I am trying to make my previous Master as Master by roll backing the changes happen into Standby

In Original MASTER I am running below -

/usr/lib/postgresql/12/bin$ ./pg_rewind -D $PGDATA --source-server='host=<IP Address> port=5432' -P
pg_rewind: fatal: could not connect to server: fe_sendauth: no password supplied

I'm not sure why this keeps happening.

Thanks..

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2020-01-23 15:56:27 Re: pg_rewind
Previous Message David G. Johnston 2020-01-22 15:34:17 Re: SQL Query Syntax help