Обсуждение: 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. 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.
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. 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.
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. 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.