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 > > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
