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
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 email@example.com for details.
See you in Istanbul!
Conference website: http://pgday.postgresql.org.tr/en/
PostgreSQL 9.4 will finally support huge pages
. This article will cover about configuring huge pages on RHEL 7 box.
Continue reading "Using huge pages on RHEL 7 and PostgreSQL 9.4"
In the 3rd post of "PostgreSQL on RHEL7 series, I will mention about running more than one 9.4 instance on RHEL 7. This article is also valid for 9.3.
Continue reading "Running more than one 9.4 /9.3 instance in parallel 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"
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 firstname.lastname@example.org.
Recently, there is some demand in supporting Oracle Enterprise Linux in the PostgreSQL RPM repository
Finally I found time to create repository RPMs for Oracle Linux. We support all active PostgreSQL releases (9.3 to 8.4).
Announcement page is here
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.
Here is the slides of my presentation at PostgreSQL Europe 2013 this year: Useful PostgreSQL Extensions.
Hope you'll find it useful
9.3.0 was just announced
. Please download, install and use it!
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.
I will be attending PostgreSQL Conference Europe 2012. It will be a gret pleasure to see folks from the community.
Anyway, here are my picks for the conference:
Continue reading "My picks for pgconf.eu 2012"
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!
I thought this is pretty straightforward, but I decided to write this post after getting a few emails recently.
Continue reading "How to install PostgreSQL 9.2 on RHEL/CentOS/Scientific Linux 5 and 6"