Re: Tom Lane 2019-01-29 <27653.1548774...@sss.pgh.pa.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