pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg replication tools?
5+ messages / 5 participants
[nested] [flat]

* pg replication tools?
@ 2004-12-02 14:38  sarlav kumar <sarlavk@yahoo.com>
  0 siblings, 3 replies; 5+ messages in thread

From: sarlav kumar @ 2004-12-02 14:38 UTC (permalink / raw)
  To: pgsql-performance

Hi all,
 
Which is the best available PG replication tool in market now? 
 
From searching on the internet, I found some resources on the following tools used for replication :
 

   postgres –R  
   Usogres
   eRServer/Rserv/Dbmirror 
   PgReplicator 
   Mammoth PostgreSQL Replicator  
   Slony-I

Which one of these is a good option for replicating Postgres 7.3.2?

 

Thanks again,

Saranya

		
---------------------------------
Do you Yahoo!?
 Read only the mail you want - Yahoo! Mail SpamGuard.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: pg replication tools?
@ 2004-12-02 16:50  Joshua D. Drake <jd@commandprompt.com>
  parent: sarlav kumar <sarlavk@yahoo.com>
  2 siblings, 1 reply; 5+ messages in thread

From: Joshua D. Drake @ 2004-12-02 16:50 UTC (permalink / raw)
  To: sarlav kumar <sarlavk@yahoo.com>; +Cc: pgsql-performance

sarlav kumar wrote:

> Hi all,
>  
> Which is the best available PG replication tool in market now?

There is no "best", there is only best for your situation. The two
most supported are:


>     * Mammoth PostgreSQL Replicator  
>     * Slony-I
>
> Which one of these is a good option for replicating Postgres 7.3.2?
>

Mammoth PostgreSQL Replicator will automatically upgrade you to 7.3.8 
which you should be running anyway.

I believe Slony will work with 7.3.2.

Sincerely,

Joshua D. Drake



>  
>
> Thanks again,
>
> Saranya
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Read only the mail you want - Yahoo! Mail SpamGuard 
> <http://us.rd.yahoo.com/mail_us/taglines/spamguard/*http://promotions.yahoo.com/new_mail/static/prote...;. 




-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachments:

jd.vcf (text/x-vcard, 283B) download begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard
^ permalink raw reply [nested|flat] 5+ messages in thread

* Re: pg replication tools?
@ 2004-12-02 16:58  Darcy Buskermolen <darcy@wavefire.com>
  parent: sarlav kumar <sarlavk@yahoo.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Darcy Buskermolen @ 2004-12-02 16:58 UTC (permalink / raw)
  To: sarlav kumar <sarlavk@yahoo.com>; +Cc: pgsql-performance

On December 2, 2004 06:38 am, sarlav kumar wrote:
> Hi all,
>
> Which is the best available PG replication tool in market now?
>
> From searching on the internet, I found some resources on the following
> tools used for replication :
>
>
>    postgres –R
>    Usogres
>    eRServer/Rserv/Dbmirror
>    PgReplicator
>    Mammoth PostgreSQL Replicator
>    Slony-I
>
> Which one of these is a good option for replicating Postgres 7.3.2?

What are your needs in a replication solution? for example, do you need to be 
able to replicate a running install with out needing to initdb, do you want 
to be able to replicate across versions; do you require sync or will async 
work, etc..

>
>
>
> Thanks again,
>
> Saranya
>
>
> ---------------------------------
> Do you Yahoo!?
>  Read only the mail you want - Yahoo! Mail SpamGuard.

-- 
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: pg replication tools?
@ 2004-12-03 02:39  Christopher Browne <cbbrowne@acm.org>
  parent: Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Christopher Browne @ 2004-12-03 02:39 UTC (permalink / raw)
  To: pgsql-performance

Clinging to sanity, jd@commandprompt.com ("Joshua D. Drake") mumbled into her beard:
> sarlav kumar wrote:
>
>> Hi all,
>>  Which is the best available PG replication tool in market now?
>
> There is no "best", there is only best for your situation. The two
> most supported are:
>
>
>>     * Mammoth PostgreSQL Replicator      * Slony-I
>>
>> Which one of these is a good option for replicating Postgres 7.3.2?
>>
>
> Mammoth PostgreSQL Replicator will automatically upgrade you to
> 7.3.8 which you should be running anyway.
>
> I believe Slony will work with 7.3.2.

No, it won't.

I believe there was something about namespace support that did not
stabilize until PostgreSQL 7.3.3, and Slony-I works with that version,
at the earliest.

And you're quite right; "best" is a slippery metric.  Like many
things, it may be altered by perspective.
-- 
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne; rate me
http://www3.sympatico.ca/cbbrowne/postgresql.html
I can see clearly now, the brain is gone... 



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: pg replication tools?
@ 2004-12-03 05:16  Vishal Kashyap @ [SaiHertz] <vishalonlist@gmail.com>
  parent: sarlav kumar <sarlavk@yahoo.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Vishal Kashyap @ [SaiHertz] @ 2004-12-03 05:16 UTC (permalink / raw)
  To: sarlav kumar <sarlavk@yahoo.com>; +Cc: pgsql-performance

Go for Slony its best thing to start with.


On Thu, 2 Dec 2004 06:38:16 -0800 (PST), sarlav kumar <sarlavk@yahoo.com> wrote:
> 
> Hi all, 
>   
> Which is the best available PG replication tool in market now? 
>   
> From searching on the internet, I found some resources on the following
> tools used for replication : 
>   
> postgres –R  
> Usogres 
> eRServer/Rserv/Dbmirror 
> PgReplicator 
> Mammoth PostgreSQL Replicator   
> Slony-I 
> 
> Which one of these is a good option for replicating Postgres 7.3.2? 
> 
>   
> 
> Thanks again, 
> 
> Saranya
> 
>  ________________________________
> Do you Yahoo!?
>  Read only the mail you want - Yahoo! Mail SpamGuard. 
> 
> 


-- 
With Best Regards,
Vishal Kashyap.
Lead Software Developer,
http://saihertz.com,
http://vishalkashyap.tk



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2004-12-03 05:16 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-02 14:38 pg replication tools? sarlav kumar <sarlavk@yahoo.com>
2004-12-02 16:50 ` Joshua D. Drake <jd@commandprompt.com>
2004-12-03 02:39   ` Christopher Browne <cbbrowne@acm.org>
2004-12-02 16:58 ` Darcy Buskermolen <darcy@wavefire.com>
2004-12-03 05:16 ` Vishal Kashyap @ [SaiHertz] <vishalonlist@gmail.com>

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