Thread: Data Not replicating

Data Not replicating

From
"Vishnu S."
Date:
Hi,


 I am using Slony-I for replicating a database.I have a  master database
and two slave databases in another server on the same host. I have done
all steps mentioned in
http://www.testdriveinteractive.com/files/Tutorial_All_PP_Slony_Replicat
ion.pdf, and started the Slony-I service. But the data is not
replicating in slave database tables. The master database server shows
the following log,


LOG:  unexpected EOF on client connection
ERROR:  schema "_testcluster" does not exist at character 30
STATEMENT:  select last_value::int4 from "_testcluster".sl_local_node_id
LOG:  could not receive data from client: No connection could be made
because the target machine actively refused it.

What is the wrong ?


Thanks and Regards,
Vishnu S

***** Confidentiality Statement/Disclaimer *****

This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential
information.Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended
recipient,please notify the sender immediately then delete it from all your systems, and do not copy, use or print.
Internetcommunications are not secure and it is the responsibility of the recipient to make sure that it is
virus/maliciouscode exempt. 
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you
requireany form of confirmation of the contents, please contact the company/sender. The company/sender is not liable
forany errors or omissions in the content of this message. 

Re: Data Not replicating

From
Devrim GÜNDÜZ
Date:
On Tue, 2010-10-05 at 10:19 +0530, Vishnu S. wrote:

> LOG:  unexpected EOF on client connection
> ERROR:  schema "_testcluster" does not exist at character 30

Did you run slonik_init_cluster?

--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Re: Data Not replicating

From
"Vishnu S."
Date:
Hi,

Yes. I have written a script file like the following.

include <preamble.sk>;
init cluster (id=1, comment='hostname=10.2.26.53 port=5432');




Thanks & Regards,
Vishnu S


-----Original Message-----
From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org] 
Sent: Tuesday, October 05, 2010 10:59 AM
To: Vishnu S.
Cc: pgsql-admin@postgresql.org; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Data Not replicating

On Tue, 2010-10-05 at 10:19 +0530, Vishnu S. wrote:

> LOG:  unexpected EOF on client connection
> ERROR:  schema "_testcluster" does not exist at character 30

Did you run slonik_init_cluster?

--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org  Twitter:
http://twitter.com/devrimgunduz
***** Confidentiality Statement/Disclaimer *****

This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential
information.Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended
recipient,please notify the sender immediately then delete it from all your systems, and do not copy, use or print.
Internetcommunications are not secure and it is the responsibility of the recipient to make sure that it is
virus/maliciouscode exempt.
 
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you
requireany form of confirmation of the contents, please contact the company/sender. The company/sender is not liable
forany errors or omissions in the content of this message.
 

Re: [ADMIN] Data Not replicating

From
Devrim GÜNDÜZ
Date:
On Tue, 2010-10-05 at 11:03 +0530, Vishnu S. wrote:
>
> Yes. I have written a script file like the following.
>
> include <preamble.sk>;
> init cluster (id=1, comment='hostname=10.2.26.53 port=5432');

It does not give me the $CLUSTER_NAME information.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Re: [ADMIN] Data Not replicating

From
"Vishnu S."
Date:
Hi,


The cluster name is defined in  the  preamble.sk file like,

cluster name=TestCLuster;
node 1 admin conninfo = 'service=MasterSlonik host=10.2.26.53 port=5432 user=postgres password=***** dbname=master11';
node 2 admin conninfo = 'service=SlaveSlonik1 host=10.2.26.54 port=5433 user=postgres password=***** dbname=slave11';




Thanks & Regards,
Vishnu S

-----Original Message-----
From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org] 
Sent: Tuesday, October 05, 2010 5:52 PM
To: Vishnu S.
Cc: pgsql-admin@postgresql.org; pgsql-general@postgresql.org
Subject: Re: [ADMIN] [GENERAL] Data Not replicating

On Tue, 2010-10-05 at 11:03 +0530, Vishnu S. wrote:
> 
> Yes. I have written a script file like the following.
> 
> include <preamble.sk>;
> init cluster (id=1, comment='hostname=10.2.26.53 port=5432');

It does not give me the $CLUSTER_NAME information.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org  Twitter:
http://twitter.com/devrimgunduz
***** Confidentiality Statement/Disclaimer *****

This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential
information.Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended
recipient,please notify the sender immediately then delete it from all your systems, and do not copy, use or print.
Internetcommunications are not secure and it is the responsibility of the recipient to make sure that it is
virus/maliciouscode exempt.
 
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you
requireany form of confirmation of the contents, please contact the company/sender. The company/sender is not liable
forany errors or omissions in the content of this message.