Skip to content

(Updated) Getting used to systemd: Installing and running PostgreSQL on Fedora 16+

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+"

PostgreSQL 9.2.0 released -- also the RPMs!

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

RPMs are currently available for:

- RHEL/CentOS/Scientific Linux 6 - 32-bit and 64-bit

- RHEL/CentOS/Scientific Linux 5 - 32-bit and 64-bit

- Fedora 17 - 32- bit and 64-bit

- Fedora 16 - 32- bit and 64-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.

Freshly baked, served directly from oven: Please welcome 9.2 RPMs

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!

Moving PostgreSQL RPM repository to its final location

Just after 3,5 years since its debut, PostgreSQL RPM repository is slowly moving to its final location, which is under

As of now, we are serving 9.1 packages through ( also works, of course). In the next minor release set, all repo files will point to the new URL.

Thanks PostgreSQL infrastructure team for their great help.

Rsync support is available for PostgreSQL RPM repository

Now you can rsync PostgreSQL RPMs, and create your own mirror to use for internal servers. Here are the modules:

$ rsync
pgrpm-81 PostgreSQL 8.1 YUM Repository
pgrpm-82 PostgreSQL 8.2 YUM Repository
pgrpm-83 PostgreSQL 8.3 YUM Repository
pgrpm-84 PostgreSQL 8.4 YUM Repository
pgrpm-90 PostgreSQL 9.0 YUM Repository
pgrpm-91 PostgreSQL 9.1 YUM Repository
pgrpm-92 PostgreSQL 9.2 YUM Repository

Update from PostgreSQL yum repository

Since I started this repository about 3,5 years ago, I have always used the machines that were outside control of the community. Namely, I used a machine that was hosted at Darcy Buskermolen's house for about 2 years, and then after the unrecoverable crash of the machine
I moved everything off to a machine that was in the datacenter of my previous employer, markafoni.

After I started working for EnterpriseDB, we again lost the RPM buildfarm. markafoni was kind enough to provide me images, so I have copies of each VM --but we don't have a machine since then. Actually I purchased a quad core machine with 2 TB disk and 8 GB ram for that, but that is in my home, and it is still not under control of PostgreSQL infrastructure team.

While talking to Ed Boyajian at PGEast, he kindly accepted to donate a machine to the community to be used as the PostgreSQL RPM Buildfarm. I was the bottleneck since then, but we made a progress with Dave Page during PGCon, and probably we will have the new machine up and running over the next month or so.

So, in short: We don't have a dedicated RPM Buildfarm over the last 3,5 months, and it is the only explanation that some of the PostgreSQL releases, 8.3 and 8.2, haven't been updated yet to the latest minor releases.

So, project did not stop, and will not stop -- we just need some more time to fix all issues. I also have a long bug list over the last months, and I'll also fix them as soon as we will have the new machine.

/me joins EnterpriseDB!

I could not be happier... After I decided to leave markafoni, and when I started to look for a new job, EnterpriseDB approached me very nicely, and now I'm a part of that great team. I'd like thank Ed, Karen, Bruce and Tom (Kincaid) for their great support during this process. I'm really, really, excited. Let's see what I'll add to EnterpriseDB.

Wow, really excited!

PostgreSQL Live CD for 9.0.2 released

I released initial version of my PostgreSQL 9.0 live CD, which is based on CentOS 5.5. It includes the PostgreSQL related packages that I build for, along with PostgreSQL 9.0.2.

Details are here:

You can add an encrypted home directory while burning iso to USB stick, which helps you to keep your personal data in your USB stick.

This live CD has current versions of many software, like pgAdmin III, phpPgAdmin, Apache, PHP, GNOME, Pidgin, Firefox etc., along with tons of PostgreSQL related packages.

Kickstart file is configurable, so you can also create your own PostgreSQL Live CD's fairly easily.

Please let me know if you have any questions regarding this live CD.