Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index

Managed to find following in the announcement of BDR on 9.6: "BDR has always been an extension, but *on 9.4 it required a heavily patched PostgreSQL, one that isn’t fully on-disk-format compatible with stock community PostgreSQL 9.4.* The goal all along has been to allow it to run as an extension o

Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index

On 5/25/19 11:46 AM, Jānis Pūris wrote: Hi Ron, I can not reproduce this error on BDR_Node_2 (it is not BDR_Node_1 as stated before. Typo) I've been successful in transferring the data with pg_dump on BDR_Node_2 and then restoring it on Regular_Node_1. Then running "select * from informatio

Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index

Hi Ron, I can not reproduce this error on BDR_Node_2 (it is not BDR_Node_1 as stated before. Typo) I've been successful in transferring the data with pg_dump on BDR_Node_2 and then restoring it on Regular_Node_1. Then running "select * from information_schema.sequences;" all is OK. The problem w

Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index

Hi, Adrian Apologies, it is a typo. pg_basebackup was taken from BDR_Node_2, not BDR_Node_1 Thank you in advance. Best regards, Janis Puris On 25 May 2019 at 19:27:42, Adrian Klaver (adrian.kla...@aklaver.com) wrote: I am not clear about above: 1) You removed BDR_Node_2 from cluster 2) You t

Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index

On 5/25/19 9:49 AM, Jānis Pūris wrote: Hello, I'm working with a 9.4-bdr cluster and want to move away from BDR tech all together. So my idea was to follow instructions on http://bdr-project.org/docs/stable/ to first strip the node from BDR making it into "regular" node and then moving the da

Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index

On 5/25/19 11:49 AM, Jānis Pūris wrote: Hello, I'm working with a 9.4-bdr cluster and want to move away from BDR tech all together. So my idea was to follow instructions on http://bdr-project.org/docs/stable/ to first strip the node from BDR making it into "regular" node and then moving the d

pg_basebackup from 9.4-bdr to 9.4 results in corrupt index

Hello, I'm working with a 9.4-bdr cluster and want to move away from BDR tech all together. So my idea was to follow instructions on http://bdr-project.org/docs/stable/ to first strip the node from BDR making it into "regular" node and then moving the data from this node to official 9.4 instance.