Re: bogus psql "could not save history file[...]" message in 9.3.6 - Mailing list pgsql-bugs

> On Mar 13, 2015, at 6:42 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> "David G. Johnston" <david.g.johnston@gmail.com> writes:
>> On Fri, Mar 13, 2015 at 6:13 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> Running ldd on the psql executable would be a good first step.
>=20
>> =E2=80=8Blibedit.so.2 =3D> /usr/lib/x86_64-linux-gnu/libedit.so.2 =
(0x00007f8b3af22000)
>=20
> Righto.  So now, what version of libedit have you got?  (On Red Hat
> "rpm -q libedit" would be the thing to do, but I have no idea about
> Ubuntu's package manager.)
>=20
>             regards, tom lane

This is from an empty 14.04 vagrant where I installed postgresql-9.3 =
from the apt.postgresql.org <http://apt.postgresql.org/> repo:

agrant@vagrant-ubuntu-trusty-64:/etc/apt/sources.list.d$ dpkg -S =
/usr/lib/x86_64-linux-gnu/libedit.so.2
libedit2:amd64: /usr/lib/x86_64-linux-gnu/libedit.so.2

vagrant@vagrant-ubuntu-trusty-64:/etc/apt/sources.list.d$ dpkg --list =
libedit2
Desired=3DUnknown/Install/Remove/Purge/Hold
| =
Status=3DNot/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-=
pend
|/ Err?=3D(none)/Reinst-required (Status,Err: uppercase=3Dbad)
||/ Name                                     Version                   =
Architecture              Description
=
+++-=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D-=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D-=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D-=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
ii  libedit2:amd64                           3.1-20130712-2            =
amd64                     BSD editline and history libraries

And it does the same thing:

vagrant@vagrant-ubuntu-trusty-64:/etc/apt/sources.list.d$ sudo su - =
postgres
postgres@vagrant-ubuntu-trusty-64:~$ psql
psql (9.3.6)
Type "help" for help.

postgres=3D# select 1;
 ?column?
----------
        1
(1 row)

postgres=3D# \q
could not save history to file "/var/lib/postgresql/.psql_history": No =
such file or directory

postgres@vagrant-ubuntu-trusty-64:~$ ls -l =
/var/lib/postgresql/.psql_history
-rw------- 1 postgres postgres 10 Mar 14 01:53 =
/var/lib/postgresql/.psql_history
postgres@vagrant-ubuntu-trusty-64:~$

postgres@vagrant-ubuntu-trusty-64:~$ cat .psql_history
select 1;