Freitag, 7. Oktober 2011

Schedule for PGConf.DE released

The session schedule for PGConf.DE, the German-speaking PostgreSQL Conference, was published. The conference will be hold November 11th in Oberhausen, Germany, in front of the OpenRheinRhur, a conference focused on free software.

If you haven't heard about PGConf.DE, it is the German-speaking continuation of the very successful PostgreSQL Conference Europe held in Stuttgart last year. There are many great talks about various topics (replication, performance and optimization, development and much more). The conference let you get in touch with developers and users, exchanging experiences about PostgreSQL and creating contacts to various members of the community.

Registration is open already and the entrance fee also includes access to the OpenRheinRhur conference for the whole weekend. See you there!

Donnerstag, 21. April 2011

Yes, there is one (at least)...

Yesterday it occured to me again, that i was asked for german literature about PostgreSQL 9.0 and the lack thereof. Okay, there is one...look for ISBN-13 978-3897216617 ;)

PostgreSQL Administration 2nd Edition is available since the very early days of 2011 and covers various topics about PostgreSQL 9.0 Administration, in addition to the first edition which covers up to 8.3 only. Seems people got confused about this.

A quick check also gives some other german book about this topic, look for ISBN-13 978-3942151061. If you have additional tips, feel free to leave a comment here.

Donnerstag, 3. Februar 2011

FOSDEM, the same procedure as every year

I'm going to FOSDEM, the Free and Open Source Software Developers' European Meeting

So FOSDEM starts this weekend again...and again i will attend, especially on sunday. Meet the PostgreSQL guys, hear the talks in the PostgreSQL devroom and maybe get some other interesting news from the community.
See you there!

Freitag, 21. Januar 2011

PostgreSQL vs. libreadline on OSX

Today Thom Brown posted a bug report to pgsql-bugs, where he asked for a potential issue with the interactive terminal psql. As the following reply from Tom Lane explained, this is a long standing issue with the libedit package Apple ships with OSX. Yes, libedit, since libreadline under OSX is just a symlink to libedit:


% ls -la /usr/lib/libreadline.dylib
lrwxr-xr-x 1 root wheel 15 15 Sep 2009 /usr/lib/libreadline.dylib@ -> libedit.2.dylib


If you just configure your PostgreSQL build without any special options, the PostgreSQL binaries will be linked against libedit.
There were several discussions about this in the past and this was even reported to Apple. However, since now (i'm on OSX 10.6.6 for example), nothing happened and the shipped libedit is still unusable with psql.

If you really need to build your own PostgreSQL binaries on OSX (for example you want do a review for a patch in the current CommitFest ;)), i always recommend to use MacPorts and their packaging. I use it for nearly two years and it works quite well (well, at least all libraries required by my installation are working). There's a fairly good instruction on how to setup MacPorts on your MacBook. If you have done your package installation, simply point the configure script to the correct location of the libraries and header files:


./configure --with-libraries=/opt/local/lib --with-includes=/opt/local/include ...


/opt/local is the default location for libraries installed from MacPorts. You also might want to specify additional options. At least, --with-includes and --with-libraries are necessary to point your PostgreSQL builds to the correct libraries.