Skip to content

Lots of changes at

Over the last few weeks, I spent some time to shuffle the PostgreSQL YUM repo a bit, before 9.6 is released. With the help of Magnus, we also made some changes on the server side, so I will summarize all changes in this post:

- Direct downloads from are now redirected to All RPMs are already being served from over the last year, so it is the time to redirect it. Please change your scripts to use .

- Starting Sep 25th, started speaking https. I updated all repo packages to point to the new URL for GPG checks. Website will be HTTPS only in near future. Please update repo RPMs!

- Starting Sep 25th, we started keeping only last n-2 minor releases in the repo. This means, when there is new release available, we will delete n-3th one. This is a policy to keep the repo clean. This does not apply for PostgreSQL major releases.

* We started serving delta RPMs for all distros except RHEL 5. This will save great bandwidth.

Please let us know if you have more questions, via mailing list:


PostgreSQL is dropping native Windows port, use RPMs.

Important stuff is going on in IT industry nowadays.

Given that Microsot is merging bash shell into Windows, PostgreSQL is considering to drop native Windows port.

Core Team member Josh Berkus sent an email to PostgreSQL hackers mailing list the other day, and proposed dropping the Windows port.

Unsurprisingly, he got great support from Tom Lane. Tom wrote a response. Here is a quote from his email:

"Really? Good. I just committed my very last Windows-related fix, then. Somebody else can deal with it."

There are some unofficial reports about Tom that he opened up a champagne bottle right after this email, but I cannot disclosure my source.

Josh was also backed up by Joe Conway, who authors the famous PL/R extension:

"I would surely love to dump Windows support in PL/R as it is a major league PITA. It is probably an understatement to say that over the last 10+ years, 95+% of the time I have spent maintaining and supporting PL/R has been directly attributable to the Windows port."

However, users from the field acted promptly, looking for alternatives to run PostgreSQL on Windows.

After discussing with other team members, we, as the PostgreSQL YUM repo developers, decided to add Windows support to our RPMs. We contacted Microsoft, and Microsoft kindly provided us a tech preview of the bash environment. After some hacks, here are the results:

$ rpm -ivh postgresql95-libs-9.5.7-1PGDG.Windows2017.x86_64.rpm

command works as expected.

Please stay tuned, until we release all the remaining RPMs for Windows.

9.6, or 10.0?

Even though PostgreSQL 9.5 was released not too long ago, we are almost getting closer towards the feature freeze for 9.6.

When Windows support and PITR capabilities were added to 7.5, the community decided to change the major version to 8.0, as it represents a significant changes at those times. Similar thing happened at 8.5 development cycle: We now had in core replication, and it was released as 9.0.

Now, as 9.6 is coming closer, I seriously think that we should release 10.0, not 9.6 (I've been ranting about this on my Twitter account for a while). Following the commit of Parallel sequential scan , subsequent commits for:

- Parallel Joins
- Parallel Aggregation

increased parallelism features.

Another big infrastructure change is Tom's patch on "Making the upper part of the planner work by generating and comparing Paths."

Apart from these, following the commit that changes the VM file format, another commit titled
Don't vacuum all-frozen pages will help us to deploy PostgreSQL in some environments that we could not do before, I think.

To keep it short, I think that these infrastructural changes should result in a .0 release, as we did before.

What do you think?

Installing and running PostgreSQL 9.5 using RPMs on RHEL/CentOS/Scientific Linux/Oracle Linux and Fedora

PostgreSQL 9.5 was released recently. We released PostgreSQL 9.5 RPMs at the same day.

In this blog post, I am going to write you how to install PostgreSQL 9.5 on RHEL/CentOS/Scientific Linux/Oracle Linux 6 and 7 , Fedora 22 and 23. Continue reading "Installing and running PostgreSQL 9.5 using RPMs on RHEL/CentOS/Scientific Linux/Oracle Linux and Fedora"

PostgreSQL YUM repo receives largest update set, ever.

Today, the PostgreSQL Global Development Group announced new minor releases for all supported version: 9.5.1, 9.4.6, 9.3.11, 9.2.15 and 9.1.20. As usual, RPMs are out, too:

Since the last set of updates, I have been working hard with other members in the community for shuffling the repo a bit, towards an aim for better and easier maintenance.

Below is the list of today's update set. They all include the latest versions of each software as of today:


Please let us know if you encounter any issues with the packaging.


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 for details.

See you in Istanbul!

Conference website:

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


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.