--001485e7c9fc5504b1047f515b0a
Content-Type: text/plain; charset=ISO-8859-1
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
--001485e7c9fc5504b1047f515b0a
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<div class=3D"gmail_quote"><br>Hi,<br><br>I am struck with a problm could a=
nyone help me out here plz..<br><br>I have a problem while replicating my d=
atabase 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 ..<br>As i have foll=
owed the below steps , Plz do chk whatz wrong below:<br><ul><li>I 've s=
tarted with<span style=3D"font-size: 12pt; font-family: "Times New Rom=
an";"> Installation of PostgreSQL 8.4 and run Application
Stack Builder to add Replication : Slony-I support. </span></li><li><span s=
tyle=3D"font-size: 12pt; font-family: "Times New Roman";">Start p=
gAdmin III,=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A 0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 File -> Options, setup the Slony=
-I Path=A0 </span><span style=3D"font-size: 12pt; font-family: "Times =
New Roman";">C:\Program Files\PostgreSQL\8.4\share </span><span style=
=3D"font-size: 12pt; font-family: "Times New Roman";">, </span>Bu=
t the problem still persists with<span style=3D"font-size: 12pt; font-famil=
y: "Times New Roman";"> same error(</span>"Slony-I creation =
scripts not available; only joining
possible"<span style=3D"font-size: 12pt; font-family: "Times New =
Roman";">).</span></li><li><span style=3D"font-size: 12pt; font-family=
: "Times New Roman";">set the eventlog</span><span style=3D"font-=
size: 12pt; font-family: "Times New Roman";">=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0 pgsql\lib>regsvr32 slevent.dll</span></li>
</ul>---register the service<ul><li>pgsql\bin>slon -regservice Slony-I</=
li><li><span style=3D"font-size: 12pt; font-family: "Times New Roman&q=
uot;;">pgsql\bin>slon -addengine Slony-I C:\Program
Files\PostgreSQL\8.4\<a href=3D"http://developer.pgadmin.org/%7Ehiroshi/Slo=
ny-I/master.conf" target=3D"_blank">master.conf</a><div style=3D"display: i=
nline; padding-right: 16px; width: 16px; min-height: 16px;">=A0</div>
<br>
pgsql\bin>slon -addengine Slony-I C:\Program Files\PostgreSQL\8.4\<a hre=
f=3D"http://developer.pgadmin.org/%7Ehiroshi/Slony-I/slave.c onf" target=3D"=
_blank">slave.conf</a><div style=3D"display: inline; padding-right: 16px; w=
idth: 16px; min-height: 16px;">
=A0</div></span></li></ul><span style=3D"font-size: 12pt; font-family: &quo=
t;Times New Roman";">later tried replacing the slony installation dire=
ctory<br>
</span><ul><li><span style=3D"font-size: 12pt; font-family: "Times New=
Roman";">pgsql\bin>slon -addengine Slony-I C:\Program
Files\PostgreSQL\8.4\slony\<a href=3D"http://developer.pgadmin.org/%7Ehiros=
hi/Slony-I/master.conf" target=3D"_blank">master.conf</a><div style=3D"disp=
lay: inline; padding-right: 16px; width: 16px; min-height: 16px;">
=A0</div></span><br><span style=3D"font-size: 12pt; font-family: "Time=
s New Roman";">
pgsql\bin>slon -addengine Slony-I C:\Program Files\PostgreSQL\8.4\slony\=
<a href=3D"http://developer.pgadmin.org/%7Ehiroshi/Slony-I/slave.conf" targ=
et=3D"_blank">slave.conf</a><div style=3D"display: inline; padding-right: 1=
6px; width: 16px; min-height: 16px;">
=A0</div></span><br><span style=3D"font-size: 12pt; font-family: "Time=
s New Roman";">
pgsql\bin>slon -listengines Slony-I----------</span>when i execute this =
i get<pre><font style=3D"font-family: arial,helvetica,sans-serif;" size=3D"=
2"> 0 </font><font style=3D"font-family: arial,helvetica,sans-serif;" size=
=3D"2">engine(s) registered for service 'Slony-I'</font><br>
</pre>any solution for this ? plz do help me..As i am also trying to sortou=
t using sysinternals procmon to trouble shoot it.</li></ul>
<br>Thanks and Regards,<br><font color=3D"#888888"><font color=3D"#888888">=
Reshma</font>
</font></div><br>
--001485e7c9fc5504b1047f515b0a--
