X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8EDB73A478F for ; Wed, 1 Dec 2004 15:38:46 +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 56390-02 for ; Wed, 1 Dec 2004 15:38:32 +0000 (GMT) Received: from happygiraffe.net (happygiraffe.net [81.6.215.59]) by svr1.postgresql.org (Postfix) with ESMTP id 1B7283A461A for ; Wed, 1 Dec 2004 15:38:35 +0000 (GMT) Received: from localhost (localhost.happygiraffe.net [127.0.0.1]) by happygiraffe.net (Postfix) with ESMTP id 66F1ABB23; Wed, 1 Dec 2004 15:38:30 +0000 (GMT) Received: from happygiraffe.net ([127.0.0.1]) by localhost (ppe.happygiraffe.net [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 80332-03; Wed, 1 Dec 2004 15:38:30 +0000 (GMT) Received: by happygiraffe.net (Postfix, from userid 1001) id 0933CBB12; Wed, 1 Dec 2004 15:38:29 +0000 (GMT) Date: Wed, 1 Dec 2004 15:38:29 +0000 To: "Pradeepkumar, Pyatalo (IE10)" Cc: pgsql-admin@postgresql.org Subject: Re: PSQL History not working Message-ID: <20041201153829.GA80624@ppe.happygiraffe.net> References: <77ED2BF75D59D1439F90412CC5B109741555D6BC@ie10-sahara.hiso.honeywell.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <77ED2BF75D59D1439F90412CC5B109741555D6BC@ie10-sahara.hiso.honeywell.com> User-Agent: Mutt/1.5.6i From: dom@happygiraffe.net (Dominic Mitchell) X-Virus-Scanned: by amavisd-new at happygiraffe.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/16 X-Sequence-Number: 15602 On Wed, Dec 01, 2004 at 06:25:47AM -0700, Pradeepkumar, Pyatalo (IE10) wrote: > I am using Postgresql 7.4.3. Everythings working fine except for the psql > history. I did go through the documentation, but did not get much > information about it. The psql doesn't remember the previous commands. There > is no .psql_history file under the $HOME/ and there is no .psqlrc file also. > Its real pain to retype the same command all the time. > > Could anyone help me in configuring the .psql_history file. It sounds like your version of postgres was built without readline support. I see this output on my FreeBSD box: % psql -V psql (PostgreSQL) 7.4.6 contains support for command-line editing Unless your output contains that, you'll probably have to rebuild PostgreSQL. If you don't want to rebuild PostgreSQL, you might want to look at something like rlwrap[1] which will do the same sort of thing. -Dom [1] http://utopia.knoware.nl/~hlub/uck/rlwrap/