Re: pgsql: Build src/port files as a library with -fPIC, and use that in li

From: Christoph Berg <myon(at)debian(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgsql: Build src/port files as a library with -fPIC, and use that in li
Date: 2019-01-29 15:55:29
Message-ID: 20190129155528.GK9860@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Re: Tom Lane 2019-01-29 <27653(dot)1548774621(at)sss(dot)pgh(dot)pa(dot)us>
> > It took a while to notice, but this change does break 8.2's initdb if
> > libpq5 from PG12 is installed:
> > $ /usr/lib/postgresql/8.2/bin/initdb
> > /usr/lib/postgresql/8.2/bin/initdb: symbol lookup error: /usr/lib/postgresql/8.2/bin/initdb: undefined symbol: pqsignal
>
> Well, 8.2 is *very* long out of support, and there are plenty of
> nasty bugs you're at risk of if you keep using it. So I don't
> find this to be a good argument for contorting what we do in v12.

I try to keep the old versions alive on apt.pg.o for Debian unstable (only)
so I have something to grab when customers ask questions about the old
versions. We are probably lucky that 8.2 broke only now, and leaving
it broken is a fair thing. I was just mentioning for completeness, I
didn't mean to insist on fixing it.

> If you really want to keep using 8.2 (and even make new installations
> with it!?), you could back-patch the 8.3 patch that made sure that
> initdb didn't absorb pqsignal, pg_encoding_to_char, etc from libpq.
> It looks like what you'd need is a portion of the Makefile changes
> from 8468146b03c87f86162cee62e0de25f6e2d24b56.

I might give that a shot, but if it's too hard, dropping 8.2 "support"
is not a problem. Thanks for digging up the commit hash.

Christoph

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2019-01-29 20:49:03 pgsql: Refactor planner's header files.
Previous Message Tom Lane 2019-01-29 15:10:21 Re: pgsql: Build src/port files as a library with -fPIC, and use that in li

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-01-29 15:56:40 Re: Allowing extensions to supply operator-/function-specific info
Previous Message Christoph Berg 2019-01-29 15:46:06 Re: [PATCH] Log PostgreSQL version number on startup