Data Not replicating
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. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt.
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.
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
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. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt.
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.
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
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. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt.
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.