BUG #8001: Cannot install Slony
От | eimbassahy@yahoo.com.br |
---|---|
Тема | BUG #8001: Cannot install Slony |
Дата | |
Msg-id | E1UKxZ2-00019j-6b@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #8001: Cannot install Slony
|
Список | 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 по дате отправления: