Re: pg replication tools?

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.

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/protection.html>.

--
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(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

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

Clinging to sanity, jd(at)commandprompt(dot)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...

Go for Slony its best thing to start with.

On Thu, 2 Dec 2004 06:38:16 -0800 (PST), sarlav kumar <sarlavk(at)yahoo(dot)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