From: Guillaume Lelarge <guillaume@lelarge.info>
To: pgsql-sql@postgresql.org,
 marchesini@unipg.it
Subject: Re: .psql_history": No such file
Date: Fri, 26 Jun 2009 18:14:58 +0200
User-Agent: KMail/1.11.90 (Linux/2.6.28-13-generic; KDE/4.2.90; i686; ; )
References: <1246031595.4836.27.camel@ivangeo>
In-Reply-To: <1246031595.4836.27.camel@ivangeo>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Message-Id: <200906261814.59148.guillaume@lelarge.info>

Hi Ivan,

Le vendredi 26 juin 2009 =E0 17:53:15, ivan marchesini a =E9crit :
> [...]
> 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?
>

psql tries to write there because the home directory of the postgres user i=
s=20
/var/lib/postgres. Probably better to use HISTFILE to change it (\set HISTF=
ILE=20
'/path/to/histfile').

Regards.


=2D-=20
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com