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
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) |