Thread: BUG #4770: Error initializing slon in command line and hence running Slony

The following bug has been logged online:

Bug reference:      4770
Logged by:          Quincy
Email address:      qj_qwerty@hotmail.com
PostgreSQL version: 8.3.7
Operating system:   Windows Vista
Description:        Error initializing slon in command line and hence
running Slony
Details:

Hello everyone, I tried to find a solution for a few days now on an error
that kept occuring after

trying to install & run slony-1 immediately after installing postgres DB
system.

What kept on happening after installing slony-1 via the stackbuilder and
then testing the slon

service in command line was an error containing the following:
"The procedure entry point libiconv_set_relocation_prefix could not be
located in the dynamic link

library libiconv-2.dll".

Windows log had this in the error report:
libiconv-2.dll!libiconv_set_relocation_prefix

It took a while to realise that when I install slony-1, it creates and
overwrites the file libiconv

-2.dll found in the bin of the postgres installation folder. The only
difference between the files

are their size & date created.

What I found as a work around was to first stop the posgres service, then
use the libiconv-2.dll

(947kb) originally installed by postgres and by either renaming or moving
that file to then

overwrite the libiconv-2.dll created by the slony installation. Meaning, the
file that should remain

for everything to work is the original libiconv-2.dll (947kb) created by the
postgres installation.

If this error was already addressed please let me know as I really was
trying to find a solution to

the above problem and could not find one suitable.
On Tue, Apr 21, 2009 at 8:22 PM, Quincy <qj_qwerty@hotmail.com> wrote:
>
> What I found as a work around was to first stop the posgres service, then
> use the libiconv-2.dll
>
> (947kb) originally installed by postgres and by either renaming or moving
> that file to then
>
> overwrite the libiconv-2.dll created by the slony installation. Meaning, the
> file that should remain
>
> for everything to work is the original libiconv-2.dll (947kb) created by the
> postgres installation.

Can you try this installer update please?
http://developer.pgadmin.org/~dpage/Slony_I_PG83-1.2.15.msi

It should be installed into the server directory - for example,
C:\Program Files\PostgreSQL\8.3.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com