Re: [PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

2009-06-12 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > Currently we use dump (to SQL file, i.e. pg_dump with no args) + file copy > to replicate the DB daily between the staging and web servers, and then > restore (

Re: [PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

2009-06-12 Thread Shaul Dar
All right, so I misspelled Bucardo (also Mammoth...), and the company's name is Command Prompt (please get someone to work on that incomprehensible logo - I went back and looked at it and still have no clue what it means :-). Now how about some serious answers relating to my questions? Dimitri, t

Re: [PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

2009-06-11 Thread Joshua D. Drake
On Thu, 2009-06-11 at 16:30 +, Greg Sabino Mullane wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: RIPEMD160 > > >> Then there are Slony-I, Buchardo, Mamoth Replicator from CMO, simple > >> replication in Postgres 8.4 and other projects... > > > CMO? :) > > Buchardo? :) A new desert, Bu

Re: [PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

2009-06-11 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 >> Then there are Slony-I, Buchardo, Mamoth Replicator from CMO, simple >> replication in Postgres 8.4 and other projects... > CMO? :) Buchardo? :) - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation PGP Key: 0x14964AC8 200906111

Re: [PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

2009-06-11 Thread Joshua D. Drake
> > Then there are Slony-I, Buchardo, Mamoth Replicator from CMO, simple > replication in Postgres 8.4 and other projects... CMO? :) Joshua D. Drake > > Suggestions? > Thanks, > > -- Shaul > -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training

Re: [PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

2009-06-11 Thread Dimitri Fontaine
Hi, Shaul Dar writes: > 1. A staging server, which receives new data and updates the DB > 2. Two web servers that have copies of the DB (essentially read-only) > and answer user queries (with load balancer) [...] > Suggestions? I'd consider WAL Shipping for the staging server and some trigger

[PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

2009-06-11 Thread Shaul Dar
Hi, Our configuration is as follows: 1. A staging server, which receives new data and updates the DB 2. Two web servers that have copies of the DB (essentially read-only) and answer user queries (with load balancer) Currently we use dump (to SQL file, i.e. pg_dump with no args) + file copy to re

Re: [PERFORM] Postgres replication

2008-05-01 Thread Fujii Masao
On Thu, May 1, 2008 at 5:47 AM, <[EMAIL PROTECTED]> wrote: > I'm about to setup a similar config and what I was intending to do is to > run pgpool on both boxes and use heartbeat (from http://linux-ha.org ) to > move an IP address from one box to the other. clients connect to this > virtual IP an

Re: [PERFORM] Postgres replication

2008-04-30 Thread david
On Wed, 30 Apr 2008, Gernot Schwed wrote: Hi all, looking for a HA master/master or master/slave replication solution. Our setup consists of two databases and we want to use them both for queries. Aside from pgpool II there seems no advisable replication solution. But the problem seems to be

[PERFORM] Postgres replication

2008-04-30 Thread Gernot Schwed
Hi all, looking for a HA master/master or master/slave replication solution. Our setup consists of two databases and we want to use them both for queries. Aside from pgpool II there seems no advisable replication solution. But the problem seems to be that we will have a single point of failure