RE: pg_rewind

Thanks for your suggestion, I need now to make "wal_log_hints = on"

-----Original Message-----
From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Sent: donderdag 23 januari 2020 16:56
To: Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com>; pgsql-admin(at)lists(dot)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_rewind

On Thu, 2020-01-23 at 15:39 +0000, soumik(dot)bhattacharjee(at)kpn(dot)com wrote:
> 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.

Because you used the wrong user or didn't specify a password?

Try

--source-server='host=<IP Address> port=5432 user=... password=...'

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com