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 email@example.com.
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"
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+"
Yesterday, Tom (Lane) committed 9.2.0 to Fedora rawhide, and even better, to Fedora 18.
RHEL 7 is said to be
based on Fedora 18 (also said here, too
), so apparently we skipped 9.1 there, and the shiny new PostgreSQL 9.2 will be on RHEL 7. With its better scalability, I'm sure that RHEL 7 will help us to gain more ground.
PostgreSQL 9.2 was released
a few hours before. This is mostly a performance release, and shows great improvement as compared to the previous releases.
...and for sure, I released RPMs for 9.2, too.
Click here to download the 9.2 repo RPMs
RPMs are currently available for:
- RHEL/CentOS/Scientific Linux 6 - 32-bit
- RHEL/CentOS/Scientific Linux 5 - 32-bit
- Fedora 17 - 32- bit
- Fedora 16 - 32- bit
I dropped RHEL 4 support as of 9.2, since it was also EOLed by Red Hat, too. There is a slight chance for Fedora 15 packages, but don't hold your breath. I'll push Fedora 18 packages, as soon as Fedora 18 is released.
I was at PGCon this week. I will try to write a separate blog post about this -- but anyway, an advantage of being at a conference that is thousands of miles away from your home is you are not being disturbed at all -- so I took this opportunity to finish 9.2 RPMs.
So, here is the big, detailed, extra long announcement
of 9.2 RPMs
As of 9.2, I am dropping support for RHEL/CentOS 4, since Red Hat already EOLed RHEL 4. Similarly, 9.2 will only be available for Fedora 15 and above. I will keep maintaining older branches, until we EOL 9.1
There are probably still some bugs -- let me know if you find one!
I have announced
PostGIS 2.0.0 packages last week -- now time for a tutorial about how to install them on RHEL/CentOS/SL 5 and 6.
Continue reading "Installing PostGIS 2.0.X on RHEL/CentOS/Scientific Linux 5 and 6 (Fedora? That is easy!)"
2.0.0 this week. Kudos to entire team for the great work. It is definitely a milestone both for PostGIS and PostgreSQL.
Continue reading "PostGIS 2.0.0, RPMs and so."