-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 known.
-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 of
-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.
That's
-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 known.
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
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.
On Fri, May 6, 2011 at 8:59 AM, Andrew Sullivan a...@crankycanuck.ca 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
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
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
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: prerequisite
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 under
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
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
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 in a way
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
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
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
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 it?
Regards,
Tushar
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
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 Tue, May 3, 2011 at 7:31 AM, Sim Zacks s...@compulab.co.il 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
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 si...@2ndquadrant.com wrote:
On Tue, May 3, 2011 at
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 tpneh...@gmail.com wrote:
Thanks you all,
I started with Bucardo. I installed activeperl
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..
On Tue, May 3, 2011 at 4:19 AM, Simon Riggs si...@2ndquadrant.com wrote:
On Tue, May 3, 2011 at 7:31 AM, Sim Zacks s...@compulab.co.il 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
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').
--
26 matches
Mail list logo