Skip to content

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 http://yum.pgrpms.org, along with PostgreSQL 9.0.2.

Details are here:

http://pglivecd.org
http://yum.pgrpms.org/livecd.php

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.

How To Build Your Own PostgreSQL (and related software) RPMs on CentOS/RHEL/Fedora

Even though there is a wide range of RPMs for PostgreSQL and related projects in the repositories, some people don't want to use prebuilt options, or may apply some specific patches. Also, some companies prefer to build their packages from srpms, per their IT policy -- so they maintain their own packages.

This is very easy if you use the PostgreSQL RPM Repository infrastructure. Now, I will go over the details for it. Continue reading "How To Build Your Own PostgreSQL (and related software) RPMs on CentOS/RHEL/Fedora"

How to install PostgreSQL 9.0 Beta 1 to Fedora/CentOS/RHEL

I have been working over the last months for PostgreSQL 9.0 RPMs. As Debian/Ubuntu folks have been doing over the years, I now enabled multiple PostgreSQL installation with RPMs.

Given that PostgreSQL 9.0 Beta 1 was released yesterday, we need more people to test it. Currently we have RPMs for Fedora 7,8,12, and RHEL/CentOS 4,5 for all architectures.

Anyway, this is a quick guide about installing PostgreSQL 9.0 Beta1 (which will probably apply to stable release as well) on Fedora/CentOS/RHEL. Currently none of these distros have PostgreSQL 9.0 in their stable / development trees, so I will use my repository here.

Continue reading "How to install PostgreSQL 9.0 Beta 1 to Fedora/CentOS/RHEL"

Installing, configuring, running and administrating Slony-I 2.0 on Red Hat / CentOS using RPMs - Part II

(Typos and grammar errors fixed. Thanks Lacey)

Part II: Slony-I basics and Slony-I configuration - slon.conf

Slony-I basics

slon is the deamon that is responsible for replication. It needs to be installed for each node, as described in the first part of the article.
Continue reading "Installing, configuring, running and administrating Slony-I 2.0 on Red Hat / CentOS using RPMs - Part II"