Replication on windows - PgAdmin

From: reshma parveen <reshma454(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Replication on windows - PgAdmin
Date: 2010-02-11 11:21:28
Message-ID: dc83ca281002110321r6fa7f1c3sb87e26066394c8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Luis Dominguez 2010-02-11 12:58:46 REF : MIgracion de datos ms sql server 7.0 a Postgresql 8.4 en Linux
Previous Message Iñigo Martinez Lasala 2010-02-11 09:17:22 Re: Disabling triggers with psql (gforge 7.4 to 8.2 migration)