Subject: Re: .psql_history": No such file
From: ivan marchesini <marchesini@unipg.it>
Reply-To: marchesini@unipg.it
To: Shane Ambler <pgsql@Sheeky.Biz>
Cc: Guillaume Lelarge <guillaume@lelarge.info>,
	pgsql-sql@postgresql.org
In-Reply-To: <4A463C15.8010309@Sheeky.Biz>
References: <1246031595.4836.27.camel@ivangeo>
	<200906261814.59148.guillaume@lelarge.info>
	<4A463C15.8010309@Sheeky.Biz>
Content-Type: text/plain; charset="UTF-8"
Organization: University of Perugia
Date: Mon, 29 Jun 2009 09:47:25 +0200
Message-Id: <1246261645.4803.46.camel@ivangeo>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit

Thanks to all...
in effect it is a very little problem if you consider that probably I
will call psql from normal accounts...

:-)

thanks


Il giorno dom, 28/06/2009 alle 01.04 +0930, Shane Ambler ha scritto:
> Guillaume Lelarge wrote:
> > Hi Ivan,
> > 
> > Le vendredi 26 juin 2009 à 17:53:15, ivan marchesini a écrit :
> >> [...]
> >> 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 is 
> > /var/lib/postgres. Probably better to use HISTFILE to change it (\set HISTFILE 
> > '/path/to/histfile').
> > 
> > Regards.
> > 
> > 
> You do know that you don't need to su postgres to start psql?
> 
> Only the server needs to be run with the postgres user account. If you 
> run psql from your normal user account the history file will be saved 
> into your home folder not the postgresql install/data file dir.
> 
> 
> -- 
> 
> Shane Ambler
> pgSQL (at) Sheeky (dot) Biz
> 
>