From: ivan marchesini <marchesini@unipg.it>
To: Shane Ambler <pgsql@Sheeky.Biz>
Cc: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgsql-sql@postgresql.org
Subject: Re: .psql_history": No such file
Date: Mon, 29 Jun 2009 09:47:25 +0200
Message-ID: <1246261645.4803.46.camel@ivangeo> (raw)
In-Reply-To: <4A463C15.8010309@Sheeky.Biz>
References: <1246031595.4836.27.camel@ivangeo>
<200906261814.59148.guillaume@lelarge.info>
<4A463C15.8010309@Sheeky.Biz>
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
>
>
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: marchesini@unipg.it, pgsql@Sheeky.Biz, guillaume@lelarge.info
Subject: Re: .psql_history": No such file
In-Reply-To: <1246261645.4803.46.camel@ivangeo>
* 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