From: reshma parveen <reshma454@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Replication on windows - PgAdmin
Date: Thu, 11 Feb 2010 16:51:28 +0530
Message-ID: <dc83ca281002110321r6fa7f1c3sb87e26066394c8@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: reshma454@gmail.com
Subject: Re: Replication on windows - PgAdmin
In-Reply-To: <dc83ca281002110321r6fa7f1c3sb87e26066394c8@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox