|
|
 | | From: | Harm van der Ploeg | | Subject: | PostgreSQL replication on Windows | | Date: | Thu, 20 Jan 2005 12:14:02 +0100 |
|
|
 | Are there any replication solutions that have been tested on
Windows. The options listed on the PostgreSQL site all require
Linux/Unix or are only available as source. I am not able to
compile these sources.
Harm van der Ploeg
Relitech BV
---------------------------(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
|
|
| | From: | Robert Treat | | Subject: | Re: PostgreSQL replication on Windows | | Date: | Fri, 21 Jan 2005 07:28:11 -0500 |
|
|
| On Thursday 20 January 2005 06:14, Harm van der Ploeg wrote:
> Are there any replication solutions that have been tested on
> Windows. The options listed on the PostgreSQL site all require
> Linux/Unix or are only available as source. I am not able to
> compile these sources.
>
I think all of the open source ones require *nix, although I think you could
set up slony on a central machine and use it to replicate remote windows
servers if you wanted. If your willing to pay for such software, I believe
command prompt has plans to port thier system (mammoth replicator) to
windows, so you might want to contact them.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
|
|
| | From: | Christopher Browne | | Subject: | Re: PostgreSQL replication on Windows | | Date: | Sun, 23 Jan 2005 08:41:47 -0500 |
|
|
| Martha Stewart called it a Good Thing when xzilla@users.sourceforge.net (Robert Treat) wrote:
> On Thursday 20 January 2005 06:14, Harm van der Ploeg wrote:
>> Are there any replication solutions that have been tested on
>> Windows. The options listed on the PostgreSQL site all require
>> Linux/Unix or are only available as source. I am not able to
>> compile these sources.
>
> I think all of the open source ones require *nix, although I think
> you could set up slony on a central machine and use it to replicate
> remote windows servers if you wanted. If your willing to pay for
> such software, I believe command prompt has plans to port thier
> system (mammoth replicator) to windows, so you might want to contact
> them.
All the replication systems I know of require some compiled code
running on all servers.
For Slony-I to function, for instance, requires having some triggers
implemented in C which would therefore have to be compiled on Windows.
The same is true for the "open source" version of eRServer.
--
select 'cbbrowne' || '@' || 'ntlug.org';
http://www3.sympatico.ca/cbbrowne/multiplexor.html
The IQ of the group is the lowest IQ of a member of the group divided
by the number of people in the group.
|
|
| | From: | Christopher Browne | | Subject: | Re: PostgreSQL replication on Windows | | Date: | Sun, 23 Jan 2005 08:38:51 -0500 |
|
|
| The world rejoiced as harm.van.der.ploeg@relitech.nl (Harm van der Ploeg) wrote:
> Are there any replication solutions that have been tested on
> Windows. The options listed on the PostgreSQL site all require
> Linux/Unix or are only available as source. I am not able to
> compile these sources.
In the case of Slony-I, no one has yet volunteered to add such a port.
As one of the Slony-I developers, while I don't oppose such a port, I
have neither the access to Windows(tm) nor the interest in usage on
Windows(tm) that would be required for me to put effort into it. I'm
already quite busy enough with other things. The same appears to be
true of the other developers, as well.
If you consider it valuable, you'll have to find someone to do the
port. That may mean needing to pay someone money to do the work.
This sort of thing is liable to be an ongoing problem for use of
PostgreSQL on Windows(tm); there are a number of PostgreSQL extensions
that require the ability to compile from source, and it is
unfortunately quite common for Windows(tm)-based users to be pretty
helpless in this fashion.
As an alternative, I believe that Command Prompt's "Mammoth
Replicator" has been ported to run on Windows; you may want to enquire
about it and see if its properties are suitable for your purposes.
--
select 'cbbrowne' || '@' || 'acm.org';
http://cbbrowne.com/info/slony.html
If the FreeBSD team could get away with it, they would probably use
warnings like "Contains live plague bacteria. Beware the Rabid
Hippopotami. May cause nausea and vomiting."
-- Michael Lucas, re: FreeBSD-CURRENT
|
|
|
