X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 738F43A95B3 for ; Tue, 21 Dec 2004 05:02:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05217-06 for ; Tue, 21 Dec 2004 05:02:14 +0000 (GMT) Received: from rediffmail.com (unknown [203.199.83.31]) by svr1.postgresql.org (Postfix) with SMTP id 84EC73A9DD4 for ; Tue, 21 Dec 2004 05:02:12 +0000 (GMT) Received: (qmail 26823 invoked by uid 510); 21 Dec 2004 05:02:56 -0000 Date: 21 Dec 2004 05:02:56 -0000 Message-ID: <20041221050256.26822.qmail@webmail46.rediffmail.com> Received: from unknown (61.95.202.163) by rediffmail.com via HTTP; 21 dec 2004 05:02:56 -0000 MIME-Version: 1.0 From: "Gurpreet Sachdeva" Reply-To: "Gurpreet Sachdeva" To: pgsql-performance@postgresql.org Subject: Postgres on Linux Cluster! Content-type: multipart/alternative; boundary="Next_1103605376---0-203.199.83.31-26817" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=4.259 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_IMAGE_ONLY_12, HTML_MESSAGE, IP_LINK_PLUS, MSGID_FROM_MTA_HEADER, NORMAL_HTTP_TO_IP X-Spam-Level: **** X-Archive-Number: 200412/256 X-Sequence-Number: 9631 This is a multipart mime message --Next_1103605376---0-203.199.83.31-26817 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I have recently transfered a big database on my master node of a 4 node ope= nSSI Cluster... The system is working fine but sometimes, I get following e= rrors:=0A=0Ahttp://192.168.1.100/cgi-bin/search.py=0A File "/usr/lib/pytho= n2.2/site-packages/pyPgSQL/PgSQL.py", line 3067, in execute, referer: http:= //192.168.1.100/cgi-bin/search.py=0A self.conn.conn.query('ROLLBACK WORK= '), referer: http://192.168.1.100/cgi-bin/search.py=0Alibpq.ProgrammingErro= r: no connection to the server, referer: http://192.168.1.100/cgi-bin/searc= h.py=0A, referer: http://192.168.1.100/cgi-bin/search.py=0A=0AThis error co= mes while insertion of data takes place...=0AIs Postgres successfull on Clu= ster??? Will that give me performance enhancement in any way??? Please help= ...=0A=0A-- =0AThanks and Regards,=0AGSS --Next_1103605376---0-203.199.83.31-26817 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

=0AI have recently transfered a big database on my master node of a 4 no= de openSSI Cluster... The system is working fine but sometimes, I get follo= wing errors:
=0A
=0Ahttp://192.168.1.100/cgi-bin/search.py
=0A&nbs= p; File "/usr/lib/python2.2/site-packages/pyPgSQL/PgSQL.py", line= 3067, in execute, referer: http://192.168.1.100/cgi-bin/search.py
=0A&n= bsp;   self.conn.conn.query('ROLLBACK WORK'), referer: http://192.168.= 1.100/cgi-bin/search.py
=0Alibpq.ProgrammingError: no connection to the = server, referer: http://192.168.1.100/cgi-bin/search.py
=0A, referer: ht= tp://192.168.1.100/cgi-bin/search.py
=0A
=0AThis error comes while in= sertion of data takes place...
=0AIs Postgres successfull on Cluster??? = Will that give me performance enhancement in any way??? Please help...
= =0A
=0A--
=0AThanks and Regards,
=0AGSS=0A

=0A

=0A= =0A --Next_1103605376---0-203.199.83.31-26817--