Devrim's PostgreSQL Diary

I updated my PostgreSQL live CD, which is based on Fedora 10. The major change is PostgreSQL 8.3.7 . It includes the PostgreSQL related packages that I build on http://yum.pgsqlrpms.org . This new version includes one new package (pgstat2), and also many updates to the existing packages.

Details are here:

http://yum.pgsqlrpms.org/livecd.php

According to web server logs, the previous versions were downloaded more than 4000 times. Also I know that kickstart file was used in some private projects. Thanks everyone for their interest in this live CD.

Now there is an option to 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 nearly bleeding edge of many software, like Apache, PHP, GNOME, Pidgin, Firefox etc.

Kickstart file is configurable, so you can also create your own PostgreSQL Live CD's fairly easily, if you have a Fedora-10 machine around.

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

As Dave announced, PostgreSQL website redesign contest began.

If you are a valuable designer and want to make $2000 USD, you are welcome to join the contest

Finally, PostgreSQL 8.4 is entering beta. Beta1 will be wrapped today, and barring any unexpected issues, it will be announced on next Wednesday. With lots of new features, 8.4 will be one of the greatest releases ever.

Stay tuned.

Now that Dave closed pgAdminII project (actually sold it to a company and now Dave has a new big farm), I forked pgAdmin III.

The new project is called OpenpgAdmin III. We weill re-develop pgAdmin II with Ruby-GTK, and will use Bitkeeper as SCM. For details, please visit OpenpgAdmin III website.

Tom just committed the Window functions patch. Yay! This is an SQL:2008 feature. Oscar goes to Hitoshi Harada.

I updated my PostgreSQL live CD, and it is now based on Fedora 10 and PostgreSQL 8.3.5, with all the PostgreSQL packages that I build on http://yum.pgsqlrpms.org . This new version includes many new packages,
and also many updates to the existing packages.

Details are here:

http://yum.pgsqlrpms.org/livecd.php

According to Apache logs, the previous 2 versions were downloaded more than 3200 times. Also I know that kickstart file was used in some private projects. Thanks everyone for their interest in this live CD.

Now there is an option to 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 nearly bleeding edge of many software, like Apache, PHP, GNOME, Pidgin, etc.

Kickstart file is configurable, so you can also create your own PostgreSQL Live CD's fairly easily, if you have a Fedora-10

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

I am currently working on building PostgreSQL packages for openSUSE. I have applied major changes to the SUSE spec file, and now we are good to go. Don't forget to take a look at http://yum.pgsqlrpms.org sometime on Monday

SuSE packages have always been a few minor releases back . I will keep them up2date, and also try to create a unified RPM environment between Fedora'ish releases and SuSE'ish releases.

$SUBJECT says it all -- Fedora 10 support is now available. If you cannot find some packages, just be patient -- I'm still working hard to finish building all packages -- but you'll find the main postgresql line.

I got enough e-mails/IM messages/IRC messages nowadays about Planet PostgreSQL. Time to explain what happened:

The server that host(ed) Planet PostgreSQL went down on Wednesday night. Unfortunately we don't have any backups. I installed a new and more powerful server yesterday afternoon. The aggregator is up -- however people.planetpostgresql.org is not up yet. I'm still working on it (I installed mine for testing).

At the same time, Magnus asked me to point www.planetpostgresql.org to the planet site he developed over the last few months. I first did it, however after thinking about it a bit, I did not want to host it at a community server. I was told that Planet PostgreSQL will be removed from postgresql.org website, if it is not hosted at a community server -- and I reverted DNS change. PostgreSQL.org webpage is now being fed from a different domain.

Planet has never been hosted at a community server (we hosted it at a CMD server, which CMD donated to community, but that is a different story) -- and at the same time, it fed postgresql.org homepage! I can understand that community now changed their decision, but I must say that I'm really annoyed with the result.

Over the last 4 years, Planet PostgreSQL was a great success -- we encouraged people to blog, and we had really high-quality articles from various bloggers. We had core members, developers, etc.

Now, we won't feed PostgreSQL.org homepage -- but I will continue this service.

Stay tuned.

PostgreSQL 8.3 beta 1 was announced today.
Note: This weekly news is for PostgreSQL.

Continue reading "PostgreSQL Weekly News - Oct 8th, 2007"

Marc tagged 8.3beta1 a few minutes before, and we are about to enter beta... Now, time to test this great release.

Oscar goes to Oleg and Teodor, and also to Tom. TSearch2 is now in core.

It is one of the times that the words cannot express my feelings...

After PGDay.it, Magnus and Andreas told me that they sent me a package (from Germany). It finally arrived (it took a lot of time to arrive here. Customs thing ) today (Click for larger image):

6 t-shirts, 2 pens, lots of pins, etc etc etc... I felt as if I went to Italy.

But the best gift was not these... It was a postcard (Click for the larger image):

A postcard signed by lots of people from EU PostgreSQL community: Magnus, Andreas, Stefan, Federico, Jean-Paul, Guillaume, Dave, Mitani, Gabriele, David, Marco, Susanne, Torello, Osvaldo, and other guys from there... I could not read all the signatures (yet), please do let me know if your name is there and I'll update this blog entry.

Thanks guys. I love all of you. This is all I can say now. You made me very happy... and also you made Gunes Deniz very happy -- this is the best gift that he got.

... and yes, there is a story behind the postcard:

Continue reading "I love PostgreSQL community..."

He finally arrived... Welcome Gunes Deniz Gunduz ... and yes, I have a spec file for him, and I will push it for review to Fedora