I appreciate your help.  I realize that you may have other responsibilities, so doubly appreciate it.

All of my databases use UTF8 encoding, so that shouldn't be a problem.

I don't understand what you mean by "both of time must not be different".  Perhaps you meant that they should be the same version; the Windows host is running "PostgeSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)", the Linux host is running "PostgeSQL 8.2.4 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 (Red Hat 4.1.1-51)".  This seems like as close to the same version as is feasible for Windows/Linux, so I hope it's close enough.

The linux host has:

ll /usr/lib/pgsql/xxid.so
-rwxr-xr-x 1 root root 30059 Oct 17 15:01 /usr/lib/pgsql/xxid.so

The windows host doesn't have an xxid.so file.  I don't understand why it would be desirable for the Windows host to have a .so file.  It does have quite a few .dll files in C:\Program Files\PostgreSQL\8.2\lib, but there is no xxid.dll file among them.  I had assumed that the install package would include it.

The installation of PostgreSQL on Windows was updated from an earlier version.  There was no attempt to install Slony as part of that, but it might have been part of the package.  The update was done from a file named postgresql-8.2.msi that came in a package labeled postgresql-8.2.4-1 .  I didn't make any changes to the registry, but the installer might have.

I got the installer from http://developer.pgadmin.org/~hiroshi/Slony-I/slony-I-1.2.11R-pg82.zip and was following the screen shots at http://developer.pgadmin.org/~hiroshi/Slony-I/ .  Things looked pretty much like the screen shots until I got to the sixth one ("Installation Complete").  My screen had " Module C:\Program Files\PostgreSQL\8.2\lib\slevent.dll failed to register.", instead.

Just now, I installed the Slony-I feature from the postgresql-8.2.msi script.  That installs without error and does deliver an xxid.dll file to C:\Program Files\PostgreSQL\8.2\lib, but the Slony msi still throws an "slevent.dll failed" error and initializing the cluster from Linux still throws an "access to library" error.

I had assumed that I would be able to initialize the cluster and run the slons on a Linux host; please correct me if I've made a mistaken assumption.

Thank you

Walter Coole
 
Aperio Group, LLC
Three Harbor Drive Suite 315
Sausalito, CA 94965
(415)339-4308 Direct
(415)339-4301 Fax
www.aperiogroup.com
 
Aperio v. [Latin] to make clear, to reveal the truth
The information contained in this e-mail may be privileged and/or confidential, and is intended only for the use of the person to whom it is addressed. If you are not the named addressee (or such recipient's employee or agent), you should not disseminate, distribute, alter or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmissions cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender, therefore, does not accept liability for any errors or omissions in the contents of this message, which may arise during or as a result of e-mail transmission. Communication of any portfolio changes, cash additions or withdrawals must always be confirmed or verified by verbal and/or hard copy version. In compliance with regulatory requirements, all messages sent to or from this server are archived and may be read by someone other than the recipient. This message is provided for information purposes and has been obtained from sources which we believe to be reliable, but we do not guarantee its accuracy or completeness and it should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments in any jurisdiction. Aperio Group LLC provides neither tax nor legal advice to its clients, and all investors are strongly urged to consult with their legal and tax advisors regarding any potential investment or strategy.

-----Original Message-----
From: Hiroshi Saito [mailto:z-saito at guitar.ocn.ne.jp] 
Sent: Sunday, November 11, 2007 5:52 PM
To: Walter Coole
Cc: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] Windows as master, Linux as slave


Hi.

Sorry, late reaction..

> ----- Original Message ----- 
> From: Walter Coole
> To: slony1-general at lists.slony.info
> Sent: Saturday, November 10, 2007 11:11 AM
> Subject: [Slony1-general] Windows as master, Linux as slave
>
>
> Has anyone gotten replication from Windows to Linux running?  If so, can you help a newby
> out?

Yes, The form can be used without a problem.!
However, you need to be conscious of ENCODING. And both of time must not be different.

>
> Having gotten replication between Linux hosts working, I thought I knew what I was doing.
> When I tried to configure the cluster with Windows as the master, I got errors like:
>
> PGRES_FATAL_ERROR load '$libdir/xxid';  - ERROR:  access to library "$libdir/xxid" is not
> allowed

Does xxid.so (lib) exist in the lib directory of Linux and Windows of you?

>
> Eventually, it sunk in that I needed to install Slony on the Windows host.  I downloaded 
> the
> installer at http://developer.pgadmin.org/~hiroshi/Slony-I/slony-I-1.2.11R-pg82.zip .  It
> throws the error:
>
> Module C:\Program Files\PostgreSQL\8.2\lib\slevent.dll failed to register.
> HRESULT -2147023898.  Contact your support personnel.

Um, I don't reproduce the problem....:-(
The new windows installer of 8.2 contained Slony. Then, Did you already register Slony into
the registry, before installing again?

>
> Being my own "support personnel", I'm stuck.
>
> Thanks for any help you can offer.
>
> Walter Coole

I want in detail the procedure and environment which you performed.

Regards,
Hiroshi Saito