Replication on windows - PgAdmin

Поиск
Список
Период
Сортировка
От reshma parveen
Тема Replication on windows - PgAdmin
Дата
Msg-id dc83ca281002110321r6fa7f1c3sb87e26066394c8@mail.gmail.com
обсуждение исходный текст
Список 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
     

    pgsql\bin>slon -addengine Slony-I C:\Program Files\PostgreSQL\8.4\slave.conf
     
later tried replacing the slony installation directory
  • 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 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Iñigo Martinez Lasala
Дата:
Сообщение: Re: Disabling triggers with psql (gforge 7.4 to 8.2 migration)
Следующее
От: Luis Dominguez
Дата:
Сообщение: REF : MIgracion de datos ms sql server 7.0 a Postgresql 8.4 en Linux