Whenever you do switch-over, postgres-wal creates a new timeline, which
simplifies managing PITR process.
During switch-over(promoting B as master) you had some delta records written to
A, that’s where it causes this timeline issue.
Now since A had some delta records, it can’t replicate from B
Yes, consider using Repmgr.
> On 08-Aug-2018, at 3:20 AM, Richard Schmidt
> wrote:
>
> We think we have found our missing step. We needed to do an ordered shutdown
> of the original primary before promoting the standby
> I.e.
>
> >1. Make some changes to the A (the primary) and check that th
Solution, execute this on your linux terminal -
$ perl -MCPAN -e 'install Bundle::DBI'
$ perl -MCPAN -e 'install DBD::Pg'
> On 24-Aug-2018, at 6:13 PM, Ravi Krishna wrote:
>
>>
>> sir have taken pg_sample
>> Now i want to run pg_sample with credential but i'm getting this error
>>
>> Can't l
Hi Team,
I’m getting running into following issue while executing pg-sample
Error
DBD::Pg::db do failed: ERROR: could not identify an equality operator for type
json
LINE 3:SELECT DISTINCT t1.*
^ at ./pg_sample line 296.
main::__ANON__
BTW - I’ve tried figuring out myself and understood UNION workaround could
help, but since it’s via pg-sample so just want to understand if there a quick
workaround without tweaking pg-sample itself.
> On 24-Aug-2018, at 6:20 PM, Abhinav Mehta wrote:
>
> Hi Team,
>
> I’m getti
