From: Shane Ambler <pgsql@Sheeky.Biz>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgsql-sql@postgresql.org
Cc: marchesini@unipg.it
Subject: Re: .psql_history": No such file
Date: Sun, 28 Jun 2009 01:04:45 +0930
Message-ID: <4A463C15.8010309@Sheeky.Biz> (raw)
In-Reply-To: <200906261814.59148.guillaume@lelarge.info>
References: <1246031595.4836.27.camel@ivangeo>
<200906261814.59148.guillaume@lelarge.info>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgsql@Sheeky.Biz, guillaume@lelarge.info, marchesini@unipg.it
Subject: Re: .psql_history": No such file
In-Reply-To: <4A463C15.8010309@Sheeky.Biz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox