Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 8942B1337BCE for ; Tue, 22 Mar 2011 01:16:37 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 00955-02 for ; Tue, 22 Mar 2011 04:16:27 +0000 (UTC) X-Greylist: delayed 00:19:57.036412 by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id D89381337B9C for ; Tue, 22 Mar 2011 01:16:26 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.69) (envelope-from ) id 1Q1shn-0001p5-IS for pgsql-admin@postgresql.org; Mon, 21 Mar 2011 20:56:27 -0700 Date: Mon, 21 Mar 2011 20:56:27 -0700 (PDT) From: Bill Teluk To: pgsql-admin@postgresql.org Message-ID: <1300766187565-4248901.post@n5.nabble.com> In-Reply-To: <54E5385D47A89542BC678F5426799F3904EED3A788@OSTIEX01.osti.gov> References: <54E5385D47A89542BC678F5426799F3904EED3A788@OSTIEX01.osti.gov> Subject: Re: psql causing a error MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.778 tagged_above=-10 required=5 tests=BAYES_00=-1.9, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201103/216 X-Sequence-Number: 37088 Hi Raghu and thanks!, This fix helped me too. My installation is an OpenSCG PostgreSQL 9.0.3 build with PostGIS 1.5.2 installed; and as per Sandra - the installation worked fine for several days then failed - I got mine going again the first time by multiple restarts and some port config changes, but the second time I looked further and found this post. Each time I had a failure on mine, it was triggered by loading an SQL script via "psql -f" generated by the shp2pgsql utility that ships with PostGIS v1.5.2 - the script looked fine to me though (and deleting the tables generated by it failed to restore operation.) Also, pgAdmin (v1.12.2) seemed to work OK where psql wouldn't. Regards, Bill. -- View this message in context: http://postgresql.1045698.n5.nabble.com/psql-causing-a-error-tp3410159p4248901.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.