Thanks for your suggestion, I need now to make "wal_log_hints = on" -----Original Message----- From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx> Sent: donderdag 23 januari 2020 16:56 To: Bhattacharjee, Soumik <soumik.bhattacharjee@xxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: pg_rewind On Thu, 2020-01-23 at 15:39 +0000, soumik.bhattacharjee@xxxxxxx 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
