From: | <soumik(dot)bhattacharjee(at)kpn(dot)com> |
---|---|
To: | <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | <pgsql-admin(at)lists(dot)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | RE: pg_rewind |
Date: | 2020-01-27 16:01:12 |
Message-ID: | 2A91BEF8171A5349931391E0C721CC537D787704@CPEMS-KPN501.KPNCNL.LOCAL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
-----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
>
> 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=...'
--
Thanks for your suggestion, I made the "wal_log_hints = on".
I set the "wal_log_hints = on" , but enabling this parameter "on" in new MASTER(old SLAVE) needs a restart-- which I cannot do as all application transactions are going on there now.
Also I used pg_rewind in old MASTER(which now I want to make as new SLAVE) and it was successful, but this also needs restart of new MASTER(old SLAVE) which is again an issue.
Command used: ./pg_rewind -D $PGDATA --source-server='host=<IP Address> port=5432 user=postgres password=xxxx
Could you please suggest how to get this to work to keep the MASTER(old SLAVE) up & running and make the old MASTER(new SLAVE)
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2020-01-28 08:48:09 | Re: pg_rewind |
Previous Message | Laurenz Albe | 2020-01-27 07:55:10 | Re: Declarative partitioning and materialized views |