I presented an updated version of talk at PGDay.EU 2010
. You can download it here
Now it is time to blog about pg_upgrade tool, developed by Bruce
, and ships with 9.0 contrib.
In this article, I will mention about installing 9.0 along with 8.4 RPMs, and then upgrading 8.4 cluster without dump/restore..
Continue reading "Upgrading from 8.4 to 9.0 on Fedora / Red Hat / CentOS using RPMs"
I should have blogged this before, but better late than never.
Continue reading "Quick tip for building Slony-I on AIX"
I know it's been more than a week since I published 9.0 RPMs, and I'm a bit late to write this article -- sorry, I just could find time.
Continue reading " What is new in PostgreSQL 9.0 RPMs?"
As a person who hasn't attended any PostgreSQL conferences since 2007, I decided to bite the bullet this time, and wanted to attend CHAR(10). Thanks to my employer, they dealt with everything, and we got the visa on time.
Continue reading "CHAR(10) Day 0"
PostgreSQL project released
new versions for all active branches today. Please ugprade ASAP.
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"
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"
(Typos and grammar errors fixed. Thanks Lacey)
Part II: Slony-I basics and Slony-I configuration - slon.conf
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"
I released new version of my PostgreSQL 8.4 live CD, which is based on Fedora 12. It includes the PostgreSQL related packages that I build for http://yum.pgrpms.org
, along with PostgreSQL 8.4.3.
Continue reading "Live CD based on Fedora 12 and PG 8.4.3 released"
I released Slony 2.0.3 RPMs for RHEL5, which was requested for a long time. It is available in PostgreSQL RPM repository
Thanks David Fetter
for pre-release testing.