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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBCEIKWAoNJCRuR6rYRAlhUAKC5l74E6IiPOOgJInX+x1 JV8G4UMwCfbsd7
J0vGbyrjcjpzhtQNbSQmZnY=
=3aRU
-----END PGP SIGNATURE-----

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!"

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




---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

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



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org