Skip site navigation (1) Skip section navigation (2)

Re: Replication using slony-I

From: Abdul Rahman <abr_ora(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: rod(at)iol(dot)ie, glynastill(at)yahoo(dot)co(dot)uk
Subject: Re: Replication using slony-I
Date: 2008-09-30 07:22:23
Message-ID: 728605.54166.qm@web65714.mail.ac4.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
Dear All,

I worked again from very start and faced the same problem which encountered earlier.  
In order to perform replication. I am following the steps present in 

http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html

and
successfully reached to step # 13. I have Slony-I pgAdmin-III included
in postgresql-8.2 and the platform is WindowsXp. But here I am not
getting the "NewSubscription" option when do right click on
Subscription Set.

--- On Tue, 9/30/08, Abdul Rahman <abr_ora(at)yahoo(dot)com> wrote:
From: Abdul Rahman <abr_ora(at)yahoo(dot)com>
Subject: Re: [GENERAL] Replication using slony-I
To: pgsql-general(at)postgresql(dot)org
Cc: rod(at)iol(dot)ie, glynastill(at)yahoo(dot)co(dot)uk
Date: Tuesday, September 30, 2008, 9:55 AM

Thanks a lot for replying!

Here is complete information for consideration:
In order to perform replication. I am following the steps present in 

http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html

and successfully reached to step # 13. I have Slony-I pgAdmin-III included in postgresql-8.2 and the platform is WindowsXp. But here I am not getting the "NewSubscription" option when do right click on Subscription Set.

I also worked and found that the command  in step # 4

>psql -U postgres slave1 < schema.sql

is not working because I am not getting the tables in either slave. So, I suppose I have to run the command in step # 2

> pgbench -i -U postgres master

for slave1 and slave2 instead of making sql script and running it. I am
 going to restart my work in this way. Glyn Astill you may explore slonik in detail that I may use it now. So many Thanks Again.



      


      

In response to

Responses

pgsql-general by date

Next:From: Denis GasparinDate: 2008-09-30 07:33:13
Subject: Free Cache Memory (Linux) and Postgresql
Previous:From: r_mustaDate: 2008-09-30 06:59:50
Subject: Re: Counting unique rows as an aggregate.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group