tag:blogger.com,1999:blog-5541296000399974369.post8699275971626322314..comments2024-03-09T02:51:27.612-05:00Comments on Peter Eisentraut's Blog: Squeeze + PostgreSQL = BrokenAnonymoushttp://www.blogger.com/profile/02849480732923051923noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-5541296000399974369.post-10963633053753154042012-04-20T14:38:45.686-04:002012-04-20T14:38:45.686-04:00You need postgresql-client-common >=114, so squ...You need postgresql-client-common >=114, so squeeze-backports is OK.Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-62876813450381161032012-04-20T14:03:06.265-04:002012-04-20T14:03:06.265-04:00Thanks for your answer! Is the package in debian b...Thanks for your answer! Is the package in debian backports ok? Sorry, I am just occasionally exposed to the combination of debian + postgres and stumbled across this a little bit too late... thanks again for your attention!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-7889657527417514662012-04-19T00:15:08.787-04:002012-04-19T00:15:08.787-04:00Squeeze is still broken, yes. Also, in wheezy, re...Squeeze is still broken, yes. Also, in wheezy, readline is loaded via LD_PRELOAD if available, but users could still be affected. Arguably, there mere fact that libedit still exists is a bug.Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-45654071357123521772012-04-18T10:14:33.388-04:002012-04-18T10:14:33.388-04:00Hi, is this still an issue in 2012-04 or did they ...Hi, is this still an issue in 2012-04 or did they fix the package? If not, do I have to use another package and which one is the best? Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-83936403406875525172011-04-12T08:37:19.275-04:002011-04-12T08:37:19.275-04:00The linking issue with openssl has got to be one o...The linking issue with openssl has got to be one of the stupidest things I've seen them do. Right after the whole iceweasel and icedove debauchery that forced everybody into using google chrome for an updated browser. I think last time I checked there are between 400-500 packages built against libssl in debian main. The thing they have an issue with is simply sticking a link to openssl in the description for binaries built against libssl. For whatever reason I guess its 'bad' to have a one line link to openssl like all those other packages have. I think the maintainer should be thrown out of maintaining postgres.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-41253488975814884162011-02-14T03:53:01.244-05:002011-02-14T03:53:01.244-05:00latest postgresql-common in debian/sid works aroun...latest postgresql-common in debian/sid works around the issue !Jérémy Lalhttps://www.blogger.com/profile/00456581836681956691noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-91164286631221631372011-02-11T13:53:19.328-05:002011-02-11T13:53:19.328-05:00Writing a _RANT_ to
mpitt@debian.org the person ...Writing a _RANT_ to <br /><br />mpitt@debian.org the person that thought that building against libedit, with out fixing the resulting bugs was a fix to classic debian licencing madness. <br /><br />Copied to viiru@debian.org the person that thought that the licencing issue was a _SERIOUS_ bug vs the package not working.Ronald Duncanhttp://www.uk-plc.netnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-30150623074524110072011-02-09T13:07:59.281-05:002011-02-09T13:07:59.281-05:00Please ignore the trolls. I am anxiously waiting f...Please ignore the trolls. I am anxiously waiting for postgresql 9 to hit squeeze-backports. Hope this is an easy fix, and thanks to the OP for bringing this problem up!jimcooncathttp://jimcooncat.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-51321583424264284412011-02-07T21:20:40.016-05:002011-02-07T21:20:40.016-05:00Wasn't the iceweasel problem caused by Debian ...Wasn't the iceweasel problem caused by Debian doing it's usual overzealous patch-the-crap-out-of-upstream-projects? That's a debian problem, not a firefox problem.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-28244672800413358422011-02-07T18:30:25.410-05:002011-02-07T18:30:25.410-05:00@Andreas, yes it's far from ideal. However it...@Andreas, yes it's far from ideal. However it would be _illegal_ to ship it otherwise. "Things getting worse in Debian", no, Debian has always cared about ensuring that the law is followed.<br /><br />Perhaps "people not understanding is getting worse" would have been more accurate. Yes, I get fed up with Debian getting blame when they point out genuine problems (e.g. iceweasel/firefox, KDE/Qt/GPL, etc)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-34143352446846556142011-02-07T09:48:09.181-05:002011-02-07T09:48:09.181-05:00i hold 9.0.1 client.
but you can ignore the psql-h...i hold 9.0.1 client.<br />but you can ignore the psql-history with "-n" and use rlwrap instead (without tab-completion).<br />http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=607109#15Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-86427012290865592462011-02-07T02:20:27.571-05:002011-02-07T02:20:27.571-05:00A little tip i discovered in http://bugs.debian.or...A little tip i discovered in http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=601754:<br /><br />libedit can be bypassed by launching psql this way<br />LD_PRELOAD=/lib/libreadline.so.6 psqlTorben Nielsennoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-73234959310299523472011-02-06T19:53:45.965-05:002011-02-06T19:53:45.965-05:00We're not even to the bottom yet of all the bu...We're not even to the bottom yet of all the bugs that the license change introduced by http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=603599 has added. On top of the two Peter linked to there's also http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=607907<br /><br />As of two days ago we are already building custom debs for angry clients on Squeeze to put readline back again; there's instructions at the bottom of the report for #607907 for one work-around, linking to it while disabling SSL support.<br /><br />Unfortunately, I think that working out all the issues with libedit may actually be the right long-term move here, given the license issues. That's what we had to do at...uh, somewhere I shouldn't talk about. Let's just say that commercial forks of the PostgreSQL code have been facing this problem for a while now, and the easiest way out can be switching to libedit.Greg Smithhttps://www.blogger.com/profile/16149991742662655368noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-40327254260849033122011-02-06T19:20:28.745-05:002011-02-06T19:20:28.745-05:00Seems like this is a nasty interfacing ideological...Seems like this is a nasty interfacing ideological bug:<br /><br />http://people.gnome.org/~markmc/openssl-and-the-gpl.html<br />http://lists.debian.org/debian-legal/2002/10/msg00113.html<br /><br />Maybe libssl can be replaced by GNU TLS:<br />http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=501145#10Unknownhttps://www.blogger.com/profile/16909319197911664485noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-19498926519961288042011-02-06T18:44:19.880-05:002011-02-06T18:44:19.880-05:00So Debian solved a license issue by actually intro...So Debian solved a license issue by actually introducing a bug?<br />Things are getting worse in Debian.Andreasnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-51300457887808732762011-02-06T18:17:17.035-05:002011-02-06T18:17:17.035-05:00Um, no, trying the latest libedit release 0:35:0 w...Um, no, trying the latest libedit release 0:35:0 with configure option <i>--enable-widec</i> leads to the behavior Peter observed. If you omit that option (which Apple does for example), it produces broken characters on non-ASCII input.Bernd Helmlehttps://www.blogger.com/profile/13495746192718528535noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-87326756414778715762011-02-06T17:49:06.131-05:002011-02-06T17:49:06.131-05:00Under OSX it accepts UTF-8 characters, but produce...Under OSX it accepts UTF-8 characters, but produces very weird characters, send to the backend:<br /><br />bernd@localhost:bernd #= CREATE TABLE äöü(id int);<br />CREATE TABLE<br />Time: 147,188 ms<br />bernd@localhost:bernd #= \d<br /> List of relations<br /> Schema | Name | Type | Owner <br />--------+------+-------+-------<br /> public | | table | bernd<br />(1 row)<br /><br />bernd@localhost:bernd #= ^D\q<br /><br />Not sure, but it seems there's is a generic problem here. <br /><br />Ah...looking at their <a href="http://www.thrysoee.dk/editline/" rel="nofollow">homepage</a>, the latest upstream release seems to work with UTF-8, according to the changelog. Seems to be worth trying.Bernd Helmlehttps://www.blogger.com/profile/13495746192718528535noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-30387182996761344092011-02-06T17:24:14.522-05:002011-02-06T17:24:14.522-05:00Seems that it was this change to the debian packag...Seems that it was this change to the debian package that is to blame:<br />postgresql-8.4 (8.4.5-2) unstable; urgency=low<br /><br /> * debian/control: Build against libedit instead of libreadline. We can't<br /> simultaneously link against readline (GPL) and libssl (incompatible with<br /> GPL). (Closes: #603598)<br /><br /> -- Martin Pitt Wed, 17 Nov 2010 18:02:46 +0100Torben Nielsennoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-88471392440892117562011-02-06T17:03:59.318-05:002011-02-06T17:03:59.318-05:00Wow, nice. Or, actually, not very. Do you know *wh...Wow, nice. Or, actually, not very. Do you know *why* they'd switch to libedit? I thought readline worked perfectly fine, and it's not like debian has something against GPL style licenses...<br /><br />In general it seems their quality control certainly leaves some wanting...Magnus Haganderhttps://www.blogger.com/profile/00190230225365745225noreply@blogger.com