Devrim's PostgreSQL Diary

CHAR(10) Day 0

nospam@example.com (Devrim GUNDUZ) — Fri, 02 Jul 2010 18:16:01 +0300

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 security and bugfix updates released.

nospam@example.com (Devrim GUNDUZ) — Mon, 17 May 2010 18:42:52 +0300

PostgreSQL project released new versions for all active branches today. Please ugprade ASAP.

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

nospam@example.com (Devrim GUNDUZ) — Tue, 04 May 2010 18:39:20 +0300

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

nospam@example.com (Devrim GUNDUZ) — Tue, 04 May 2010 10:13:12 +0300

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

nospam@example.com (Devrim GUNDUZ) — Mon, 03 May 2010 23:59:00 +0300

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

Live CD based on Fedora 12 and PG 8.4.3 released

nospam@example.com (Devrim GUNDUZ) — Mon, 26 Apr 2010 10:22:11 +0300

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"

Announcing Slony-2.0 RPMs for RHEL / CentOS 5

nospam@example.com (Devrim GUNDUZ) — Fri, 23 Apr 2010 20:30:06 +0300

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.

Live CD based on CentOS 5.4 and PG 8.4.3 released

nospam@example.com (Devrim GUNDUZ) — Fri, 23 Apr 2010 20:24:56 +0300

I released new version of my PostgreSQL 8.4 live CD, which is based on CentOS 5.4. It includes the PostgreSQL related packages that I build on http://yum.pgrpms.org, along with PostgreSQL 8.4.3.

Continue reading "Live CD based on CentOS 5.4 and PG 8.4.3 released"

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

nospam@example.com (Devrim GUNDUZ) — Fri, 23 Apr 2010 15:34:40 +0300

Installing, configuring, running and administrating Slony-I 2.0 on Red Hat / CentOS using RPMs - Part 1 : Pre-installation and installation phases

This article series will tell about installation, configuration and the running phases of Slony-I 2.0 series on Red Hat / CentOS 5. This article assumes that you installed PostgreSQL from RPMs on each node and you are already using PostgreSQL RPM repository, If you have not, please refer here for details.

Continue reading "Installing, configuring, running and administrating Slony-I 2.0 on Red Hat / CentOS using RPMs - Part 1"

My recent PostgreSQL activities

nospam@example.com (Devrim GUNDUZ) — Tue, 13 Apr 2010 20:49:52 +0300

Over the last ~2 months, I spent lots of time for community work. The one which is not visible from the community is 9.0 testing of 3rd party software. These are mostly build and basic functionality testing. I'm testing the software that I build for PostgreSQL RPM Buildfarm. I already contacted many upstream developers, so that they can fix the issues, and many of them already support 9.0.

I'm also working on adding new packages to the repository. Given that I fixed lots of long standing issues in many packages, I'm also about to announce new packages, like Slony 2.0.X for RHEL 5. (Yay for Devrim! )

Also, I'm writing some monitoring stuff for use at work, and I will release them as soon as they are production ready. Yeah, Python...

PostgreSQL RPM sets for 9.0 Alpha4 released

nospam@example.com (Devrim GUNDUZ) — Tue, 09 Mar 2010 08:38:53 +0200

I released PostgreSQL RPM sets for 9.0 Alpha 4 yesterday. They are distributed through PostgreSQL FTP site & mirrors.

Also, they are available via the new PostgreSQL RPM repository: http://yum.pgrpms.org (more on this will come soon)

Please find more info about 9.0 Alpha 4 RPMs in here.

...and Devrim flies to...

nospam@example.com (Devrim GUNDUZ) — Thu, 25 Feb 2010 18:17:09 +0200

After quitting my old job, I got a few offers. Two of them were really good ones, but I had to pick up one.
Continue reading "...and Devrim flies to..."

F.A.Q. about latest news

nospam@example.com (Devrim GUNDUZ) — Fri, 12 Feb 2010 10:25:00 +0200

Ok, I got numerous e-mails, and even 2 phone calls since morning. Time to write a F.A.Q. about quitting Command Prompt:

Q: ...
A.: No, don't expect to hear anything negative about CMD from me. Never,ever. I'm not a that type of person.

Q: Are you looking for a job?
A: Definitely . But not now. I have to sit and think for a while. I only want to do PostgreSQL +Red Hat thing. Nothing else.

Q: How do you feel?
A: I feel like losing a big part of my family.

Q: What about PostgreSQL RPMs?
A: pgsqlrpms.org domain is owned by Command Prompt. I was paid while maintaining that repository. Now, it is in CMD's hands. I'm sure they will find someone to maintain it. However, I have postgresqlrpms.org domain. If CMD stops maintaining repository, or if I find some funds for maintaining a new repository, I may move all packages to new domain with proper announcement. See? I don't know aything on that.

Q: What about other community tasks?
A: I was involved in PostgreSQL.org infrastructure before I started working for CMD -- so I will continue now, too.

Q: Wanna drink a beer with me?
A: Sure. Just give me a call.

Bye bye Command Prompt.

nospam@example.com (Devrim GUNDUZ) — Fri, 12 Feb 2010 10:23:00 +0200

It has been 50 month since I was hired by Command Prompt. We had really good days. Joshua was not only my boss, but also a great friend of mine, like Alvaro, Lacey, Aurynn, Alexey, Andy, Christine, Larry, Darcy, Andrew, and others.

However, it should end at some point. As of today, I'm no longer working for Command Prompt. Please remove devrim@CommandPrompt.com from your addressbooks.

Thank you for everything Command Prompt, you are really a good part of my life.

If you are curious about PostgreSQL RPMs: Domain is owned by Command Prompt, so it is now in their hands. I have got some plans on this, but it is not something that I want to mention right now.

Yet another big move: 8.5->9.0

nospam@example.com (Devrim GUNDUZ) — Thu, 21 Jan 2010 21:43:13 +0200

I'll keep this short. Dave announced that upcoming PostgreSQL release will be 9.0, not 8.5. Both Streaming Replication and Hot Standby is really another milestone at PostgreSQL project, like Windows port in 8.0.

Thanks everyone who made this great release to turn into 9.0...