Hi,
I am struck with a problm could anyone help me out here plz..
I have a problem while replicating my database in same machine via PgAdmin
on Windows, When I try to initiate a new Slony cluster in the PgAdmin
interface, the status-bar says "Slony-I creation scripts not available; only
joining possible" .. where OK remains greyed out..thtz it ..
As i have followed the below steps , Plz do chk whatz wrong below:
- I 've started with Installation of PostgreSQL 8.4 and run Application
Stack Builder to add Replication : Slony-I support.
- Start pgAdmin
III, File ->
Options, setup the Slony-I Path C:\Program Files\PostgreSQL\8.4\share , But
the problem still persists with same error("Slony-I creation scripts not
available; only joining possible").
- set the eventlog
pgsql\lib>regsvr32 slevent.dll
---register the service
- pgsql\bin>slon -regservice Slony-I
- pgsql\bin>slon -addengine Slony-I C:\Program Files\PostgreSQL\8.4\
master.conf <http://developer.pgadmin.org/%7Ehiroshi/Slony-I/master.conf>
pgsql\bin>slon -addengine Slony-I C:\Program Files\PostgreSQL\8.4\
slave.conf <http://developer.pgadmin.org/%7Ehiroshi/Slony-I/slave.conf>
later tried replacing the slony installation directory
- pgsql\bin>slon -addengine Slony-I C:\Program
Files\PostgreSQL\8.4\slony\master.conf<http://developer.pgadmin.org/%7Ehiroshi/Slony-I/master.conf>
pgsql\bin>slon -addengine Slony-I C:\Program Files\PostgreSQL\8.4\slony\
slave.conf <http://developer.pgadmin.org/%7Ehiroshi/Slony-I/slave.conf>
pgsql\bin>slon -listengines Slony-I----------when i execute this i get
0 engine(s) registered for service 'Slony-I'
any solution for this ? plz do help me..As i am also trying to sortout
using sysinternals procmon to trouble shoot it.
Thanks and Regards,
Reshma
