pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReplication
63+ messages / 45 participants
[nested] [flat]
* Replication
@ 2000-07-11 01:55 XWorkers <xworkers@bangla.net>
0 siblings, 0 replies; 63+ messages in thread
From: XWorkers @ 2000-07-11 01:55 UTC (permalink / raw)
To: pgsql-admin; Postgre General <pgsql-general@postgresql.org>
Hellow everyone,
I am facing a problem using postgresql. How replication can be performed
for postgres databases?
TIA.
^ permalink raw reply [nested|flat] 63+ messages in thread
* replication
@ 2001-07-03 10:26 "Jean-Sébastien ANDUJAR" <jandujar@transiciel.com>
0 siblings, 0 replies; 63+ messages in thread
From: "Jean-Sébastien ANDUJAR" @ 2001-07-03 10:26 UTC (permalink / raw)
To: pgsql-admin
Is there anyway to replicate in postgres?
Thanks, Jean Sé
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- -
Jean-Sébastien ANDUJAR
mailto:jandujar@transiciel.com
http://www.transiciel.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- -
^ permalink raw reply [nested|flat] 63+ messages in thread
* replication
@ 2001-07-13 16:19 Srinivasa Rao Chava <s.chava@wcom.com>
0 siblings, 1 reply; 63+ messages in thread
From: s.chava@wcom.com @ 2001-07-13 16:19 UTC (permalink / raw)
To: pgsql-admin
Hai Friends,
Does postgresql supports replication?
Say, we want to install to servers , having the same databases. One of
them will work as standby database. For it, the standby database
should be replicated automatically from the regualar database.
Notonly that, the replication will be useful to distribute the load
among different servers.
Oracle has got provision for replication. Is there any such provision
like that in postgresql.
Thanks
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication
@ 2001-08-30 10:33 Egon Reetz <reetz@usco.de>
parent: Srinivasa Rao Chava <s.chava@wcom.com>
0 siblings, 0 replies; 63+ messages in thread
From: Egon Reetz @ 2001-08-30 10:33 UTC (permalink / raw)
To: pgsql-admin
You may look at this site:
http://www.greatbridge.org/project/pgreplication/projdisplay.php
Egon
Srinivasa Rao Chava wrote:
> Hai Friends,
> Does postgresql supports replication?
> Say, we want to install to servers , having the same databases. One of
> them will work as standby database. For it, the standby database
> should be replicated automatically from the regualar database.
>
> Notonly that, the replication will be useful to distribute the load
> among different servers.
> Oracle has got provision for replication. Is there any such provision
> like that in postgresql.
> Thanks
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 63+ messages in thread
* replication
@ 2002-01-10 22:27 Peter T. Brown <peter@memeticsystems.com>
0 siblings, 2 replies; 63+ messages in thread
From: Peter T. Brown @ 2002-01-10 22:27 UTC (permalink / raw)
To: pgsql-admin; pgsql-sql@postgresql.org
Hello
I want to add replication capabilities to my postgresql installation. Can
anyone recommend a good way (open source or otherwise) to do so?
Basically, I have a web tracking application that must quickly and reliably
store massive amounts of tracking data. Later, I run complex queries to
analyze this tracking data. These complex queries tend to be very resource
intensive, so I'd like to have them run on a separate machine altogether. I
need a simple and reliable method to 'copy' any data added to the tracking
database to the analysis database. Preferably, I'd be able to configure this
copy process to defer to high priority queries or to be considerate of the
time of day.
Thanks,
Peter T. Brown
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication
@ 2002-01-10 23:25 Arguile <arguile@lucentstudios.com>
0 siblings, 0 replies; 63+ messages in thread
From: Arguile @ 2002-01-10 23:25 UTC (permalink / raw)
To: pgsql-admin
Peter T. Brown writes:
>
> I want to add replication capabilities to my postgresql installation. Can
> anyone recommend a good way (open source or otherwise) to do so?
>
[snip]
Check the contrib/rserv/ directory in the PostgreSQL source.
Also check http://techdocs.postgresql.org/oresources.php#Replication for a
bunch of other packages.
I don't have much experience with replicating Pg (been sidestepping the
issue) so a list of places to look is all I can provide. :)
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: [SQL] replication
@ 2002-01-10 23:34 Bryan White <bryan@arcamax.com>
parent: Peter T. Brown <peter@memeticsystems.com>
1 sibling, 0 replies; 63+ messages in thread
From: Bryan White @ 2002-01-10 23:34 UTC (permalink / raw)
To: pgsql-admin
> I want to add replication capabilities to my postgresql installation. Can
> anyone recommend a good way (open source or otherwise) to do so?
>
> Basically, I have a web tracking application that must quickly and
reliably
> store massive amounts of tracking data. Later, I run complex queries to
> analyze this tracking data. These complex queries tend to be very resource
> intensive, so I'd like to have them run on a separate machine altogether.
I
> need a simple and reliable method to 'copy' any data added to the tracking
> database to the analysis database. Preferably, I'd be able to configure
this
> copy process to defer to high priority queries or to be considerate of the
> time of day.
How closely does the replicated data have to track your live data. I my
installation I have an cron job that runs at 2:30am daily. It backs up the
database (using pg_dump) and loads it on another machine. I can then run
queries the next day on the backup machine without hurting performance on
the primary. It also has the side effect of producing the backup file for
saving to tape or whatever. It also veryfies daily that the backup file is
not corrupt because the load would fail on the secondary machine.
This is not true replication but it might serve your needs. I looked at the
replication solutions for PostgreSQL a while ago and got the impression they
were not ready for primetime. In may have changed since then.
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication
@ 2002-01-10 23:35 David Stanaway <david@netventures.com.au>
parent: Peter T. Brown <peter@memeticsystems.com>
1 sibling, 0 replies; 63+ messages in thread
From: David Stanaway @ 2002-01-10 23:35 UTC (permalink / raw)
To: pgsql-admin; pgsql-sql@postgresql.org
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Friday, January 11, 2002, at 09:27 AM, Peter T. Brown wrote:
> Hello
>
> I want to add replication capabilities to my postgresql installation.
> Can
> anyone recommend a good way (open source or otherwise) to do so?
I read this the other day, but haven't used it (And I suspect the
document may need an update)
http://techdocs.postgresql.org/techdocs/settinguprserv.php
The document only describes replication between databases on one server
though.. Other people here probably have more experience with rserv and
can let you know what its status is.
- --
Best Regards
David Stanaway
================================
Technology Manager
Australia's Premier Internet Broadcasters
Phone: +612 9357 1699
Fax: +612 9357 1169
Web: http://www.netventures.com.au
Support: support@netventures.com.au
================================
The Inspire Foundation is proudly supported by Net Ventures through the
provision of streaming solutions for it's national centres. The Inspire
Foundation is an Internet-based foundation that inspires young people to
help themselves, get involved and get online. Please visit Inspire at
http://www.inspire.org.au
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org
iQEXAwUBPD4lSr6yIDFGeSAyFALYPQP8CuuS4pRHicYDVJSpJosJa8A9CqSxMkkd
kqsMELbPUKSfMDsRSXoRtRYGOoymKqf6bPru5TbyPJHBIGGTJMRLuPRkvqVWitK1
l3zjMWmBzrrUB7rPa0WR35YQ9jVVSEP87I3z623d+vDG8VluBG6dKMKuMgGURb76
t1po5JtLpYAD/0BLlg9zUsPrwl70Z2b8ctXF3u2Xv2m8inSr+4qtqlgYLkLsrUih
Lv9usaNXcIrY9of5v/PBNEAmY9DlN1fhjm0Zw6vTnzrlP/EDhWSdX7omAFGaBUi7
9XWuOVcrd7iqizmxzqsN+TGbodlGsEgmfMbJMwLY90gUx/t8d3aWQREj
=EbMK
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 63+ messages in thread
* Replication
@ 2002-01-24 17:05 Clinton Adams <clinton@vote-smart.org>
0 siblings, 0 replies; 63+ messages in thread
From: Clinton Adams @ 2002-01-24 17:05 UTC (permalink / raw)
To: pgsql-admin
Hi,
Anyone have thoughts on how I might handle replication with 1 master and 2
slave databases (minimum)?
I am switching our political database from mysql to postgres and need a
solid way to replicate data from our internal server to our webserver. We
currently use 2 databases per server, one administrative database, one live
database for the web. A perl script approximates replication by applying
changes in the local administrative database to the local live database as
well as the administrative databases on the other servers. The catch is
only the changes marked as release changes are sent to the live database. I
suppose I really shouldn't call it replication!
Now that I am doing a extensive redesign of the database and the data entry
client, I am considering consolidating the live and administrative
databases into one with a 'released' field per table to indicate what's
live and what's internal, but this sounds like it would really slow down
the queries. I could use a trigger to dump all the changes into another
table, and then have a perl script to send these changes to the
slaves...and a cronjob on the slaves that removes the records marked as
internal. Ideas/caveats?
Thanks for any help!
Clinton
^ permalink raw reply [nested|flat] 63+ messages in thread
* Replication...???
@ 2002-02-11 18:24 James Kelty <jamesk@ashlandagency.com>
0 siblings, 0 replies; 63+ messages in thread
From: James Kelty @ 2002-02-11 18:24 UTC (permalink / raw)
To: pgsql-admin
Has anyone tried pgreplicator (http://pgreplicator.sourceforge.net) in a
production environment? Also, is there any word on when replication will be
a part of the distribution of postgres? I was hoping for 7.2, but, no luck.
-James
James Kelty
Sr. Unix Systems Administrator
The Ashland Agency
541.488.0801
jamesk@ashlandagency.com
^ permalink raw reply [nested|flat] 63+ messages in thread
* replication
@ 2002-04-28 02:58 Doug Needham <dneedham@pbo.net>
0 siblings, 0 replies; 63+ messages in thread
From: Doug Needham @ 2002-04-28 02:58 UTC (permalink / raw)
To: pgsql-admin
Is there a howto/demo/tutorial for setting up replication with Postgres 7.2?
Thanks
^ permalink raw reply [nested|flat] 63+ messages in thread
* Replication
@ 2003-01-23 10:38 Enrico Ortmann <list.pg@web.de>
0 siblings, 1 reply; 63+ messages in thread
From: Enrico Ortmann @ 2003-01-23 10:38 UTC (permalink / raw)
To: pgsql-admin
Hi folks,
Does anyone know a solution for replicating a PG7.2 Database. We'd prefer a bidirectional replication but it doesn't have to be that way. A simple one-way-rep would match our basic interests as well. The documentation of the eRServer on postgres.com does not give very much detailed information about f.e. the integrated features - or I didn't find them.
Actually it would be nice to get an open source solution because of the very nice licence model. But our main focus is set to a _stable_ and _performant_ solution. At first we want to replicate from one Master to one slave, but in the near future it seems that the environment would extend to about five slaves.
Thanks for answering!
______________________________________________________________________________
Ab heute wird nichts mehr vergessen! Mit dem Organizer von
WEB.DE FreeMail. http://freemail.web.de/features/?mc=021145
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-23 18:53 Andrew Sullivan <andrew@libertyrms.info>
parent: Enrico Ortmann <list.pg@web.de>
0 siblings, 1 reply; 63+ messages in thread
From: Andrew Sullivan @ 2003-01-23 18:53 UTC (permalink / raw)
To: pgsql-admin
On Thu, Jan 23, 2003 at 11:38:25AM +0100, Enrico Ortmann wrote:
>
> Hi folks,
>
> Does anyone know a solution for replicating a PG7.2 Database. We'd
> prefer a bidirectional replication but it doesn't have to be that
> way. A simple one-way-rep would match our basic interests as well.
> The documentation of the eRServer on postgres.com does not give
> very much detailed information about f.e. the integrated features -
> or I didn't find them.
There's not much in the way of integrated features. More or less,
you get (possibly more than one) slave replicated from one master.
The model is async., so there is a gap between the transaction on the
master and it committing on the slave. It's a _small_ gap, but it is
there.
> the very nice licence model. But our main focus is set to a
> _stable_ and _performant_ solution. At first we want to replicate
> from one Master to one slave, but in the near future it seems that
> the environment would extend to about five slaves.
We are currently using eRServer for the .info registry, and starting
next week it will also underpin the .org registry. Dunno if that's
good enough performance for you. It works for us.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-27 18:38 Gaetano Mendola <mendola@bigfoot.com>
parent: Andrew Sullivan <andrew@libertyrms.info>
0 siblings, 1 reply; 63+ messages in thread
From: Gaetano Mendola @ 2003-01-27 18:38 UTC (permalink / raw)
To: pgsql-admin
"Andrew Sullivan" <andrew@libertyrms.info> wrote in message
news:20030123135353.E4693@mail.libertyrms.com...
> We are currently using eRServer for the .info registry, and starting
> next week it will also underpin the .org registry. Dunno if that's
> good enough performance for you. It works for us.
the eRServer is for free or not ?
Ciao
Gaetano
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-27 23:18 Andrew Sullivan <andrew@libertyrms.info>
parent: Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 1 reply; 63+ messages in thread
From: Andrew Sullivan @ 2003-01-27 23:18 UTC (permalink / raw)
To: pgsql-admin
On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote:
>
> the eRServer is for free or not ?
"Not", as far as I know. Its baby cousin is in contrib/rserv in the
source tree. I haven't tested it with 7.3, so I don't know whether
it works.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-28 04:10 Marc G. Fournier <scrappy@hub.org>
parent: Andrew Sullivan <andrew@libertyrms.info>
0 siblings, 2 replies; 63+ messages in thread
From: Marc G. Fournier @ 2003-01-28 04:10 UTC (permalink / raw)
To: Andrew Sullivan <andrew@libertyrms.info>; +Cc: pgsql-admin
On Mon, 27 Jan 2003, Andrew Sullivan wrote:
> On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote:
> >
> > the eRServer is for free or not ?
>
> "Not", as far as I know. Its baby cousin is in contrib/rserv in the
> source tree. I haven't tested it with 7.3, so I don't know whether
> it works.
Don't ... from everything we have heard, there are a half-dozen companies
out there that have taken the time to figure out and get it to work, but
nobody has bothered to submit patches back to the project to make it
easier/more useful for others ...
eRServer is to rserv what running Unix on a PIII is to running it on a 386
... for v7.4, we are most likely going to move rserv over to gborg ...
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-28 04:21 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Marc G. Fournier <scrappy@hub.org>
1 sibling, 0 replies; 63+ messages in thread
From: Bruce Momjian @ 2003-01-28 04:21 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@hub.org>; +Cc: Andrew Sullivan <andrew@libertyrms.info>; pgsql-admin
I would give /contrib/dbmirror a try.
---------------------------------------------------------------------------
Marc G. Fournier wrote:
> On Mon, 27 Jan 2003, Andrew Sullivan wrote:
>
> > On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote:
> > >
> > > the eRServer is for free or not ?
> >
> > "Not", as far as I know. Its baby cousin is in contrib/rserv in the
> > source tree. I haven't tested it with 7.3, so I don't know whether
> > it works.
>
> Don't ... from everything we have heard, there are a half-dozen companies
> out there that have taken the time to figure out and get it to work, but
> nobody has bothered to submit patches back to the project to make it
> easier/more useful for others ...
>
> eRServer is to rserv what running Unix on a PIII is to running it on a 386
> ... for v7.4, we are most likely going to move rserv over to gborg ...
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-28 16:59 Will LaShell <will@lashell.net>
parent: Marc G. Fournier <scrappy@hub.org>
1 sibling, 3 replies; 63+ messages in thread
From: Will LaShell @ 2003-01-28 16:59 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@hub.org>; +Cc: Andrew Sullivan <andrew@libertyrms.info>; pgsql-admin
On Mon, 2003-01-27 at 21:10, Marc G. Fournier wrote:
> On Mon, 27 Jan 2003, Andrew Sullivan wrote:
>
> > On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote:
> > >
> > > the eRServer is for free or not ?
> >
> > "Not", as far as I know. Its baby cousin is in contrib/rserv in the
> > source tree. I haven't tested it with 7.3, so I don't know whether
> > it works.
>
> Don't ... from everything we have heard, there are a half-dozen companies
> out there that have taken the time to figure out and get it to work, but
> nobody has bothered to submit patches back to the project to make it
> easier/more useful for others ...
>
> eRServer is to rserv what running Unix on a PIII is to running it on a 386
> ... for v7.4, we are most likely going to move rserv over to gborg ...
>
Hrmm, this is kind of sad. rserv actually does work pretty well. We use
it in a production environment here at OFS on a medium size database
cluster.
The biggest issue we had was when we created replication id's to use was
that we used bigint field type for the id. Which as we all know suck
rocks to use in postgres. Once we specifically cast the field to let it
use the index the whole thing just magically worked nice and fast. Note
that it did work before it just worked a whole lot slower.
What problems have been reported with 7.3? Additionally, aren't the
eRserver maintainers in theory releasing updates to rserv every year or
so? ( At least that's what has been said in the past. )
What problems have people been having getting rserv to work at all?
Will LaShell
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-28 18:01 Marc G. Fournier <scrappy@hub.org>
parent: Will LaShell <will@lashell.net>
2 siblings, 1 reply; 63+ messages in thread
From: Marc G. Fournier @ 2003-01-28 18:01 UTC (permalink / raw)
To: Will LaShell <will@lashell.net>; +Cc: Andrew Sullivan <andrew@libertyrms.info>; pgsql-admin
On Tue, 28 Jan 2003, Will LaShell wrote:
> Hrmm, this is kind of sad. rserv actually does work pretty well. We use
> it in a production environment here at OFS on a medium size database
> cluster.
I think you are the first person taht I've seen that has admit'd to using
it ... other then a few 'build related' issues, I've never seen anyone do
anything with it ...
> The biggest issue we had was when we created replication id's to use was
> that we used bigint field type for the id. Which as we all know suck
> rocks to use in postgres. Once we specifically cast the field to let it
> use the index the whole thing just magically worked nice and fast. Note
> that it did work before it just worked a whole lot slower.
>
> What problems have been reported with 7.3?
The biggest one I've heard: documentation sucks
> Additionally, aren't the eRserver maintainers in theory releasing
> updates to rserv every year or so? ( At least that's what has been said
> in the past. )
Actually, eRServer right now is nowhere near what you are using right now
... over the past few months, its been re-written in Java and is now
multi-slave ... I got my first "live" experience with it this past
weekend (I did alot of work on the new perl scripts for administrative,
but never had time to actually get it live) ... we used PgMarket as a
'test' case for a demo, and setup consisted of:
./ers_setup <args> (sets up master and initial slave)
and a foreach loop based on a psql -l on the database to run:
./ers_addtable <tablename>
The servers were configured so that if you pull'd the plug out of the
master server, everything auto-fail'd over to the slave, so that it was
transparent to anyone hitting the site ... we even had the web servers
themselves in a failover state ...
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-28 19:42 Fabian Peters <fabian@ngi.de>
parent: Will LaShell <will@lashell.net>
2 siblings, 1 reply; 63+ messages in thread
From: Fabian Peters @ 2003-01-28 19:42 UTC (permalink / raw)
To: pgsql-admin; +Cc: Andrew Sullivan <andrew@libertyrms.info>; Will LaShell <will@lashell.net>; Marc G. Fournier <scrappy@hub.org>
Hi folks!
Is anybody using pgReplicator? <http://pgreplicator.sourceforge.net/;
I've read through the documentation but haven't tried it yet. I'm looking
for a solution that can offer asynchronous, update-anywhere replication.
Conflict resolution is not an issue. It seems that pgReplicator would do
what is needed...
cheers
Fabian
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-28 21:12 Andrew Sullivan <andrew@libertyrms.info>
parent: Will LaShell <will@lashell.net>
2 siblings, 1 reply; 63+ messages in thread
From: Andrew Sullivan @ 2003-01-28 21:12 UTC (permalink / raw)
To: pgsql-admin
On Tue, Jan 28, 2003 at 09:59:52AM -0700, Will LaShell wrote:
> What problems have people been having getting rserv to work at all?
In 2001 I tested it for our anticipated load. It worked for me, but
it was not up to the kind of load that we were anticipating. It was
reasonable, however, and I was not able to break it; it just wasn't
up to the load I had to plan for. We also needed multi-salve
replication. We therefore did some work with PostgreSQL, Inc. to
produce a new, somewhat better version of rserv. That's what we
still use in our production systems.
So I have not had problems getting rserv to work, but it wasn't
enough for us. I wouldn't hesitate to recommend it to others,
though: the strategy is sound, and if it meets your needs, it'll
probably do fine (assuming it still works with 7.3; when I was
testing, remember, 7.1.x was the released version). I seem to recall
keeping it busy with several hundred transactions per minute, but
whether that was sustainable I don't know.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-28 23:50 Will LaShell <will@lashell.net>
parent: Marc G. Fournier <scrappy@hub.org>
0 siblings, 1 reply; 63+ messages in thread
From: Will LaShell @ 2003-01-28 23:50 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@hub.org>; +Cc: pgsql-admin
On Tue, 2003-01-28 at 11:01, Marc G. Fournier wrote:
> On Tue, 28 Jan 2003, Will LaShell wrote:
>
> > Hrmm, this is kind of sad. rserv actually does work pretty well. We use
> > it in a production environment here at OFS on a medium size database
> > cluster.
>
> I think you are the first person taht I've seen that has admit'd to using
> it ... other then a few 'build related' issues, I've never seen anyone do
> anything with it ...
Odd, for a lot of uses at least up to pg version 7.2 it just works well.
> > The biggest issue we had was when we created replication id's to use was
> > that we used bigint field type for the id. Which as we all know suck
> > rocks to use in postgres. Once we specifically cast the field to let it
> > use the index the whole thing just magically worked nice and fast. Note
> > that it did work before it just worked a whole lot slower.
> >
> > What problems have been reported with 7.3?
>
> The biggest one I've heard: documentation sucks
This truely is an issue, the documentation can be painful, however in
reality there is very little to do with it. Run the master / slave setup
add the tables, and run the replicate. I think perhaps the greatest
documentation work could be done in terms of setup examples, and more
explanation of the arguments to the various scripts.
> > Additionally, aren't the eRserver maintainers in theory releasing
> > updates to rserv every year or so? ( At least that's what has been said
> > in the past. )
>
> Actually, eRServer right now is nowhere near what you are using right now
> ... over the past few months, its been re-written in Java and is now
> multi-slave ... I got my first "live" experience with it this past
> weekend (I did alot of work on the new perl scripts for administrative,
> but never had time to actually get it live) ... we used PgMarket as a
> 'test' case for a demo, and setup consisted of:
>
> ./ers_setup <args> (sets up master and initial slave)
>
> and a foreach loop based on a psql -l on the database to run:
>
> ./ers_addtable <tablename>
>
> The servers were configured so that if you pull'd the plug out of the
> master server, everything auto-fail'd over to the slave, so that it was
> transparent to anyone hitting the site ... we even had the web servers
> themselves in a failover state ...
>
This is excellent! Now the real question is when will we see this type
of functionality released back into the community, or will there be no
future updates of rserv at all? Or?
Sincerely,
Will LaShell
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-28 23:51 Will LaShell <will@lashell.net>
parent: Fabian Peters <fabian@ngi.de>
0 siblings, 0 replies; 63+ messages in thread
From: Will LaShell @ 2003-01-28 23:51 UTC (permalink / raw)
To: Fabian Peters <fabian@ngi.de>; +Cc: pgsql-admin
On Tue, 2003-01-28 at 12:42, Fabian Peters wrote:
> Hi folks!
>
> Is anybody using pgReplicator? <http://pgreplicator.sourceforge.net/;
>
> I've read through the documentation but haven't tried it yet. I'm looking
> for a solution that can offer asynchronous, update-anywhere replication.
> Conflict resolution is not an issue. It seems that pgReplicator would do
> what is needed...
>
When I looked last it was in a very beta state and noone advised using
it for production work. This may have changed though. Usogres also is
listed as a viable replication option, but it doesn't work at all, and
has even worse documentation.
> cheers
>
> Fabian
>
Will
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-28 23:56 Will LaShell <will@lashell.net>
parent: Andrew Sullivan <andrew@libertyrms.info>
0 siblings, 0 replies; 63+ messages in thread
From: Will LaShell @ 2003-01-28 23:56 UTC (permalink / raw)
To: Andrew Sullivan <andrew@libertyrms.info>; +Cc: pgsql-admin
On Tue, 2003-01-28 at 14:12, Andrew Sullivan wrote:
> On Tue, Jan 28, 2003 at 09:59:52AM -0700, Will LaShell wrote:
> > What problems have people been having getting rserv to work at all?
>
> In 2001 I tested it for our anticipated load. It worked for me, but
> it was not up to the kind of load that we were anticipating. It was
> reasonable, however, and I was not able to break it; it just wasn't
> up to the load I had to plan for. We also needed multi-salve
> replication. We therefore did some work with PostgreSQL, Inc. to
> produce a new, somewhat better version of rserv. That's what we
> still use in our production systems.
>
> So I have not had problems getting rserv to work, but it wasn't
> enough for us. I wouldn't hesitate to recommend it to others,
> though: the strategy is sound, and if it meets your needs, it'll
> probably do fine (assuming it still works with 7.3; when I was
> testing, remember, 7.1.x was the released version). I seem to recall
> keeping it busy with several hundred transactions per minute, but
> whether that was sustainable I don't know.
>
> A
I definitely agree with this analysis. The biggest thing with getting
rserv to work fast, is using the right replication field id. We elected
to use a bigint, created an index only on it and treat it special. If I
get inspired I could post up some performance metrics if anyone cares to
be interested.
I have looked at eRserv in the past, the problem is the price. It's just
a bit high to convince the people here to use. Hopefully I can get them
to change their minds.
Sincerely,
Will LaShell
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-01-28 23:57 Marc G. Fournier <scrappy@hub.org>
parent: Will LaShell <will@lashell.net>
0 siblings, 0 replies; 63+ messages in thread
From: Marc G. Fournier @ 2003-01-28 23:57 UTC (permalink / raw)
To: Will LaShell <will@lashell.net>; +Cc: pgsql-admin
On Tue, 28 Jan 2003, Will LaShell wrote:
> > The biggest one I've heard: documentation sucks
>
> This truely is an issue, the documentation can be painful, however in
> reality there is very little to do with it. Run the master / slave setup
> add the tables, and run the replicate. I think perhaps the greatest
> documentation work could be done in terms of setup examples, and more
> explanation of the arguments to the various scripts.
would you be willing to submit such? we're working on packaging up a
7.2.4 for this week, if all goes well, and this would be nice to throw in
... ?
> This is excellent! Now the real question is when will we see this type
> of functionality released back into the community, or will there be no
> future updates of rserv at all? Or?
Worst case scenario, eRServer v1.2 (what I'm talking about here) will be
released by next Xmas(ish) ... there are some features/enhancements that
we are working on right now that will, for our clients, obsolete eRServer
v1.2, so if all goes well, releasing it to the community will happen
sooner ...
^ permalink raw reply [nested|flat] 63+ messages in thread
* Replication
@ 2003-08-30 22:39 Ian Huynh <ianh@hubspan.com>
0 siblings, 2 replies; 63+ messages in thread
From: Ian Huynh @ 2003-08-30 22:39 UTC (permalink / raw)
To: pgsql-admin
Seems that there are a number of simultaneous project in trying to implement replication
for postgres.
Is anyone out there using this feature currently? If so , which package & OS environment.
the latest news was eRServer v1.0. Is this the same as the v1.2 that Postgres INC announced
early this year ?
Is there a master-master capability or only master-multi-slave ?
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-08-30 23:47 Christopher Browne <cbbrowne@acm.org>
parent: Ian Huynh <ianh@hubspan.com>
1 sibling, 0 replies; 63+ messages in thread
From: Christopher Browne @ 2003-08-30 23:47 UTC (permalink / raw)
To: pgsql-admin
Martha Stewart called it a Good Thing whenianh@hubspan.com ("Ian Huynh")wrote:
> Seems that there are a number of simultaneous project in trying to implement replication
> for postgres.
>
> Is anyone out there using this feature currently? If so , which package & OS environment.
>
> the latest news was eRServer v1.0. Is this the same as the v1.2 that Postgres INC announced
> early this year ?
>
> Is there a master-master capability or only master-multi-slave ?
The version of eRServer recently released as free software is not the
latest "production" release, but it is a direct predecessor.
Its operational model is that of "master/possible multiple slaves,"
NOT multimaster.
Multimaster involves some thorny issues surrounding synchronization,
as it is possible for one master to receive a set of changes
concurrently with another master receiving _incompatible_ changes.
PalmOS users see this if they change a particular record on both
desktop and palmtop; the next time they sync, the conflicting record
normally gets duplicated and the user gets to decide how to fix it.
Doing that in a big production database context may not be
possible/acceptable. You only should do multimaster if you REALLY
know what you're doing.
--
select 'aa454' || '@' || 'freenet.carleton.ca';
http://www.ntlug.org/~cbbrowne/sap.html
Do you know where your towel is?
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-08-30 23:55 Marc G. Fournier <scrappy@hub.org>
parent: Ian Huynh <ianh@hubspan.com>
1 sibling, 0 replies; 63+ messages in thread
From: Marc G. Fournier @ 2003-08-30 23:55 UTC (permalink / raw)
To: Ian Huynh <ianh@hubspan.com>; +Cc: pgsql-admin
> Is anyone out there using this feature currently? If so , which package
> & OS environment.
> the latest news was eRServer v1.0. Is this the same as the v1.2 that
> Postgres INC announced early this year ?
yes, exactly the same source tree ...
> Is there a master-master capability or only master-multi-slave ?
only single master, multi-slave ...
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-09-01 03:33 Ian Huynh <ianh@hubspan.com>
0 siblings, 1 reply; 63+ messages in thread
From: Ian Huynh @ 2003-09-01 03:33 UTC (permalink / raw)
To: pgsql-admin
Thanks for all who replied.
There are certain cases where multi-master rep are very implementable such as where
the datasets being rep are fairly disjointed but need to be replicated for completeness in
terms of reporting. But you are absolutely 110% correct. Multimaster synchro is a nightmare.
-----Original Message-----
From: Christopher Browne [mailto:cbbrowne@acm.org]
Sent: Sat 8/30/2003 4:47 PM
To: pgsql-admin@postgresql.org
Cc:
Subject: Re: [ADMIN] Replication
Martha Stewart called it a Good Thing whenianh@hubspan.com ("Ian Huynh")wrote:
> Seems that there are a number of simultaneous project in trying to implement replication
> for postgres.
>
> Is anyone out there using this feature currently? If so , which package & OS environment.
>
> the latest news was eRServer v1.0. Is this the same as the v1.2 that Postgres INC announced
> early this year ?
>
> Is there a master-master capability or only master-multi-slave ?
The version of eRServer recently released as free software is not the
latest "production" release, but it is a direct predecessor.
Its operational model is that of "master/possible multiple slaves,"
NOT multimaster.
Multimaster involves some thorny issues surrounding synchronization,
as it is possible for one master to receive a set of changes
concurrently with another master receiving _incompatible_ changes.
PalmOS users see this if they change a particular record on both
desktop and palmtop; the next time they sync, the conflicting record
normally gets duplicated and the user gets to decide how to fix it.
Doing that in a big production database context may not be
possible/acceptable. You only should do multimaster if you REALLY
know what you're doing.
--
select 'aa454' || '@' || 'freenet.carleton.ca';
http://www.ntlug.org/~cbbrowne/sap.html
Do you know where your towel is?
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2003-09-02 11:34 Andrew Sullivan <andrew@libertyrms.info>
parent: Ian Huynh <ianh@hubspan.com>
0 siblings, 0 replies; 63+ messages in thread
From: Andrew Sullivan @ 2003-09-02 11:34 UTC (permalink / raw)
To: pgsql-admin
On Sun, Aug 31, 2003 at 08:33:33PM -0700, Ian Huynh wrote:
> There are certain cases where multi-master rep are very
> implementable such as where the datasets being rep are fairly
> disjointed but need to be replicated for completeness in terms of
> reporting. But you are absolutely 110% correct. Multimaster synchro
> is a nightmare.
If you had two completely separate databases, you could merge them
using erserver.
If you had some nifty tricks with unique indexes, &c., you could also
use erserver to merge them. Or at least, I think you could. Imagine
making all your unique indexes on two columns: say, the row id (just
a type serial) plus a server id (which was static for everything in
that database),
There are plenty of practical problems with such a scheme, and it
seems to me a little fragile, but it'd work.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
^ permalink raw reply [nested|flat] 63+ messages in thread
* Replication
@ 2004-08-10 13:39 Rodrigo Botana <rodrigo_botana@hotmail.com>
0 siblings, 2 replies; 63+ messages in thread
From: Rodrigo Botana @ 2004-08-10 13:39 UTC (permalink / raw)
To: pgsql-admin
There is any way to have a replication (master -> slave) whithout install anything on the slave computer. I ask this because i would like to have my website (that don't have any replication service avaliable) with the same information of my internal system.
Regards
Rodrigo
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2004-08-10 15:10 Bill Montgomery <billm@lulu.com>
parent: Rodrigo Botana <rodrigo_botana@hotmail.com>
1 sibling, 0 replies; 63+ messages in thread
From: Bill Montgomery @ 2004-08-10 15:10 UTC (permalink / raw)
To: Rodrigo Botana <rodrigo_botana@hotmail.com>; pgsql-admin
Rodrigo,
Rodrigo Botana wrote:
> There is any way to have a replication (master -> slave) whithout
> install anything on the slave computer. I ask this because i would
> like to have my website (that don't have any replication service
> avaliable) with the same information of my internal system.
In theory, the slon daemon of Slony-I (http://slony.info/) can be run on
a separate machine from the database to which it connects (it just uses
a libpq connection). With this technique, you could run the website's
slon daemon on your local box, along with the slon daemon for the
"master" database. YMMV on how well it works with the slon-->postmaster
connection over a WAN (it is typically over a local socket).
Depending on your requirements, however, Slony may be overkill. What is
the size of your data set? How many seconds/minutes/hours/days can your
website afford to be out of sync with the data on your internal system?
If you could be as much as say, a day out of date, and your data set is
less than 100MB, and you have a pretty fast connection between your
internal system and the website, you might get away with a nightly
pg_dump, piped to a psql process that connects to the pgsql server on
your website.
There are many ways to skin the replication cat, and the right one
depends on your requirements. There is no one universal solution that's
appropriate for everyone, but with more information, we could be of
better help.
Best Regards,
Bill Montgomery
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2004-08-10 17:28 Christopher Browne <cbbrowne@acm.org>
parent: Rodrigo Botana <rodrigo_botana@hotmail.com>
1 sibling, 0 replies; 63+ messages in thread
From: Christopher Browne @ 2004-08-10 17:28 UTC (permalink / raw)
To: pgsql-admin
The world rejoiced as rodrigo_botana@hotmail.com ("Rodrigo Botana") wrote:
> There is any way to have a replication (master -> slave) whithout
> install anything on the slave computer. I ask this because i would
> like to have my website (that don't have any replication service
> avaliable) with the same information of my internal system.
As far as I am aware, the only replication system that works in that
manner is eRServer; it only requires the replication triggers to be on
the server.
It's fairly likely that Slony-I will be a better solution, although it
requires that stored procedures that include components in C be
available on all nodes. That mandates having the Slony-I software
installed on your "slave" host.
--
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://www3.sympatico.ca/cbbrowne/lisp.html
"If you give a man a fish, he will eat for a day. If you teach him how
to fish, he will sit in a boat and drink beer all day."
^ permalink raw reply [nested|flat] 63+ messages in thread
* replication
@ 2005-02-14 10:51 Fred Blaise <fred.blaise@excilan.com>
0 siblings, 2 replies; 63+ messages in thread
From: Fred Blaise @ 2005-02-14 10:51 UTC (permalink / raw)
To: pgsql-admin
Hello
I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one
is a failover. I would like to implement a master-slave replication
process.
I believe replication has been included in the base package since 7.3.x.
Do you have any good pointers/how-to to direct me to?
Thanks for the help.
Best,
))fred
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication
@ 2005-02-14 12:36 Christopher Browne <cbbrowne@acm.org>
parent: Fred Blaise <fred.blaise@excilan.com>
1 sibling, 1 reply; 63+ messages in thread
From: Christopher Browne @ 2005-02-14 12:36 UTC (permalink / raw)
To: pgsql-admin
The world rejoiced as fred.blaise@excilan.com (Fred Blaise) wrote:
> Hello
>
> I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one
> is a failover. I would like to implement a master-slave replication
> process.
>
> I believe replication has been included in the base package since 7.3.x.
>
> Do you have any good pointers/how-to to direct me to?
For such cases, I believe that Slony-I is the preferred solution these
days. The comprehensive documentation may be found in CVS at gborg;
it may be found online at the URL below.
--
output = reverse("moc.liamg" "@" "enworbbc")
http://linuxdatabases.info/~cbbrowne/slony.html
"Show me... show me... show me... COMPUTERS!"
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication
@ 2005-02-14 17:40 Michael Klatt <lists.tcimk@olympus.net>
parent: Christopher Browne <cbbrowne@acm.org>
0 siblings, 0 replies; 63+ messages in thread
From: Michael Klatt @ 2005-02-14 17:40 UTC (permalink / raw)
To: pgsql-admin
Christopher Browne wrote:
> The world rejoiced as fred.blaise@excilan.com (Fred Blaise) wrote:
>
>>Hello
>>
>>I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one
>>is a failover. I would like to implement a master-slave replication
>>process.
>>
>>I believe replication has been included in the base package since 7.3.x.
>>
>>Do you have any good pointers/how-to to direct me to?
>
>
> For such cases, I believe that Slony-I is the preferred solution these
> days. The comprehensive documentation may be found in CVS at gborg;
> it may be found online at the URL below.
Hi Christopher,
I've taken a look at Slony-I and found some limitations. Unless I'm
mistaken, Slony-I can't be used to replicate users/groups, and it must
be set up for each individual database. So, for a server where users
and databases are added and removed often, then it seems like Slony-I
may not be the best choice. For simply replicating data in a limited
number of databases, then Slony-I probably performs much better than
pgpool (which has many issues of its own).
We're considering using Slony-I for some applications (where performance
is an issue and user/databases don't change often) and pgpool for others
(where we just need everything replicated).
Michael
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication
@ 2005-02-14 18:26 Joshua D. Drake <jd@commandprompt.com>
parent: Fred Blaise <fred.blaise@excilan.com>
1 sibling, 0 replies; 63+ messages in thread
From: Joshua D. Drake @ 2005-02-14 18:26 UTC (permalink / raw)
To: Fred Blaise <fred.blaise@excilan.com>; +Cc: pgsql-admin
Fred Blaise wrote:
> Hello
>
> I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one
> is a failover. I would like to implement a master-slave replication
> process.
>
> I believe replication has been included in the base package since 7.3.x.
Hello,
There are two major replication options for PostgreSQL. Once is Slony-I
and one is Mammoth Replicator. Their respective websites are here:
http://www.slony.info/
http://www.commandprompt.com/
Sincerely,
Joshua D. Drake
>
> Do you have any good pointers/how-to to direct me to?
>
> Thanks for the help.
>
> Best,
>
> ))fred
--
Command Prompt, Inc., your source for PostgreSQL replication,
professional support, programming, managed services, shared
and dedicated hosting. Home of the Open Source Projects plPHP,
plPerlNG, pgManage, and pgPHPtoolkit.
Contact us now at: +1-503-667-4564 - http://www.commandprompt.com
Attachments:
jd.vcf (text/x-vcard, 638B) download
begin:vcard
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:jd@commandprompt.com
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.
x-mozilla-html:FALSE
url:http://www.commandprompt.com/
version:2.1
end:vcard
^ permalink raw reply [nested|flat] 63+ messages in thread
* Replication
@ 2005-08-05 12:32 Marco Rademeyer <mrademeyer@pnp.co.za>
0 siblings, 2 replies; 63+ messages in thread
From: Marco Rademeyer @ 2005-08-05 12:32 UTC (permalink / raw)
To: pgsql-admin
Can PostgreSQL do replication ?
If possible could guide me in the right direction.
Regards
Marco Rademeyer
Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093?
If you don't have web access, the disclaimer can be mailed to you on request.
Disclaimer requests to be sent to it-security@pnp.co.za
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2005-08-05 13:11 Peter Eisentraut <peter_e@gmx.net>
parent: Marco Rademeyer <mrademeyer@pnp.co.za>
1 sibling, 0 replies; 63+ messages in thread
From: Peter Eisentraut @ 2005-08-05 13:11 UTC (permalink / raw)
To: Marco Rademeyer <mrademeyer@pnp.co.za>; +Cc: pgsql-admin
Am Freitag, 5. August 2005 14:32 schrieb Marco Rademeyer:
> Can PostgreSQL do replication ?
Yes.
> If possible could guide me in the right direction.
http://www.google.com/search?q=postgresql+replication
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2005-08-05 16:10 Jeff Frost <jeff@frostconsultingllc.com>
parent: Marco Rademeyer <mrademeyer@pnp.co.za>
1 sibling, 0 replies; 63+ messages in thread
From: Jeff Frost @ 2005-08-05 16:10 UTC (permalink / raw)
To: Marco Rademeyer <mrademeyer@pnp.co.za>; +Cc: pgsql-admin
On Fri, 5 Aug 2005, Marco Rademeyer wrote:
> Can PostgreSQL do replication ?
Marco,
This would probably be a good one to search for in the archives before asking,
but Slony http://slony.info/ is probably the most popular replication engine
for postgresql and command prompt has Mammoth Replicator which I have also
heard good things about: http://commandprompt.com/products/mammothreplicator/
In addition, you could probably set up a PITR based replication solution like
the one I set up for one of my clients. The general gist of the solution is
doing a base backup on a regular basis to the secondary server and archiving
the WAL files to a shared storage medium for replay.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 63+ messages in thread
* Replication
@ 2005-08-31 08:29 Jan Waiz <hamburg@icomedv.de>
0 siblings, 1 reply; 63+ messages in thread
From: Jan Waiz @ 2005-08-31 08:29 UTC (permalink / raw)
To: pgsql-admin
Hi Folks,
is it possible to make a Replication between several PostgresSQL-Databases ?
Regards
Jan Waiz
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2005-08-31 16:33 Chris Travers <chris@travelamericas.com>
parent: Jan Waiz <hamburg@icomedv.de>
0 siblings, 0 replies; 63+ messages in thread
From: Chris Travers @ 2005-08-31 16:33 UTC (permalink / raw)
To: hamburg@icomedv.de; +Cc: pgsql-admin
Jan Waiz wrote:
> Hi Folks,
>
>
>
> is it possible to make a Replication between several
> PostgresSQL-Databases ?
>
Short answer: Yes (for most cases). Long answer will depend on what
your requirements are.
What do you have in mind?
Best Wishes,
Chris Travers
Metatron Technology Consulting
>
>
> Regards
>
> Jan Waiz
>
^ permalink raw reply [nested|flat] 63+ messages in thread
* replication
@ 2005-09-02 20:11 Alain Rodriguez Arias <alainrod@gmail.com>
0 siblings, 2 replies; 63+ messages in thread
From: Alain Rodriguez Arias @ 2005-09-02 20:11 UTC (permalink / raw)
To: pgsql-admin
Please,anybody can tell me how to make replication of a PostGre DB????
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication
@ 2005-09-02 21:04 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: Alain Rodriguez Arias <alainrod@gmail.com>
1 sibling, 0 replies; 63+ messages in thread
From: Alvaro Herrera @ 2005-09-02 21:04 UTC (permalink / raw)
To: Alain Rodriguez Arias <alainrod@gmail.com>; +Cc: pgsql-admin
On Fri, Sep 02, 2005 at 04:11:35PM -0400, Alain Rodriguez Arias wrote:
> Please,anybody can tell me how to make replication of a PostGre DB????
Did you already look at Slony-I, www.slony.info ?
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"I think my standards have lowered enough that now I think 'good design'
is when the page doesn't irritate the living f*ck out of me." (JWZ)
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication
@ 2005-09-02 22:48 Chris Browne <cbbrowne@acm.org>
parent: Alain Rodriguez Arias <alainrod@gmail.com>
1 sibling, 0 replies; 63+ messages in thread
From: Chris Browne @ 2005-09-02 22:48 UTC (permalink / raw)
To: pgsql-admin
alainrod@gmail.com (Alain Rodriguez Arias) writes:
> Please,anybody can tell me how to make replication of a PostGre DB????
What do you mean by "replication?"
- If what you desire is to create a copy, then you can take a backup
and restore it somewhere else.
Read The Fine Manual if that fits your need.
<http://www.postgresql.org/docs/current/static/backup.html;
- If what you require instead is that the replica mirror the activity
that takes place on the database in which you perform updates, then
you should probably look into Slony-I. URL to documentation for that
below.
--
output = reverse("moc.enworbbc" "@" "enworbbc")
http://cbbrowne.com/info/slony.html
Rules of the Evil Overlord #67. "No matter how many shorts we have in
the system, my guards will be instructed to treat every surveillance
camera malfunction as a full-scale emergency."
<http://www.eviloverlord.com/;
^ permalink raw reply [nested|flat] 63+ messages in thread
* Replication
@ 2005-09-16 08:35 vespadict <vespadict@gmail.com>
0 siblings, 1 reply; 63+ messages in thread
From: vespadict @ 2005-09-16 08:35 UTC (permalink / raw)
To: pgsql-admin
Hello,
I need to replicate two databases in diferents servers . I'm reading
about some projects but i'm not sure what is the best option. I found
interesting dbmirror and pgcluster but I have doubts . Please , May you
help me ? .
Thanks
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2005-09-16 14:59 Scott Marlowe <smarlowe@g2switchworks.com>
parent: vespadict <vespadict@gmail.com>
0 siblings, 1 reply; 63+ messages in thread
From: Scott Marlowe @ 2005-09-16 14:59 UTC (permalink / raw)
To: vespadict@gmail.com; +Cc: pgsql-admin
On Fri, 2005-09-16 at 03:35, vespadict wrote:
> Hello,
>
> I need to replicate two databases in diferents servers . I'm reading
> about some projects but i'm not sure what is the best option. I found
> interesting dbmirror and pgcluster but I have doubts . Please , May you
> help me ? .
Do you need automatic failover of some kind, async or sync replication,
one way or two way, etc...
My personal favorite two tools of late have been pgpool and slony.
dbmirror, if I remember correctly, has to be installed by modifying the
internals of postgresql, and I'm not sure how up to date it is.
Pgcluster seems to be a decent choice, but I've not played with it.
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2005-09-19 07:02 the vespadict <vespadict@gmail.com>
parent: Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 1 reply; 63+ messages in thread
From: the vespadict @ 2005-09-19 07:02 UTC (permalink / raw)
To: Scott Marlowe <smarlowe@g2switchworks.com>; +Cc: pgsql-admin
Hi ,
I want high Availability but I don't need load balance. I need sync
replication if is posible using two way.
Thak you.
2005/9/16, Scott Marlowe <smarlowe@g2switchworks.com>:
> On Fri, 2005-09-16 at 03:35, vespadict wrote:
> > Hello,
> >
> > I need to replicate two databases in diferents servers . I'm reading
> > about some projects but i'm not sure what is the best option. I found
> > interesting dbmirror and pgcluster but I have doubts . Please , May you
> > help me ? .
>
> Do you need automatic failover of some kind, async or sync replication,
> one way or two way, etc...
>
> My personal favorite two tools of late have been pgpool and slony.
> dbmirror, if I remember correctly, has to be installed by modifying the
> internals of postgresql, and I'm not sure how up to date it is.
> Pgcluster seems to be a decent choice, but I've not played with it.
>
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2005-09-19 20:24 Scott Marlowe <smarlowe@g2switchworks.com>
parent: the vespadict <vespadict@gmail.com>
0 siblings, 1 reply; 63+ messages in thread
From: Scott Marlowe @ 2005-09-19 20:24 UTC (permalink / raw)
To: vespadict@gmail.com; +Cc: pgsql-admin
On Mon, 2005-09-19 at 02:02, the vespadict wrote:
> Hi ,
>
> I want high Availability but I don't need load balance. I need sync
> replication if is posible using two way.
If you need sync, then pgpool may be a good choice, or client side
replication like C-JDBC or something like that.
pgpool doesn't HAVE to do load balancing, it can do simple two way sync
replication if that's what you need.
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2005-09-20 17:28 Jim C. Nasby <jnasby@pervasive.com>
parent: Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 1 reply; 63+ messages in thread
From: Jim C. Nasby @ 2005-09-20 17:28 UTC (permalink / raw)
To: Scott Marlowe <smarlowe@g2switchworks.com>; +Cc: vespadict@gmail.com; pgsql-admin
There's also pgcluster, but keep in mind that these are all
statement-level replication solutions which have some rather big
gotchas.
On Mon, Sep 19, 2005 at 03:24:31PM -0500, Scott Marlowe wrote:
> On Mon, 2005-09-19 at 02:02, the vespadict wrote:
> > Hi ,
> >
> > I want high Availability but I don't need load balance. I need sync
> > replication if is posible using two way.
>
> If you need sync, then pgpool may be a good choice, or client side
> replication like C-JDBC or something like that.
>
> pgpool doesn't HAVE to do load balancing, it can do simple two way sync
> replication if that's what you need.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2005-09-20 17:50 Craig Servin <cservin@cromagnon.com>
parent: Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 63+ messages in thread
From: Craig Servin @ 2005-09-20 17:50 UTC (permalink / raw)
To: pgsql-admin
Are there any non-statement level solution? Something that appends to the WAL
on the slave server?
On Tuesday 20 September 2005 12:28 pm, Jim C. Nasby wrote:
> There's also pgcluster, but keep in mind that these are all
> statement-level replication solutions which have some rather big
> gotchas.
>
> On Mon, Sep 19, 2005 at 03:24:31PM -0500, Scott Marlowe wrote:
> > On Mon, 2005-09-19 at 02:02, the vespadict wrote:
> > > Hi ,
> > >
> > > I want high Availability but I don't need load balance. I need sync
> > > replication if is posible using two way.
> >
> > If you need sync, then pgpool may be a good choice, or client side
> > replication like C-JDBC or something like that.
> >
> > pgpool doesn't HAVE to do load balancing, it can do simple two way sync
> > replication if that's what you need.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2005-09-23 09:12 Aldor <an@mediaroot.de>
parent: Craig Servin <cservin@cromagnon.com>
0 siblings, 0 replies; 63+ messages in thread
From: Aldor @ 2005-09-23 09:12 UTC (permalink / raw)
To: pgsql-admin
>Are there any non-statement level solution? Something that appends to
the WAL
>> on the slave server?
For this kind of solution I'm also looking for a while - but in the
meantime you can also take a look at "slony" - it can do really many
things. Don't give up at the beginning, after you've understood how it
works you will like it ;-)
Craig Servin wrote:
> Are there any non-statement level solution? Something that appends to the WAL
> on the slave server?
>
>
>
> On Tuesday 20 September 2005 12:28 pm, Jim C. Nasby wrote:
>
>>There's also pgcluster, but keep in mind that these are all
>>statement-level replication solutions which have some rather big
>>gotchas.
>>
>>On Mon, Sep 19, 2005 at 03:24:31PM -0500, Scott Marlowe wrote:
>>
>>>On Mon, 2005-09-19 at 02:02, the vespadict wrote:
>>>
>>>>Hi ,
>>>>
>>>>I want high Availability but I don't need load balance. I need sync
>>>>replication if is posible using two way.
>>>
>>>If you need sync, then pgpool may be a good choice, or client side
>>>replication like C-JDBC or something like that.
>>>
>>>pgpool doesn't HAVE to do load balancing, it can do simple two way sync
>>>replication if that's what you need.
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 1: if posting/reading through Usenet, please send an appropriate
>>> subscribe-nomail command to majordomo@postgresql.org so that your
>>> message can get through to the mailing list cleanly
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
^ permalink raw reply [nested|flat] 63+ messages in thread
* replication?
@ 2006-11-13 21:21 TomDB <tomdb@uk2.net>
0 siblings, 1 reply; 63+ messages in thread
From: TomDB @ 2006-11-13 21:21 UTC (permalink / raw)
To: pgsql-admin
I'd like to create a setup where there are exactly 2 masters which
need to be synchronized against each other. The two masters should
have read+write access, but don't have a permanent connection to each
other. One will be on a LAN-server, the other instance will be
installed on a Windows-client-laptop which can be taken along the
road. When coming back to the office, we need to sync the changed
data.
is there any tool that will allow me to do so ?
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication?
@ 2006-11-14 17:18 Jim C. Nasby <jim@nasby.net>
parent: TomDB <tomdb@uk2.net>
0 siblings, 2 replies; 63+ messages in thread
From: Jim C. Nasby @ 2006-11-14 17:18 UTC (permalink / raw)
To: TomDB <tomdb@uk2.net>; +Cc: pgsql-admin
On Mon, Nov 13, 2006 at 10:21:40PM +0100, TomDB wrote:
>
> I'd like to create a setup where there are exactly 2 masters which
> need to be synchronized against each other. The two masters should
> have read+write access, but don't have a permanent connection to each
> other. One will be on a LAN-server, the other instance will be
> installed on a Windows-client-laptop which can be taken along the
> road. When coming back to the office, we need to sync the changed
> data.
>
> is there any tool that will allow me to do so ?
If you got *really* clever you could maybe pull it off with Slony, but
in general, no, this isn't possible.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication?
@ 2006-11-14 20:58 TomDB <tomdb@uk2.net>
parent: Jim C. Nasby <jim@nasby.net>
1 sibling, 0 replies; 63+ messages in thread
From: TomDB @ 2006-11-14 20:58 UTC (permalink / raw)
To: pgsql-admin
hmm - I was hoping to have it in a database supported by PHP,
preferably freely available. MySQL would be OK too, but I didn't find
it there either.
Strange, cause to my knowledge 'even' MS Access offers it - I used it
before in the Access 97 version. And Access it not what I'd call a
decent database.
> [Offline multi master replication]
>> If you got *really* clever you could maybe pull it off with Slony, but
>> in general, no, this isn't possible.
> If this is an option, FrontBase offers support for that. You might
> contact them directly.
> http://www.frontbase.com
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication?
@ 2006-11-14 21:10 TomDB <tomdb@uk2.net>
parent: Jim C. Nasby <jim@nasby.net>
1 sibling, 1 reply; 63+ messages in thread
From: TomDB @ 2006-11-14 21:10 UTC (permalink / raw)
To: pgsql-admin
would there be any default available field (like the OID of the
records) that would be unique in the two versions of the datbase?
there isn't "by accident" something like a unique UID like an MD5 or
something... ?
cause if there is no replication available, I'd consider this
(together with PHP)
a) replacing the serial fields by generated UID's (md5 of ID + a
string that depends on the install)
or
b) start the autoincrement field at a high number in the second
install (since I can estimate that there will never by > 10 000
records)
+ store all queries that were performed & run them in the
network-master afterwards.
>>
>> I'd like to create a setup where there are exactly 2 masters which
>> need to be synchronized against each other. The two masters should
>> have read+write access, but don't have a permanent connection to each
>> other. One will be on a LAN-server, the other instance will be
>> installed on a Windows-client-laptop which can be taken along the
>> road. When coming back to the office, we need to sync the changed
>> data.
>>
>> is there any tool that will allow me to do so ?
> If you got *really* clever you could maybe pull it off with Slony, but
> in general, no, this isn't possible.
--
Best regards,
TomDB mailto:tomdb@uk2.net
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: replication?
@ 2006-11-16 19:12 Naz Gassiep <naz@mira.net>
parent: TomDB <tomdb@uk2.net>
0 siblings, 0 replies; 63+ messages in thread
From: Naz Gassiep @ 2006-11-16 19:12 UTC (permalink / raw)
To: TomDB <tomdb@uk2.net>; +Cc: pgsql-admin
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Why not just have a primary key with 2 columns, one of which is a
serial and the other is a "siteid" or "installid" that is different for
each server?<br>
<br>
TomDB wrote:
<blockquote cite="mid1807736772.20061114221053@uk2.net" type="cite">
<pre wrap="">would there be any default available field (like the OID of the
records) that would be unique in the two versions of the datbase?
there isn't "by accident" something like a unique UID like an MD5 or
something... ?
cause if there is no replication available, I'd consider this
(together with PHP)
a) replacing the serial fields by generated UID's (md5 of ID + a
string that depends on the install)
or
b) start the autoincrement field at a high number in the second
install (since I can estimate that there will never by > 10 000
records)
+ store all queries that were performed & run them in the
network-master afterwards.
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">I'd like to create a setup where there are exactly 2 masters which
need to be synchronized against each other. The two masters should
have read+write access, but don't have a permanent connection to each
other. One will be on a LAN-server, the other instance will be
installed on a Windows-client-laptop which can be taken along the
road. When coming back to the office, we need to sync the changed
data.
is there any tool that will allow me to do so ?
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->
</pre>
<blockquote type="cite">
<pre wrap="">If you got *really* clever you could maybe pull it off with Slony, but
in general, no, this isn't possible.
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>
^ permalink raw reply [nested|flat] 63+ messages in thread
* Replication
@ 2007-01-04 09:00 anorganic anorganic <anorganicphc@gmail.com>
0 siblings, 2 replies; 63+ messages in thread
From: anorganic anorganic @ 2007-01-04 09:00 UTC (permalink / raw)
To: pgsql-admin
Hello,
i need make with postgre something as this:
i have two servers S1 and S2, connection is quit good, but sometimes once
or twice per month there is short disconnection, longer discoonection 2x per
year (1-2+ hours)
on both are running updates
i need have same data in time, but i never update same collumns on S1 an S2,
S1 change another atributes than S2 = there are no conflicts, on MS SQL i
use transactional replication and i like find somethin same for postgre.
Can u please send me some info where can i found what i need, which postgre
tool is right way for me..
Thnx a lot.
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2007-01-04 09:04 Shoaib Mir <shoaibmir@gmail.com>
parent: anorganic anorganic <anorganicphc@gmail.com>
1 sibling, 0 replies; 63+ messages in thread
From: Shoaib Mir @ 2007-01-04 09:04 UTC (permalink / raw)
To: anorganic anorganic <anorganicphc@gmail.com>; +Cc: pgsql-admin
Did you try Slony with PostgreSQL?
--------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/4/07, anorganic anorganic <anorganicphc@gmail.com> wrote:
>
> Hello,
>
> i need make with postgre something as this:
>
> i have two servers S1 and S2, connection is quit good, but sometimes once
> or twice per month there is short disconnection, longer discoonection 2x per
> year (1-2+ hours)
> on both are running updates
> i need have same data in time, but i never update same collumns on S1 an
> S2, S1 change another atributes than S2 = there are no conflicts, on MS SQL
> i use transactional replication and i like find somethin same for postgre.
>
> Can u please send me some info where can i found what i need, which
> postgre tool is right way for me..
>
> Thnx a lot.
>
>
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2007-01-04 09:13 Markus Schiltknecht <markus@bluegap.ch>
parent: anorganic anorganic <anorganicphc@gmail.com>
1 sibling, 1 reply; 63+ messages in thread
From: Markus Schiltknecht @ 2007-01-04 09:13 UTC (permalink / raw)
To: anorganic anorganic <anorganicphc@gmail.com>; +Cc: pgsql-admin
Hi,
did you check the manual about 'High Availability and Load Balancing"?
http://www.postgresql.org/docs/8.2/static/high-availability.html
Regards
Markus
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2007-01-04 10:07 Markus Schiltknecht <markus@bluegap.ch>
parent: Markus Schiltknecht <markus@bluegap.ch>
0 siblings, 1 reply; 63+ messages in thread
From: Markus Schiltknecht @ 2007-01-04 10:07 UTC (permalink / raw)
To: anorganic anorganic <anorganicphc@gmail.com>; +Cc: pgsql-admin
Hi,
anorganic anorganic wrote:
>> did you check the manual about 'High Availability and Load
>> Balancing"?
>> http://www.postgresql.org/docs/8.2/static/high-availability.html
>
> yes but this was really short i think.
Interesting... where exactly is it to short for you? What else would you
expect?
> I need that: s1 and s2 must be multimaster replication asyn. but make
> replication in real time. Changes are immediately send to second server.
Slony can probably be used for such a setup, although it's primarily
designed for single master, async replication.
> OR: s1 is master s2 slave, s1 change some columns on s2, and s2 is
> master s1
> slave and s2 change another columns in one time.
I don't quite follow what you mean here. I assume you mean rows, not
columns. Then probably you mean something like what we call data
partitioning, where each server is a master for a certain subset of the
data.
> I read about slony but, it looks that's make changes not immediatly but in
> packages = not send one transaction but wait and send package. This
> could be a problem.
Hm. If that really is a problem, think again about sync vs. async. In
async replication, there is a delay by definition. But again, I'm not
sure what Slony can do to minimize that delay.
> I hope slony online system is right for me. And these question
> about slony i have more than one i think it could be rigth way. Somebody
> who run it could be great person for me :).
Probably ask on the slony mailing list. I'm not exactly a slony expert
either.
Regards
Markus
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2007-01-04 12:00 Markus Schiltknecht <markus@bluegap.ch>
parent: Markus Schiltknecht <markus@bluegap.ch>
0 siblings, 1 reply; 63+ messages in thread
From: Markus Schiltknecht @ 2007-01-04 12:00 UTC (permalink / raw)
To: anorganic anorganic <anorganicphc@gmail.com>; +Cc: pgsql-admin
Hi,
[ please keep CCing to the list (reply all), as this certainly isn't a
personal discussion and could help others. ]
anorganic anorganic wrote:
> Hello,
>
> "I don't quite follow what you mean here. I assume you mean rows, not
> columns. Then probably you mean something like what we call data
> partitioning, where each server is a master for a certain subset of the
> data."
>
> I think granurality, some system allow replicate only all db, all table,
> some allow to choose only 4 colums from one table 2 from another and
> replicated only these parts of db. I can add example.
> it's not partitioning.
Uhm.. I'd still call it partitioning. Although, I'm not exactly sure why
you want to replicate only a partial row. I suspect you will have to
split into two tables and have one table replicated while not
replicating the other.
> "Interesting... where exactly is it to short for you? What else would you
> expect?"
>
> ok may be i'm false but i think this all is not common features of postgre
> and it's necessary use system as slony.
> i want know what i must use, how i can make and detail description of these
> solution. What's happen when connection crash, when server shutdown etc.
Right, but as we only have external solutions, I think it makes sense to
have them document how exactly they work and behave.
> "Hm. If that really is a problem, think again about sync vs. async. In
> async replication, there is a delay by definition. But again, I'm not
> sure what Slony can do to minimize that delay."
>
> yeah may be i am on bad adress but may be somebody here will say me here i
> used this program fort his solution. Or this problem have no solution on
> postgre.
I fear replication is such a wide field with that many options, you
probably can't get away with a general approach. I especially think so
because I consider your wishes to be quite exotic for two reasons:
* realtime, as fast as possible, but certainly not sync
(You are aware that async, no matter how fast, can lead to conflicts,
aren't you?)
* replicating only parts of a row
> Async, sync i dont need sync, but i need send change fast as possible. i
> don't want sync. But when i change col on s1 i wnat send change right now,
> no waiting for another 5 changes. It must be quite realtime we have low
> traffic between servers there is not necessary make some optimilaztion as
> sending in packages.
I'd be surprised if Slony couldn't be configured to send changes
immediately (i.e. not waiting for more transactions before sending a
package). But again, the Slony guys may know better.
Regards
Markus
^ permalink raw reply [nested|flat] 63+ messages in thread
* Re: Replication
@ 2007-01-05 10:42 Markus Schiltknecht <markus@bluegap.ch>
parent: Markus Schiltknecht <markus@bluegap.ch>
0 siblings, 0 replies; 63+ messages in thread
From: Markus Schiltknecht @ 2007-01-05 10:42 UTC (permalink / raw)
To: anorganic anorganic <anorganicphc@gmail.com>; +Cc: pgsql-admin
Hi,
[ please keep CCing to the list (reply all), as this certainly isn't a
personal discussion and could help others. ]
anorganic anorganic wrote:
> my opinion:
> partitioning is vertical and horizontal, dived table into two or more
> parts.
>
> replicated only part of some object,here table = replicated two columns
> ins't partitioning, because table is same ;) and have one part = self table
> ;)
The main point is, you divide data *somehow* into partitions and grant
write rights to only *one* server for each partition, thus allowing you
to use a simpler master-slave replication.
> i want have
> s1 and s2
> tableA
> col1
> col2
> col3
>
> tableA is on s1 and s2 same design
> s1 change only col1, s2 change only col3
> is possible set replication on s1 only for col1 of tableA
> is possible set replication on s2 only for col3 of tableA
>
> this is not partitioning i think
How else would you call it? In what way is it different from what's
commonly known as vertical partitioning?
Couldn't you do what you want with the help of ordinary vertical
partitioning and using a VIEW viewA with all the columns col1, col2, col3?
> ok, sync is not saying something about when is transaction log send...
Uhm.. yes it does. It has to be sent before commit confirmation is sent
to the client (Postgres-R does some optimization here, but basically the
above statement still holds true). It is the async approach, which
doesn't say anything about when changes are sent to other servers.
> sync said: i coimmit transaction when all slaves send me commit :)
> asynch: i make change i commit this change and i send it to my slave. and i
> want do it fast as possible ;)
No matter *how* fast you do that, conflicts can arise if you don't
prevent them somehow.
The requirement to send changes as fast as possible in async replication
rings my alarm bell, because it sounds like your application cannot cope
with conflicts and wants to prevent them by minimizing the propagation
delays. That's prone to race conditions and probably won't work.
However, if you partition your data vertically and do per-table
master-slave replication, you of course don't have to worry about
conflicts, as there is only exactly one master.
Regards
Markus
^ permalink raw reply [nested|flat] 63+ messages in thread
end of thread, other threads:[~2007-01-05 10:42 UTC | newest]
Thread overview: 63+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-11 01:55 Replication XWorkers <xworkers@bangla.net>
2001-07-03 10:26 replication "Jean-Sébastien ANDUJAR" <jandujar@transiciel.com>
2001-07-13 16:19 replication Srinivasa Rao Chava <s.chava@wcom.com>
2001-08-30 10:33 ` Re: replication Egon Reetz <reetz@usco.de>
2002-01-10 22:27 replication Peter T. Brown <peter@memeticsystems.com>
2002-01-10 23:34 ` Re: [SQL] replication Bryan White <bryan@arcamax.com>
2002-01-10 23:35 ` Re: replication David Stanaway <david@netventures.com.au>
2002-01-10 23:25 Re: replication Arguile <arguile@lucentstudios.com>
2002-01-24 17:05 Replication Clinton Adams <clinton@vote-smart.org>
2002-02-11 18:24 Replication...??? James Kelty <jamesk@ashlandagency.com>
2002-04-28 02:58 replication Doug Needham <dneedham@pbo.net>
2003-01-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
2003-01-23 18:53 ` Andrew Sullivan <andrew@libertyrms.info>
2003-01-27 18:38 ` Gaetano Mendola <mendola@bigfoot.com>
2003-01-27 23:18 ` Andrew Sullivan <andrew@libertyrms.info>
2003-01-28 04:10 ` Marc G. Fournier <scrappy@hub.org>
2003-01-28 04:21 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-01-28 16:59 ` Will LaShell <will@lashell.net>
2003-01-28 18:01 ` Marc G. Fournier <scrappy@hub.org>
2003-01-28 23:50 ` Will LaShell <will@lashell.net>
2003-01-28 23:57 ` Marc G. Fournier <scrappy@hub.org>
2003-01-28 19:42 ` Fabian Peters <fabian@ngi.de>
2003-01-28 23:51 ` Will LaShell <will@lashell.net>
2003-01-28 21:12 ` Andrew Sullivan <andrew@libertyrms.info>
2003-01-28 23:56 ` Will LaShell <will@lashell.net>
2003-08-30 22:39 Replication Ian Huynh <ianh@hubspan.com>
2003-08-30 23:47 ` Christopher Browne <cbbrowne@acm.org>
2003-08-30 23:55 ` Marc G. Fournier <scrappy@hub.org>
2003-09-01 03:33 Re: Replication Ian Huynh <ianh@hubspan.com>
2003-09-02 11:34 ` Andrew Sullivan <andrew@libertyrms.info>
2004-08-10 13:39 Replication Rodrigo Botana <rodrigo_botana@hotmail.com>
2004-08-10 15:10 ` Bill Montgomery <billm@lulu.com>
2004-08-10 17:28 ` Christopher Browne <cbbrowne@acm.org>
2005-02-14 10:51 replication Fred Blaise <fred.blaise@excilan.com>
2005-02-14 12:36 ` Re: replication Christopher Browne <cbbrowne@acm.org>
2005-02-14 17:40 ` Re: replication Michael Klatt <lists.tcimk@olympus.net>
2005-02-14 18:26 ` Re: replication Joshua D. Drake <jd@commandprompt.com>
2005-08-05 12:32 Replication Marco Rademeyer <mrademeyer@pnp.co.za>
2005-08-05 13:11 ` Peter Eisentraut <peter_e@gmx.net>
2005-08-05 16:10 ` Jeff Frost <jeff@frostconsultingllc.com>
2005-08-31 08:29 Replication Jan Waiz <hamburg@icomedv.de>
2005-08-31 16:33 ` Chris Travers <chris@travelamericas.com>
2005-09-02 20:11 replication Alain Rodriguez Arias <alainrod@gmail.com>
2005-09-02 21:04 ` Re: replication Alvaro Herrera <alvherre@alvh.no-ip.org>
2005-09-02 22:48 ` Re: replication Chris Browne <cbbrowne@acm.org>
2005-09-16 08:35 Replication vespadict <vespadict@gmail.com>
2005-09-16 14:59 ` Scott Marlowe <smarlowe@g2switchworks.com>
2005-09-19 07:02 ` the vespadict <vespadict@gmail.com>
2005-09-19 20:24 ` Scott Marlowe <smarlowe@g2switchworks.com>
2005-09-20 17:28 ` Jim C. Nasby <jnasby@pervasive.com>
2005-09-20 17:50 ` Craig Servin <cservin@cromagnon.com>
2005-09-23 09:12 ` Aldor <an@mediaroot.de>
2006-11-13 21:21 replication? TomDB <tomdb@uk2.net>
2006-11-14 17:18 ` Re: replication? Jim C. Nasby <jim@nasby.net>
2006-11-14 20:58 ` Re: replication? TomDB <tomdb@uk2.net>
2006-11-14 21:10 ` Re: replication? TomDB <tomdb@uk2.net>
2006-11-16 19:12 ` Re: replication? Naz Gassiep <naz@mira.net>
2007-01-04 09:00 Replication anorganic anorganic <anorganicphc@gmail.com>
2007-01-04 09:04 ` Shoaib Mir <shoaibmir@gmail.com>
2007-01-04 09:13 ` Markus Schiltknecht <markus@bluegap.ch>
2007-01-04 10:07 ` Markus Schiltknecht <markus@bluegap.ch>
2007-01-04 12:00 ` Markus Schiltknecht <markus@bluegap.ch>
2007-01-05 10:42 ` Markus Schiltknecht <markus@bluegap.ch>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox