Postgres Pro
Downloads
Home   >   mailing lists

Thread: replication

replication

From
Fred Blaise
Date:
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
Attachment

Re: replication

From
Christopher Browne
Date:
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!"

Re: replication

From
Michael Klatt
Date:
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

Re: replication

From
"Joshua D. Drake"
Date:
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
Attachment