pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Replication
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>
  2001-08-30 10:33 ` Re: replication Egon Reetz <reetz@usco.de>
  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-07-13 16:19 replication Srinivasa Rao Chava <s.chava@wcom.com>
@ 2001-08-30 10:33 ` Egon Reetz <reetz@usco.de>
  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>
  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>
  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: [SQL] replication
  2002-01-10 22:27 replication Peter T. Brown <peter@memeticsystems.com>
@ 2002-01-10 23:34 ` Bryan White <bryan@arcamax.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 22:27 replication Peter T. Brown <peter@memeticsystems.com>
@ 2002-01-10 23:35 ` David Stanaway <david@netventures.com.au>
  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

* 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

* 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>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  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 10:38 Replication Enrico Ortmann <list.pg@web.de>
@ 2003-01-23 18:53 ` Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
@ 2003-01-27 18:38   ` Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication 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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
@ 2003-01-27 23:18     ` Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 04:10       ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
@ 2003-01-28 04:10       ` Marc G. Fournier <scrappy@hub.org>
  2003-01-28 04:21         ` Re: Replication Bruce Momjian <pgman@candle.pha.pa.us>
  2003-01-28 16:59         ` Re: Replication Will LaShell <will@lashell.net>
  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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 04:10       ` Re: Replication Marc G. Fournier <scrappy@hub.org>
@ 2003-01-28 04:21         ` Bruce Momjian <pgman@candle.pha.pa.us>
  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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 04:10       ` Re: Replication Marc G. Fournier <scrappy@hub.org>
@ 2003-01-28 16:59         ` Will LaShell <will@lashell.net>
  2003-01-28 18:01           ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  2003-01-28 19:42           ` Re: Replication Fabian Peters <fabian@ngi.de>
  2003-01-28 21:12           ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 04:10       ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  2003-01-28 16:59         ` Re: Replication Will LaShell <will@lashell.net>
@ 2003-01-28 18:01           ` Marc G. Fournier <scrappy@hub.org>
  2003-01-28 23:50             ` Re: Replication 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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 04:10       ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  2003-01-28 16:59         ` Re: Replication Will LaShell <will@lashell.net>
  2003-01-28 18:01           ` Re: Replication Marc G. Fournier <scrappy@hub.org>
@ 2003-01-28 23:50             ` Will LaShell <will@lashell.net>
  2003-01-28 23:57               ` Re: Replication 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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 04:10       ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  2003-01-28 16:59         ` Re: Replication Will LaShell <will@lashell.net>
  2003-01-28 18:01           ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  2003-01-28 23:50             ` Re: Replication Will LaShell <will@lashell.net>
@ 2003-01-28 23:57               ` Marc G. Fournier <scrappy@hub.org>
  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

* Re: Replication
  2003-01-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 04:10       ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  2003-01-28 16:59         ` Re: Replication Will LaShell <will@lashell.net>
@ 2003-01-28 19:42           ` Fabian Peters <fabian@ngi.de>
  2003-01-28 23:51             ` Re: Replication 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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 04:10       ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  2003-01-28 16:59         ` Re: Replication Will LaShell <will@lashell.net>
  2003-01-28 19:42           ` Re: Replication Fabian Peters <fabian@ngi.de>
@ 2003-01-28 23:51             ` Will LaShell <will@lashell.net>
  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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 04:10       ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  2003-01-28 16:59         ` Re: Replication Will LaShell <will@lashell.net>
@ 2003-01-28 21:12           ` Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 23:56             ` Re: Replication 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-23 10:38 Replication Enrico Ortmann <list.pg@web.de>
  2003-01-23 18:53 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-27 18:38   ` Re: Replication Gaetano Mendola <mendola@bigfoot.com>
  2003-01-27 23:18     ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  2003-01-28 04:10       ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  2003-01-28 16:59         ` Re: Replication Will LaShell <will@lashell.net>
  2003-01-28 21:12           ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
@ 2003-01-28 23:56             ` Will LaShell <will@lashell.net>
  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

* Replication
@ 2003-08-30 22:39 Ian Huynh <ianh@hubspan.com>
  2003-08-30 23:47 ` Re: Replication Christopher Browne <cbbrowne@acm.org>
  2003-08-30 23:55 ` Re: Replication Marc G. Fournier <scrappy@hub.org>
  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 22:39 Replication Ian Huynh <ianh@hubspan.com>
@ 2003-08-30 23:47 ` Christopher Browne <cbbrowne@acm.org>
  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 22:39 Replication Ian Huynh <ianh@hubspan.com>
