Thread: synchroniztaion, mirroring system that wokrs on cygwin?

synchroniztaion, mirroring system that wokrs on cygwin?

From
RK
Date:
Hi All!

I'm Robert Kuszinger, new to the list but not
to Postgresql. I'm using it undex windows for more than
one years for my small company ans backeng for Web and
other applications.

Now I'd like to make a synchronized two-database instance setup.

One should run out on the internet, and on in-house in the office.
The two databases should contain the same data.

Purpose:

-security
-fast in-house analysis

the outer one would be the master...

However, it would be nice that in certain cases the in-house
instance would be the master.

Do you know ANY WORKING solutiong for Cygwin?

I tryed to install

SLONY and also ERSERVER, but was not successful.
(For example, the build for the latest beta didn't run, some help
files were missing...

What version is necessary?
I have a big practice in changing versions :)

thanks in advance

Robert



Re: synchroniztaion, mirroring system that wokrs on cygwin?

From
"Mike G."
Date:
Did you build your Cygwin from source?  That is one of the requirements for slony.  I am not familiar with the other
one.  

I haven't seen anyone mention they used Slony on Cygwin.  Maybe Postgres 8.0 will be your solution when it runs on
Windowsdirectly. 

Until then maybe some type of data dump / restore or copy to / copy from scripts will meet your needs until then.

MIke

On Mon, Oct 18, 2004 at 04:08:10PM +0200, RK wrote:
> Hi All!
>
> I'm Robert Kuszinger, new to the list but not
> to Postgresql. I'm using it undex windows for more than
> one years for my small company ans backeng for Web and
> other applications.
>
> Now I'd like to make a synchronized two-database instance setup.
>
> One should run out on the internet, and on in-house in the office.
> The two databases should contain the same data.
>
> Purpose:
>
> -security
> -fast in-house analysis
>
> the outer one would be the master...
>
> However, it would be nice that in certain cases the in-house
> instance would be the master.
>
> Do you know ANY WORKING solutiong for Cygwin?
>
> I tryed to install
>
> SLONY and also ERSERVER, but was not successful.
> (For example, the build for the latest beta didn't run, some help
> files were missing...
>
> What version is necessary?
> I have a big practice in changing versions :)
>
> thanks in advance
>
> Robert
>
>
>
> ---------------------------(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