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

From: "E(dot) Sambo" <news(at)emmanuelsambo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13733: ~/.psql_history* corrupted
Date: 2015-10-28 14:43:22
Message-ID: CAF+rkrags3OOiOEsBanZES3Ot2iDdYQ_abAwgb0pysFeYcC7UQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I figured it out. The homebrew 9.4.5 El Capitan bottle is bad because of
Xcode. I documented it in https://github.com/Homebrew/homebrew/issues/45405

On Mon, Oct 26, 2015 at 11:08 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-10-28 14:57:34 Re: BUG #13742: postgres deletes needed files in pg_clog
Previous Message roland.otta 2015-10-28 07:00:30 BUG #13742: postgres deletes needed files in pg_clog