@ 2003-08-30 23:55 ` Marc G. Fournier <scrappy@hub.org>
  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>
  2003-09-02 11:34 ` Re: Replication Andrew Sullivan <andrew@libertyrms.info>
  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-01 03:33 Re: Replication Ian Huynh <ianh@hubspan.com>
@ 2003-09-02 11:34 ` Andrew Sullivan <andrew@libertyrms.info>
  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>
  2004-08-10 15:10 ` Re: Replication Bill Montgomery <billm@lulu.com>
  2004-08-10 17:28 ` Re: Replication Christopher Browne <cbbrowne@acm.org>
  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 13:39 Replication Rodrigo Botana <rodrigo_botana@hotmail.com>
@ 2004-08-10 15:10 ` Bill Montgomery <billm@lulu.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 13:39 Replication Rodrigo Botana <rodrigo_botana@hotmail.com>
@ 2004-08-10 17:28 ` Christopher Browne <cbbrowne@acm.org>
  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>
  2005-02-14 12:36 ` Re: replication Christopher Browne <cbbrowne@acm.org>
  2005-02-14 18:26 ` Re: replication Joshua D. Drake <jd@commandprompt.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 10:51 replication Fred Blaise <fred.blaise@excilan.com>
@ 2005-02-14 12:36 ` Christopher Browne <cbbrowne@acm.org>
  2005-02-14 17:40   ` Re: replication Michael Klatt <lists.tcimk@olympus.net>
  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 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   ` Michael Klatt <lists.tcimk@olympus.net>
  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 10:51 replication Fred Blaise <fred.blaise@excilan.com>
@ 2005-02-14 18:26 ` Joshua D. Drake <jd@commandprompt.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>
  2005-08-05 13:11 ` Re: Replication Peter Eisentraut <peter_e@gmx.net>
  2005-08-05 16:10 ` Re: Replication Jeff Frost <jeff@frostconsultingllc.com>
  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 12:32 Replication Marco Rademeyer <mrademeyer@pnp.co.za>
@ 2005-08-05 13:11 ` Peter Eisentraut <peter_e@gmx.net>
  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 12:32 Replication Marco Rademeyer <mrademeyer@pnp.co.za>
@ 2005-08-05 16:10 ` Jeff Frost <jeff@frostconsultingllc.com>
  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>
  2005-08-31 16:33 ` Re: Replication Chris Travers <chris@travelamericas.com>
  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 08:29 Replication Jan Waiz <hamburg@icomedv.de>
@ 2005-08-31 16:33 ` Chris Travers <chris@travelamericas.com>
  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>
  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>
  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 20:11 replication Alain Rodriguez Arias <alainrod@gmail.com>
@ 2005-09-02 21:04 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
  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 20:11 replication Alain Rodriguez Arias <alainrod@gmail.com>
@ 2005-09-02 22:48 ` Chris Browne <cbbrowne@acm.org>
  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>
  2005-09-16 14:59 ` Re: Replication Scott Marlowe <smarlowe@g2switchworks.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 08:35 Replication vespadict <vespadict@gmail.com>
@ 2005-09-16 14:59 ` Scott Marlowe <smarlowe@g2switchworks.com>
  2005-09-19 07:02   ` Re: Replication the 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-16 08:35 Replication vespadict <vespadict@gmail.com>
  2005-09-16 14:59 ` Re: Replication Scott Marlowe <smarlowe@g2switchworks.com>
@ 2005-09-19 07:02   ` the vespadict <vespadict@gmail.com>
  2005-09-19 20:24     ` Re: Replication 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-16 08:35 Replication vespadict <vespadict@gmail.com>
  2005-09-16 14:59 ` Re: Replication Scott Marlowe <smarlowe@g2switchworks.com>
  2005-09-19 07:02   ` Re: Replication the vespadict <vespadict@gmail.com>
