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
- pgsql\bin>slon -regservice Slony-I
- pgsql\bin>slon -addengine Slony-I C:\Program
Files\PostgreSQL\8.4\master.conf
pgsql\bin>slon -addengine Slony-I C:\Program Files\PostgreSQL\8.4\slave.conf
- pgsql\bin>slon -addengine Slony-I C:\Program
Files\PostgreSQL\8.4\slony\master.conf
pgsql\bin>slon -addengine Slony-I C:\Program Files\PostgreSQL\8.4\slony\slave.conf
pgsql\bin>slon -listengines Slony-I----------when i execute this i get0 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
