Re: pg_rewind

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: 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
Date: 2020-01-23 15:56:27
Message-ID: 2079fc510f11cc43ed95a34afbec01d51a745d67.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

  • pg_rewind at 2020-01-23 15:39:20 from soumik.bhattacharjee

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message soumik.bhattacharjee 2020-01-23 16:11:51 RE: pg_rewind
Previous Message soumik.bhattacharjee 2020-01-23 15:39:20 pg_rewind