@ 2005-09-19 20:24     ` Scott Marlowe <smarlowe@g2switchworks.com>
  2005-09-20 17:28       ` Re: Replication Jim C. Nasby <jnasby@pervasive.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-16 08:35 Replication vespadict <vespadict@gmail.com>
  2005-09-16 14:59 ` Re: Replication Scott Marlowe <smarlowe@g2switchworks.com>
  2005-09-19 07:02   ` Re: Replication the vespadict <vespadict@gmail.com>
  2005-09-19 20:24     ` Re: Replication Scott Marlowe <smarlowe@g2switchworks.com>
@ 2005-09-20 17:28       ` Jim C. Nasby <jnasby@pervasive.com>
  2005-09-20 17:50         ` Re: Replication Craig Servin <cservin@cromagnon.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-16 08:35 Replication vespadict <vespadict@gmail.com>
  2005-09-16 14:59 ` Re: Replication Scott Marlowe <smarlowe@g2switchworks.com>
  2005-09-19 07:02   ` Re: Replication the vespadict <vespadict@gmail.com>
  2005-09-19 20:24     ` Re: Replication Scott Marlowe <smarlowe@g2switchworks.com>
  2005-09-20 17:28       ` Re: Replication Jim C. Nasby <jnasby@pervasive.com>
@ 2005-09-20 17:50         ` Craig Servin <cservin@cromagnon.com>
  2005-09-23 09:12           ` Re: Replication Aldor <an@mediaroot.de>
  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-16 08:35 Replication vespadict <vespadict@gmail.com>
  2005-09-16 14:59 ` Re: Replication Scott Marlowe <smarlowe@g2switchworks.com>
  2005-09-19 07:02   ` Re: Replication the vespadict <vespadict@gmail.com>
  2005-09-19 20:24     ` Re: Replication Scott Marlowe <smarlowe@g2switchworks.com>
  2005-09-20 17:28       ` Re: Replication Jim C. Nasby <jnasby@pervasive.com>
  2005-09-20 17:50         ` Re: Replication Craig Servin <cservin@cromagnon.com>
@ 2005-09-23 09:12           ` Aldor <an@mediaroot.de>
  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>
  2006-11-14 17:18 ` Re: replication? Jim C. Nasby <jim@nasby.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-13 21:21 replication? TomDB <tomdb@uk2.net>
@ 2006-11-14 17:18 ` 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>
  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-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   ` TomDB <tomdb@uk2.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-13 21:21 replication? TomDB <tomdb@uk2.net>
  2006-11-14 17:18 ` Re: replication? Jim C. Nasby <jim@nasby.net>
@ 2006-11-14 21:10   ` TomDB <tomdb@uk2.net>
  2006-11-16 19:12     ` Re: replication? Naz Gassiep <naz@mira.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-13 21:21 replication? TomDB <tomdb@uk2.net>
  2006-11-14 17:18 ` Re: replication? Jim C. Nasby <jim@nasby.net>
  2006-11-14 21:10   ` Re: replication? TomDB <tomdb@uk2.net>
@ 2006-11-16 19:12     ` Naz Gassiep <naz@mira.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 &gt; 10 000
records)

+ store all queries that were performed &amp; 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>
  2007-01-04 09:04 ` Re: Replication Shoaib Mir <shoaibmir@gmail.com>
  2007-01-04 09:13 ` Re: Replication Markus Schiltknecht <markus@bluegap.ch>
  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:00 Replication anorganic anorganic <anorganicphc@gmail.com>
@ 2007-01-04 09:04 ` Shoaib Mir <shoaibmir@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:00 Replication anorganic anorganic <anorganicphc@gmail.com>
@ 2007-01-04 09:13 ` Markus Schiltknecht <markus@bluegap.ch>
  2007-01-04 10:07   ` Re: Replication Markus Schiltknecht <markus@bluegap.ch>
  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 09:00 Replication anorganic anorganic <anorganicphc@gmail.com>
  2007-01-04 09:13 ` Re: Replication Markus Schiltknecht <markus@bluegap.ch>
@ 2007-01-04 10:07   ` Markus Schiltknecht <markus@bluegap.ch>
  2007-01-04 12:00     ` Re: Replication 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 09:00 Replication anorganic anorganic <anorganicphc@gmail.com>
  2007-01-04 09:13 ` Re: Replication Markus Schiltknecht <markus@bluegap.ch>
  2007-01-04 10:07   ` Re: Replication Markus Schiltknecht <markus@bluegap.ch>
@ 2007-01-04 12:00     ` Markus Schiltknecht <markus@bluegap.ch>
  2007-01-05 10:42       ` Re: Replication 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-04 09:00 Replication anorganic anorganic <anorganicphc@gmail.com>
  2007-01-04 09:13 ` Re: Replication Markus Schiltknecht <markus@bluegap.ch>
  2007-01-04 10:07   ` Re: Replication Markus Schiltknecht <markus@bluegap.ch>
  2007-01-04 12:00     ` Re: Replication Markus Schiltknecht <markus@bluegap.ch>
@ 2007-01-05 10:42       ` 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