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