Devrim's PostgreSQL Diary

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

Replicator 1.8.3 is available for download. It's a maintenance release of 1.8 branch and it is based on PostgreSQL 8.3.9. Here is the list of the changes since 1.8.2:

** Fixed a bug in mcp_stat that prevented it to tak to the MCP server running on a platform with different word size.
** Added fsync call right after writing queue files to prevent loosing the data in case of the crash.
** Fixed a bug that lead to full dumps after slave's reconnection to the MCP server.
** Upgraded to 8.3.9 release of PostgreSQL

You can download RHEL/CentOS packages from http://yum.pgsqlrpms.org/
Source code tarball is available at https://projects.commandprompt.com/public/replicator/wiki/getting_replicator

Hi,

PostgreSQL RPM Building Project released RPM sets for 2nd Alpha of the upcoming 8.5 release.

Please note that these packages are **not** production ready. They are for Fedora 7,8,9,11 and RHEL/CentOS 4,5.

These packages do require a dump/reload, even from the first alpha packages, because of catversion updates.

We need more people to discover any bugs and test new features in 8.5 development version.

Here is the list of the new features in 8.5 development version:

http://developer.postgresql.org/pgdocs/postgres/release-8-5.html


This RPM set has new experimental feature that has been requested for a long time: Multiple version installation for RPMs.

As usual, please find detailed info about RPMs from:

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

A mini howto about 8.5 alpha release2 + RPMs are here:

http://yum.pgsqlrpms.org/news-8.5alpha-packages-ready-for-testing.php

Please report any packaging related errors to me. If you find any PostgreSQL 8.5 bugs, please post them to pgsql-bugs@PostgreSQL.org or fill out this form:

http://www.postgresql.org/support/submitbug 

pg_filedump for 8.4 was released: http://sources.redhat.com/rhdb/utilities.html

You wanted it, and here we go:

I released initial version of my PostgreSQL 8.4 live CD, which is based on CentOS 5.3. It includes the PostgreSQL related packages that I build on http://yum.pgsqlrpms.org , along with PostgreSQL 8.4.0.

Details are here:

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

This live CD has current versions of many software, like pgAdmin III, phpPgAdmin, 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 CentOS 5.3 machine around, as described in here:

https://projects.centos.org/trac/livecd/

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

I have been intending to work on it since 2006 -- at last I committed a set of patches to pgcore svn repository.

It is available for all Fedora and RHEL/CentOS releases. No SRPMs yet, because we have some issues left, which is related to packaging. RPMs work in terms of functionality. You can start and run an 8.5 Alpha1 cluster just fine .

Impatient people can checkout SVN repository, and build packages themselves.

This change means that I will have to poke all other 50 packages, to make sure that they are using correct paths while building and running. Still, this is a one-time thing.

Once things will be stable, I'll create another channel on PostgreSQL RPM repository for 8.4, which will be installed along with 8.5-mv packages.

Enjoy!

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.