Thread: 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
Attachment
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
Attachment
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.