Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id F086A633547 for ; Fri, 26 Jun 2009 12:32:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 71890-07 for ; Fri, 26 Jun 2009 12:32:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from trabant.cianoz.org (host31-194-149-62.serverdedicati.aruba.it [62.149.194.31]) by mail.postgresql.org (Postfix) with ESMTP id AB2156331B6 for ; Fri, 26 Jun 2009 12:32:39 -0300 (ADT) Received: from [192.168.100.8] (mfalcon.irpi.cnr.it [194.119.218.2]) by trabant.cianoz.org (Postfix) with ESMTP id 3A5EC50D16; Fri, 26 Jun 2009 17:32:37 +0200 (CEST) Subject: .psql_history": No such file From: ivan marchesini Reply-To: marchesini@unipg.it To: pgsql-sql@postgresql.org Content-Type: text/plain Organization: University of Perugia Date: Fri, 26 Jun 2009 17:53:15 +0200 Message-Id: <1246031595.4836.27.camel@ivangeo> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200906/107 X-Sequence-Number: 32712 Dear users, I have installed a postgres db using a datadir different from /var/lib/pgsql/.psql_history. then: su postgres psql postgres All went fine but when I exit from psql from a db I obtain: _______ could not save history to file "/var/lib/pgsql/.psql_history": No such file or directory _______ how can I fix this problem? where can I say psql that it must write .psql_history into the datadir? many thanks... ivan