Hi Wolfgang-san.

Umm, It is very strange....
However, you have a problem actually. sorry, I don't have have margin time till
a weekend. other someone may have early solution.

and,
Thanks! to peter-san.!

Regards,
Hiroshi Saito

----- Original Message ----- 
From: <rissler.wolfgang at freenet.de>
To: "Hiroshi Saito" <z-saito at guitar.ocn.ne.jp>
Sent: Wednesday, August 12, 2009 3:37 PM
Subject: Re: Re: question about slony 2.0.2 binaries for Windows and pg 8.3


Hello Mr. Saito,

Thank you for answering.
Yes, the Path is exactly as you described.
I tryed 3 Variants:
1) I took a raw new pg8.3 (added PostGIS support what brings
libiconv-2.dll to PostgreSQL8.4bin, which is needed
for slonik to run) and copied your files in it.
I followed the instruction from Peter Geoghegan
to create the MinGW path and put slony*.sql script in it.
2) In this gp8.3 I installed a slony 1.2 with Stackbuilder
then I overrided the 1.2 files with your  rev2.0.2
(Because there could be some registration of slony
while installation in conf files or registry)
3) I removed pg 8.3 and installed pg 8.4 and copied your
binaries for pg84 in it. Same message:

single_init_cluster.slonik:5: PGRES_FATAL_ERROR load '$libdir/slony1_funcs';  -
FEHLER:  konnte Bibliothek C:/Programme/PostgreSQL/8.4/lib/slony1_funcs.dll
nicht laden: unknown error 5 single_init_cluster.slonik:5: Error: the extension
for the Slony-I C functions c annot be loaded in database 'dbname=abcde
host=xxxxx user=slonyuser password=**'

(FEHLER:  konnte Bibliothek C:/Programme/PostgreSQL/8.4/lib/slony1_funcs.dll
nicht laden:
German for :
ERROR could not load library: C:/Programme/PostgreSQL/8.4/lib/slony1_funcs.dll
)

The same scripts worked with Slony 1.2 and pg8.3.
Your slon.exe 2.0.2 also runs fine.
When I understand the message right, so the postgres-server has to load
the dll but cant do this for some reason.

I also tried to preload the slony1_func.dll with option in
postgres.conf with
shared_preload_libraries and
local_preload_libraries.
Then the message changes to: access denied to slony1_func.

I'm shure that the path to dll ist right:
 C:/Programme/PostgreSQL/8.4/lib/slony1_funcs.dll
the load must fail for another reason.

Interesting, that a part of the message is in german.
It seem to be genarated fom the system or postgres, what I
switched to locale germany while installation.

Do I have to tell the database or the database-server in
any way to load the dlls?
Or do I need something from MinGW or GnuWin32 in my system?

Peter Geoghegan answered me, that it works fine at his Vista
System, and this seems to be the only difference
I'm using WinXP SP3.

Maybe you have any idea what things make running.
If you need athor information abaout my system or I should do
some tests here, please let me know.

Regards,
Wolfgang Rißler

----- original Nachricht --------

Betreff: Re: question about slony 2.0.2 binaries for Windows and pg 8.3
Gesendet: Di 11 Aug 2009 15:52:50 CEST
Von: "Hiroshi Saito"<z-saito at guitar.ocn.ne.jp>

> Hi Wolfgang-san.
>
> Um, Is Installation path arranged as follows?
>
> /8.3
> /bin
>     pthreadGC2.dll
>     slon.exe
>     slonik.exe
> /lib
>     slevent.dll
>     slony1_funcs.dll
> /share
>     slony1_base.sql
>     slony1_funcs.sql
>     slony1_funcs.v83.sql
>     slony1_base.v83.sql
>
> Regards,
> Hiroshi Saito
[snip]