Re: [GENERAL] Select specific tables in BDR

2016-02-23 Thread Kaushal Shriyan
On Tue, Feb 23, 2016 at 4:44 PM, Andreas Kretschmer wrote: > > > > Kaushal Shriyan hat am 23. Februar 2016 um > 11:43 > > geschrieben: > > > > > > Hi, > > > > Is there a option of selecting tables in BDR which is a Multi Master PG >

[GENERAL] Select specific tables in BDR

2016-02-23 Thread Kaushal Shriyan
Hi, Is there a option of selecting tables in BDR which is a Multi Master PG Replication (http://2ndquadrant.com/en/resources/bdr/). I mean if i have let's say t1,t2,t3,t4 and t5. Can i have BDR only for t1,t2 and t3 table ? Regards, Kaushal

Re: [GENERAL] Unrecognized configuration parameter in bdr 0.9.3

2016-02-12 Thread Kaushal Shriyan
On Fri, Feb 12, 2016 at 7:40 AM, Craig Ringer wrote: > On 11 February 2016 at 20:16, Kaushal Shriyan > wrote: > >> Hi, >> >> I am following http://bdr-project.org/docs/stable/index.html for setting >> up multimaster replication. >> > > Are you

[GENERAL] Unrecognized configuration parameter in bdr 0.9.3

2016-02-11 Thread Kaushal Shriyan
Hi, I am following http://bdr-project.org/docs/stable/index.html for setting up multimaster replication. *First Master box* *cat postgresql.conf* # Allow two other peer nodes, plus one for init_replica max_replication_slots = 3 # Two peer nodes, plus two slots for pg_basebackup max_wal_senders

Re: [GENERAL] BDR replication on Postgresql 9.5.0

2016-02-01 Thread Kaushal Shriyan
On Mon, Feb 1, 2016 at 12:24 AM, John R Pierce wrote: > On 1/29/2016 3:00 AM, Kaushal Shriyan wrote: > >> >> Do i need to install any BDR specific package to enable it in postgresql >> 9.5 version. While reading >> http://bdr-project.org/docs/0.9.0/install-requirem

[GENERAL] BDR replication on Postgresql 9.5.0

2016-01-29 Thread Kaushal Shriyan
Hi, I am following http://bdr-project.org/docs/stable/index.html to setup BDR for postgresql version 9.5 as per [root@ip-172-31-1-17 9.5]# cat /etc/redhat-release *Red Hat Enterprise Linux Server release 6.6 (Santiago)* [root@ip-172-31-1-17 9.5]# rpm -qa | grep postgre postgresql95-libs-9.5.0-2PG

Re: [GENERAL] Difference between UDR and BDR replication

2016-01-28 Thread Kaushal Shriyan
On 28 Jan 2016 6:51 pm, "Craig Ringer" wrote: > > On 28 January 2016 at 21:16, Kaushal Shriyan wrote: >> >> >> >> On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer wrote: >>> >>> On 28 January 2016 at 19:16, Kaushal Shriyan wrote: >>

Re: [GENERAL] Difference between UDR and BDR replication

2016-01-28 Thread Kaushal Shriyan
On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer wrote: > On 28 January 2016 at 19:16, Kaushal Shriyan > wrote: > >> Hi, >> >> Can somebody please help me understand the difference between UDR and BDR >> with examples? >> > > > BDR is for multiple m

[GENERAL] Difference between UDR and BDR replication

2016-01-28 Thread Kaushal Shriyan
Hi, Can somebody please help me understand the difference between UDR and BDR with examples? Thanks in Advance. Regards, Kaushal

[GENERAL] Comparing two postgres dump files.

2015-12-02 Thread Kaushal Shriyan
Hi, Are there any scripts which will diff two pg_dump files for t1 and t2 time period. For example pg_dump taken on t1 -> 01/11/2015 and then on t2 -> 30/11/2015. backup_01112015.dump (dump taken on 01/11/2015) backup_30112015.dump (dump taken on 30/11/2015) Any help will be highly appreciable.

[GENERAL] Point in time recovery

2015-08-26 Thread Kaushal Shriyan
Hi, Can somebody please explain about Point-In-Time-Recovery (PITR) in context to http://www.pgbarman.org/about/? Regards, Kaushal

[GENERAL] backup and archive postgresql data older than 6 months

2015-08-26 Thread Kaushal Shriyan
Hi, Are there scripts which takes backup of postgresql database and archive data older than 6 months and push it to a remote server using scp or rsync method and purge/clean the local data on the hard disk at the same time meaning at any given time we have only six months of postgresql data on the

Re: [GENERAL] PG replication across DataCenters

2013-11-22 Thread Kaushal Shriyan
On Fri, Nov 22, 2013 at 6:14 PM, Albe Laurenz wrote: > Torsten Förtsch wrote: > >> Don't use synchronous replication if you have a high transaction > >> rate and a noticable network latency between the sites. > >> > >> Wait for the next bugfix release, since a nasty bug has just > >> been discover

[GENERAL] PG replication across DataCenters

2013-11-22 Thread Kaushal Shriyan
Hi, I have read on the web that Postgresql DB supports replication across data centers. Any real life usecase examples if it has been implemented by anyone. Please also help me understand the caveats i need to take care if i implement this setup. Regards, Kaushal