Skip to content

Please join us for testing 9.6!

PostgreSQL 9.6 is coming with some great features, and one of them is parallelism. Robert Haas committed a series of commits about it, and recently he added support for both parallel sequential scan and parallel joins:

To help people test all of upcoming features, I will push regularly updated RPMs for the following platforms to the PostgreSQL YUM repository:

- RHEL/CentOS/Scientific Linux/Oracle Enterprise Linux 6 and 7
- Fedora 23 and 22

Please note that these packages are built using the official daily tarball. The package name contains the date that the package is built on.

More information can be found here.

These packages are for crash testing only, never ever intended for production or even beta or alpha usage.

Please report any PostgreSQL bugs to pgsql-bugs(at)PostgreSQL(dot)org

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!