Re: [GENERAL] BDR error while adding 3rd node to cluster

2015-12-25 Thread Amit Bondwal
015 at 17:00, Amit Bondwal wrote: > > >> I remove all the bdr packages and reinstall it and setup again the BDR >> cluster, still facing the same issue on 3rd node. >> > > At this point I'd really need to see the steps taken, in detail, to get to > that point fr

Re: [GENERAL] BDR error while adding 3rd node to cluster

2015-12-22 Thread Amit Bondwal
Hi Craig, I remove all the bdr packages and reinstall it and setup again the BDR cluster, still facing the same issue on 3rd node. On Tue, Dec 22, 2015 at 10:58 AM, Amit Bondwal wrote: > > On Tue, Dec 22, 2015 at 10:05 AM, Craig Ringer > wrote: > >> select * from b

Re: [GENERAL] BDR error while adding 3rd node to cluster

2015-12-21 Thread Amit Bondwal
On Tue, Dec 22, 2015 at 10:05 AM, Craig Ringer wrote: > select * from bdr.bdr_connections; > Hi Craig, Thanks for your reply, These commands shows nothing on 3rd node. *on node3:-*hakuna=# select * from bdr.bdr_nodes; node_sysid | node_timeline | node_dboid | node_status | node_name | node_

[GENERAL] BDR error while adding 3rd node to cluster

2015-12-21 Thread Amit Bondwal
recreate it but same error. I also tried to connect to 2nd node as external dsn but same error. I am able to access all three nodes to each other using psql. -- Regards Amit Bondwal

Re: [GENERAL] Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file

2015-08-21 Thread Amit Bondwal
Michael, Thanks for your reply, I found the issue, the person who setup OS mix up some 64 and 32 bit package. I am starting it again. Thanks again. On Fri, Aug 21, 2015 at 5:12 PM, Michael Paquier wrote: > > > On Fri, Aug 21, 2015 at 7:56 PM, Amit Bondwal > wrote: > >> 20

[GENERAL] Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file

2015-08-21 Thread Amit Bondwal
8-21 15:40:20 IST [21561-1] FATAL: incorrect checksum in control file It gives the error "database system identifier differs between the primary and standby". On Fri, Aug 21, 2015 at 3:26 PM, Amit Bondwal wrote: > Hi everyone, > > I am trying to setup postgresql 9.3 hot

[GENERAL] Postgresql 9.3 hotstandby replication error, icorrect checksome in control file

2015-08-21 Thread Amit Bondwal
debian squeeze or it was on debian wheezy on different hardwares or VPS servers. Is there any different way to do replication to avoid this issue? or how can I resolve this issue. -- Regards Amit Bondwal

Re: [GENERAL] Postgres SSL connection without client certificates.

2015-07-27 Thread Amit Bondwal
Thanks you very much Adrian for clearing my confusion. On Mon, Jul 27, 2015 at 7:24 PM, Adrian Klaver wrote: > On 07/27/2015 12:48 AM, Amit Bondwal wrote: > >> Hi Everyone. >> >> I am able to setup postgresql with TLS v1.2 with client certificate. I >> used b

[GENERAL] Postgres SSL connection without client certificates.

2015-07-27 Thread Amit Bondwal
on client machine? I am using linux as a clinet machine and want to connect through command line, without client certificate in encrypted format or on SSL. What should I do? -- Thanks & Regards, Amit Bondwal Contact me at +91-999-0235-948

Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Amit Bondwal
Thanks you very much Craig for clearing these facts and sorry for mail sent only to you by mistake. -- Thanks & Regards, Amit Bondwal On Fri, Jul 17, 2015 at 6:19 PM, Craig Ringer wrote: > On 17 July 2015 at 19:37, Amit Bondwal wrote: > > Thank you very much all of you for q

[GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Amit Bondwal
r and rest of slave nodes, how can I take backup of this distributed database to one of my other server or backup location. Please suggest me what would be the best approch for this. -- Thanks & Regards, Amit Bondwal