-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>>> Yeah. One nasty property that async multi master solutions share is
>>> that they change the definition of what 'COMMIT' means -- the database
>>> can't guarantee the transaction is valid because not all the
>>> supporting facts are necessa
Yeah. One nasty property that async multi master solutions share is
that they change the definition of what 'COMMIT' means -- the database
can't guarantee the transaction is valid because not all the
supporting facts are necessarily known. Even after libpq gives you
the green light that transa
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> course, but it is trigger based. One notable difference between
>> Bucardo and Slony is that whereas Slony's triggers store the entire
>> row data in a separate log table when something changes, Bucardo
>> stores only the primary key.
> T
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Yeah. One nasty property that async multi master solutions share is
> that they change the definition of what 'COMMIT' means -- the database
> can't guarantee the transaction is valid because not all the
> supporting facts are necessarily kno
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I only see perl-DBD-Pg 1.49 in the RHEL repos, and I don't see
> perl-ExtUtils-MakeMaker in there at all (or in EPEL or in RpmForge).
For the record, only DBD::Pg is really necessary - everything will
still work fine with an older verison o
On Fri, May 06, 2011 at 09:15:37AM -0400, Vick Khera wrote:
>
> Oh... I remember erserver. It served us well for about 2 years for a
> simple, not very high-velocity database that was 99.44% read-only. I
> did have to monitor it closely and restart regularly. At least with
> slony I don't worry
On Fri, May 6, 2011 at 8:59 AM, Andrew Sullivan wrote:
> That's interesting. An earlier replication system we had at Afilias
> (erserver, which was descended from the rserv code that used to be in
> contrib/) used this strategy.[1]
>
Oh... I remember erserver. It served us well for about 2 year
On Thu, May 05, 2011 at 09:22:14PM -0600, Joshua Tolley wrote:
> course, but it is trigger based. One notable difference between Bucardo and
> Slony is that whereas Slony's triggers store the entire row data in a separate
> log table when something changes, Bucardo stores only the primary key.
T
On 05/05/11 8:14 PM, Joshua Tolley wrote:
On Thu, May 05, 2011 at 03:07:20PM +0530, tushar nehete wrote:
Warning: prerequisite DBD:Pg 2.0 not found. We have 1.49.
Warning: prerequisite ExtUtils::MakeMaker 6.32 not found. We have 6.30.
You need to install DBD::Pg, version 2.0 or greater. You als
On Thu, May 05, 2011 at 08:13:55PM -0700, John R Pierce wrote:
> On 05/05/11 8:05 PM, Joshua Tolley wrote:
>> Actually, Bucardo doesn't do statement replication. It, like Slony for
>> instance, replicates data, not SQL statements. And as you pointed out, it
>> does
>> do bidirectional replication
On Thu, May 05, 2011 at 03:07:20PM +0530, tushar nehete wrote:
> Warning: prerequisite DBD:Pg 2.0 not found. We have 1.49.
> Warning: prerequisite ExtUtils::MakeMaker 6.32 not found. We have 6.30.
You need to install DBD::Pg, version 2.0 or greater. You also need to install
ExtUtils::MakeMaker ver
On 05/05/11 8:05 PM, Joshua Tolley wrote:
Actually, Bucardo doesn't do statement replication. It, like Slony for
instance, replicates data, not SQL statements. And as you pointed out, it does
do bidirectional replication in a way that's sufficient for some use cases.
does it use triggers for r
On Mon, May 02, 2011 at 11:31:28PM -0700, John R Pierce wrote:
> AFAIK, the only postgres replication systems that even pretend to
> support master-master are things like Bucardo that do the replication at
> the SQL layer, by sending all update/insert/delete commands to both
> servers, and un
On Thu, May 05, 2011 at 03:07:20PM +0530, tushar nehete wrote:
> Hi,
> I gone through the steps from bucardo sites as,
>
> [root@billingtest1 Bucardo-4.4.3]# perl Makefile.PL
> WARNING: LICENSE is not a known parameter.
> Warning: prerequisite DBD:g 2.0 not found. We have 1.49.
> Warning: prerequi
Hi,
I gone through the steps from bucardo sites as,
[root@billingtest1 Bucardo-4.4.3]# perl Makefile.PL
WARNING: LICENSE is not a known parameter.
Warning: prerequisite DBD:g 2.0 not found. We have 1.49.
Warning: prerequisite ExtUtils::MakeMaker 6.32 not found. We have 6.30.
'LICENSE' is not a kno
Hi Thanks to ALL,
John I tried Perl built into RHEL 5.5 but i got some errors so I download
activeperl 5.12 and
installed it.
After that when start installation I stuck with the error,
FAILED! (psql:/usr/local/share/bucardo/bucardo.schema:40: ERROR: didn't get
a returINSTALLATION n item from mksa
Merlin Moncure wrote:
I know some people do some cool, usable things with that stuff,
but the whole concept seems awfully awkward to me. I suppose I'm a
crotchety, cane shaking fundamentalist...
It's possible--do you sometimes find yourself yelling at young
developers, telling them to stop re
On 05/03/11 5:04 AM, tushar nehete wrote:
I started with Bucardo. I installed activeperl 5.12 on my
Linux(RHEL5.5) server.
why ActivePerl, which is usually used by MS Windows users, rather than
the Perl built into RHEL 5.5 (btw, 5.6 is out now, you really should run
'yum update').
--
Sent
On Tue, May 3, 2011 at 4:19 AM, Simon Riggs wrote:
> On Tue, May 3, 2011 at 7:31 AM, Sim Zacks wrote:
>
>> I have heard good things about Bucardo, though I haven't tried it myself
>> yet. I was warned that it would be risky to have 2 masters that have the
>> same tables modified in both because o
One more point, Please take into consideration the points mentioned by Simon
Riggs in your testing.
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, May 3, 2011 at 5:41 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> Best to start with.
Best to start with..
http://bucardo.org/wiki/Bucardo/Installation
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, May 3, 2011 at 5:34 PM, tushar nehete wrote:
> Thanks you all,
> I started with Bucardo. I installed activeperl 5.12 on my Linux(RHE
Thanks you all,
I started with Bucardo. I installed activeperl 5.12 on my Linux(RHEL5.5)
server.
Can you please suggest some link which describe the installation steps in
details.
Thanks,
Tushar
On Tue, May 3, 2011 at 2:49 PM, Simon Riggs wrote:
> On Tue, May 3, 2011 at 7:31 AM, Sim Zacks wro
On Tue, May 3, 2011 at 7:31 AM, Sim Zacks wrote:
> I have heard good things about Bucardo, though I haven't tried it myself
> yet. I was warned that it would be risky to have 2 masters that have the
> same tables modified in both because of issues such as delayed sync, race
> conditions and other
On 05/03/2011 09:15 AM, tushar nehete wrote:
Hi,
Is there any way to do bidirectional replication for Postgresql Plus
Advance Server 8.4.5?
I tried SLONY-I but its master-slave asynchronous replication.
Can we configure master-master replication by slony?
Or is there any trusted tool to do
On 05/02/11 11:15 PM, tushar nehete wrote:
Hi,
Is there any way to do bidirectional replication for Postgresql Plus
Advance Server 8.4.5?
PostgreSQL Plus Advanced Server is a commercial product sold by
EntepriseDB, you probably should ask them
I tried SLONY-I but its master-slave asynchr
25 matches
Mail list logo
