From: | eimbassahy(at)yahoo(dot)com(dot)br |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #8001: Cannot install Slony |
Date: | 2013-03-27 21:07:20 |
Message-ID: | E1UKxZ2-00019j-6b@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 8001
Logged by: Eduardo
Email address: eimbassahy(at)yahoo(dot)com(dot)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= "c:\Program Files
(x86)\PostgreSQL\8.4\bin\slon.exe -service" depend= "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='pgbench'
conn_info='host=127.0.0.1 port=5432 user=postgres dbname=Master'
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-03-27 21:28:07 | Re: Re: BUG #7969: Postgres Recovery Fatal With: "incorrect local pin count:2" |
Previous Message | Heikki Linnakangas | 2013-03-27 19:48:33 | Re: Re: BUG #7969: Postgres Recovery Fatal With: "incorrect local pin count:2" |