Received: from ip.eth.net (mail.ip.eth.net [202.9.128.18]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9TFrrP89874 for ; Mon, 29 Oct 2001 10:53:54 -0500 (EST) (envelope-from sharmad@goatelecom.com) Received: (apparently) from punweb01 ([10.1.1.14]) by ip.eth.net with Microsoft SMTPSVC(5.5.1877.467.46); Mon, 29 Oct 2001 21:23:52 +0530 From: sharmad@goatelecom.com Reply-to: sharmad@goatelecom.com To: pgsql-sql@postgresql.org Date: Mon, 29 Oct 2001 21:24:08 +0550 Subject: postgresql error X-Mailer: DMailWeb Web to Mail Gateway 2.7q, http://netwinsite.com/top_mail.htm Message-id: <3bdd7ba0.77a.0@punweb01> X-User-Info: 210.212.161.126 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/418 X-Sequence-Number: 5369 Is there anyway to increase the query time in postgresql because if the query is long and so is the database then the pgRead error occurs resulting in the break of connection with the database and recently also giving me problems in taking backups. If i m not wrong the command to take backup is pg_dump [database_name] > [file_name] Waiting for the reply, TIA -Sharmad