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.