Skip to content

Mark your calendars: May 9 2015, PGDay.TR in Istanbul!

Turkish PostgreSQL Users' and Developer's Association is organizing 4th PGDay.TR on May 9, 2015 at Istanbul. Dave Page, one of the community leaders, will be giving the keynote.

This year, we are going to have 1 full English track along with 2 Turkish tracks, so if you are close to Istanbul, please join us for a wonderful city, event and fun!

We are also looking for sponsors for this great event. Please email to sponsor@postgresql.org.tr for details.

See you in Istanbul!

Conference website: http://pgday.postgresql.org.tr/en/

Installing and configuring PostgreSQL 9.3 and 9.4 on RHEL 7

Red Hat Enterprise Linux 7 was released recently. The day after the release, we announced PostgreSQL 9.4 RPMs for RHEL 7, and last week we pushed PostgreSQL 9.3 RPMs for RHEL 7.

Since Red Hat switched to systemd as of RHEL 7, there are some changes in the packaging as compared to RHEL 5 and RHEL 6. So, how do you install and configura PostgreSQL on RHEL 7? Continue reading "Installing and configuring PostgreSQL 9.3 and 9.4 on RHEL 7"

PostgreSQL 9.4 beta1 out -- also the RPMs! Please test!

Last week, PostgreSQL beta 1 was announced. As noted there, there are lots of cool features in 9.4, which needs testing from you.


9.4 RPMs are also out, for sure!

If you are an RPM user, we would like you to test both 9.4 features with the RPMs. The Fedora 20 RPMs have a slight change in unit file: We removed PGPORT variable, which was one of the major complaints over the last few years, including the RHEL 5 and RHEL6 packages. Since RHEL 7 will switch to systemd, testing of Fedora 20 packages is crucial for us.

First, please download the repo package from here. After installing this package, please run

yum install postgresql94-server postgresql94-contrib


which will install the minimum 9.4 stuff for you. Please feel to report bugs to pgsql-bugs@postgresql.org.

Thanks!

FAQ: Why PostGIS 2.1 does not have extension and raster support in RHEL 5?

This is really a FAQ. I'll keep it short:

PostGIS developers decided not to build PostGIS support when raster support is not enabled. The GDAL version in RHEL 5 is not enough to build PostGIS 2.1 with raster support. That is the reason that you cannot create postgis as an extension on RHEL 5.

Either upgrade to RHEL 6, or build your own custom GDAL and etc. RPMs for RHEL 5.

pgRouting RPM package was sponsored, and it is now available!

A Norway Government Institution asked me to fix the pgRouting package for PostgreSQL 9.2 on RHEL 6. Their name is "Norsk institutt for skog og landska".

Packaging was not that easy, since they asked me to add "Traveling Salesperson functionality" and "Driving Distance functionality", which required gaul and CGAL packages respectively. CGAL is available in atrpms.net, but the gaul-devel required by TSP functionality required a custom slang, which is actually compat-slang, and because of the termcap changes in RHEL 6, I had to build a custom compat-slang package to build gaul-devel :-)

Anyway, packages are now available for PostgreSQL 9.2 on RHEL 6 x86_64 and RHEL 6 i686. I am also planning to push the package for 9.1 sometime this week. Fedora 17 packages will also be available in preparation for next year's RHEL 7!

Thanks "Norsk institutt for skog og landska" for contributing to community packaging.

Are you coming to Prague? I may need a favor from you!

Even if you haven't heard before: I'm a fan of Hard Rock Cafe. Some people claim that I am a bit obsessive about it, but that is a different story.

I am collecting goods from all the HRCs that I go -- t-shirts, pins, drum sticks (yes!), bracelets, etc. However, it is not possible (at least nowadays) to visit all HRCs...

...so, if you are coming to Prague for pgconf.eu, and if you live at a place close to your local HRC, I will ask you a pin, shot glasses, two t-shirts (one for my son, one for myself), and some other minor stuff. I don't have unlimited budget, so it will be perfect if you ping me before you go to HRC -- I can give you the details and the budget left.

Thanks! See you in Prague!

(Updated) Getting used to systemd: Installing and running PostgreSQL on Fedora 16+

Note: I updated this post based on a comment by Mikko Tiihonen. I did not remove his comment, so that you can see it)

Fedora has been using systemd, instead of SysV init scripts over the last 3 releases or so. Fedora 16 was the first release that really adopted their init scripts to systemd. There is still a long way to go there it seems, but that is not the topic of this blog post.

Credits first: Tom Lane did most of the work on the systemd changes, and I copied them to PGDG packags. All I did was adjusting them for PGDG layout.

...and a disclaimer: Currently, init-script related stuff is pretty much different between Fedora and PGDG packages -- as you can guess, Fedora packages are much better than PGDG ones, but I'll close the gap pretty soon.

So, this blog post summarizes what is available on Fedora 16 and 17. Continue reading "(Updated) Getting used to systemd: Installing and running PostgreSQL on Fedora 16+"