Re: BUG #13733: ~/.psql_history* corrupted

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: news(at)emmanuelsambo(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13733: ~/.psql_history* corrupted
Date: 2015-10-26 16:08:49
Message-ID: 28958.1445875729@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

news(at)emmanuelsambo(dot)com writes:
> The following bug has been logged on the website:
> Bug reference: 13733
> Logged by: Emmanuel Sambo
> Email address: news(at)emmanuelsambo(dot)com
> PostgreSQL version: 9.4.5
> Operating system: Apple Mac OS X El Capitan 10.11.1
> Description:

> Upgrading from PostgreSQL 9.4.4 to 9.4.5 deleted my entire psql history in
> two of my ~/.psql_history-<db>
> Looking at this file I can see:
> - all the spaces are encoded as utf-8: "\040"
> - each history entry is truncated at 1021 characters

This probably means you accidentally switched from using libedit to
libreadline, or vice versa, when you rebuilt Postgres. They're not
very compatible as to history file format :-(

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2015-10-26 16:20:05 Re: BUG #13723: "duplicate key" error occurs when update delete and insert the same row concurrently
Previous Message news 2015-10-26 15:22:14 BUG #13733: ~/.psql_history* corrupted