BUG #8001: Cannot install Slony - Mailing list pgsql-bugs

From eimbassahy@yahoo.com.br
Subject BUG #8001: Cannot install Slony
Date
Msg-id E1UKxZ2-00019j-6b@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8001: Cannot install Slony
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8001
Logged by:          Eduardo
Email address:      eimbassahy@yahoo.com.br
PostgreSQL version: 8.4.11
Operating system:   windows7  Home Premium SP1 i64
Description:        =


I,m trying to install the Slony in my Postgres 8.4.

I,ve copied the binaries to the directory \"Program Files
(x86)"\Postgresql\8.4\

when try to register the servive using the command line "slon -regservice
Slony-I" I've got the error "Failed to create service: 1057" that means the
account use have no privileges to do that. Then I've register the service
usin the "sc" command: -- "sc create Slony-I binPath=3D "c:\Program Files
(x86)\PostgreSQL\8.4\bin\slon.exe -service" depend=3D "RPCSS"".
This worked.

Then I've created the pgbench schema in my database using de command
"pgbench -i -U postgres master -P postgres -p 5432" and included the the
primary key in the history table.

I've created the master and slave configuration files

cluster_name=3D'pgbench'
conn_info=3D'host=3D127.0.0.1 port=3D5432 user=3Dpostgres dbname=3DMaster' =


then added both in Slony confivuration with the comand line
slon -addengine Slony-I C:\slony\master.conf
slon -addengine Slony-I C:\slony\slave.conf

Restarted the Slony-I service.

Changed the Slony path to "C:\Program Files (x86)\PostgreSQL\8.4\share"

Tried to create a Slony cluster under the master database.

cluster name: pgbench
Local node: 1 master
Admin node: 99 Admin

press <OK> and got an error

type "_pgbench.xxid" does not exist.

I need help to anderstand what is hapening, how to install the Slony and how
to create the .xxid type.

thanks.

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Re: BUG #7969: Postgres Recovery Fatal With: "incorrect local pin count:2"
Next
From: Tom Lane
Date:
Subject: Re: Re: BUG #7969: Postgres Recovery Fatal With: "incorrect local pin count:2"