News

02.08.2010 - PostgreSQL 9 Beta4 available (Josh Berkus, Selena Deckelmann)

The fourth beta release for PostgreSQL version 9.0 is now available. This beta contains numerous fixes and a few changes since beta3. As this is likely to be the last beta release, please download, install, and test it so that we can move toward final release of 9.0.

Beta4 contains primarily bug-fixes in response to user testing reports since Beta3. The one significant user-facing change is to report \timing information even when psql is being run in "quiet" mode. Fixes include:

  • Report disk space error properly and do not load .psqlrc when using pg_upgrade;
  • Allow full SSL certificate verification when host and hostaddr are both specified, backpatched to 8.4;
  • Fix for pg_dump's handling of SQL/MED objects;
  • Bugfix and performance improvement for scans of lossy GIN index pointers;
  • Fix for possible page corruption in ALTER TABLE .. SET TABLESPACE;
  • Properly replay CREATE TABLESPACE during crash recovery;
  • Cleanup subtransactions in FOR loops, and avoid deep recursion when assigning XIDs to multiple levels of subtransactions (to be backpatched to 8.0)

Unlike previous betas, there has been no system catalog change since Beta3, so an initdb should not be required to upgrade test databases from Beta3. Upgrading test databases from earlier versions or betas will require an initdb, however, so we urge users to take the opportunity to test upgrading their database using 9.0's pg_upgrade and report the results.

If you are able to help with beta testing, please see the testing page:http://wiki.postgresql.org/wiki/HowToBetaTest

Betas are not stable and should never be used in production; they are for testing only. A release candidate will be available for testing soon.

Source code, as well as binary installers for many platforms, is available from the PostgreSQL Web Site:

12.07.2010 - PostgreSQL 9 Beta3 available (Marc G. Fournier)

The third beta release for PostgreSQL version 9.0 is now available. This beta contains numerous fixes and several changes since Beta2, foremost among them a final clean-up of Streaming Replication and Hot Standby. Please download, install, and test it so that we can move towards final release of 9.0.

Some significant changes have been introduced in beta3 which will require some applications to be re-tested with 9.0. These include:

  • Fixes for streaming replication and hot standby:
    • close walwriter filehandles faster
    • fsync on master before sending WAL
    • improved handling of archive cleanup
      (including archive_cleanup_command
      and pg_archivecleanup contrib module)
    • better handling of WAL record corruption
    • change of standby delay settings and timing
  • Fix for array handling in plpython
  • Many dblink fixes
  • TCP keepalive support in libpq
  • Fix for checkSeek() behavior on old platforms
    (was causing pg_dump to occasionally fail)

Note that, due to a system catalog change, an initdb and database reload *will* be required for upgrading from 9.0Beta1. We encourage users to use this opportunity to test pg_upgrade for the upgrade from Beta2 or an earlier version of 9.0. Please report your results.

If you are able to help with beta testing, please see the Beta testing page: http://wiki.postgresql.org/wiki/HowToBetaTest

Betas are not stable and should never be used in production; they are for testing only. Additional beta releases, or a release candidate, will be available for testing in a few weeks.

Source code, as well as binary installers for many platforms, is available from the PostgreSQL Web Site:

03.07.2010 - Andy Wenk

Heute hat unsere Nationalelf Argentinien 4:0 geschlagen ;-)

03.07.2010 - Magnus Hagander

The PostgreSQL Europe Merchandise store is now open - go to http://www.postgresql.eu and click merchandise!

The store has a mix of PostgreSQL branded stuff. If you have any ideas for things you'd like to buy that isn't there, just let us know on the pgeu-general@postgresql.org maillinglist.

12.06.2010 - ChronicDB v2.2.2

ChronicDB v2.2.2, ein Werkzeug zum Verteilen von Schemata, ist erschienen. http://chronicdb.com

09.06.2010 - pg_lesslog for PostgreSQL 9.0 beta2 - (Koichi Suzuki)

pg_lesslog 1.4.2 beta is now available for PostgreSQL 9.0 beta2. You can download the latest file from http://pgfoundry.org/projects/pglesslog/

02.06.2010 - Ergebnis der Wahl des pgeu Vorstandes

Die Ergebnisse zur Wahl des "pgeu board" können unter folgender URL eingesehen werden:

https://www.postgresql.eu/elections/2/

Herzliche Glückwünsche gehen an Dave Page, Guillaume Lelarge und Andreas Scherbaum

17.05.2010 - Security release of all versions (Tom Lane)

The PostgreSQL Project today released minor versions updating all active branches of the PostgreSQL object-relational database system, including versions 8.4.4, 8.3.11, 8.2.17, 8.1.21, 8.0.25, and 7.4.29. This release fixes moderate-risk security issues with PL/perl and PL/tcl, as well as a data corruption issue with standby databases. Users of any of these three features should update their PostgreSQL installations immediately.

The PL/perl security fix closes a security hole in PL/perl procedures which could allow privilege escalation on the host system, caused by a flaw in Safe.pm; see CVE-2010-1169 and CVE-2010-1447 for details. A second patch prevents PL/tcl's pltcl_modules table from being subverted in order to run arbitrary Tcl scripts; see CVE-2010-1170. These issues only affect users who have enabled either of these two stored procedure languages.

The issues patched in this update release affect version 9.0 Beta 1 as well, and will be corrected in an upcoming 9.0 Beta 2 release.

There are also 21 other bug fixes in this release, some of which apply only to version 8.4, and a few of which are specifically for Windows. While these are generally fixes for minor issues, among the changes are:

* Fix for a combinational crash condition
* Prevent normal users from resetting some GUCs in their own role definitions
* Correctly apply constraint exclusion in UPDATE and DELETE queries
* Minor fixes for WAL archiving
* Update timezone data for 12 zones

See the release notes for a full list of changes with details.

As with other minor releases, users are not required to dump and reload their database in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users skipping more than one update may need to check the release notes for extra, post-update steps.

* Release Notes http://www.postgresql.org/docs/current/static/release.html
* Installation Packages http://www.postgresql.org/ftp/binary/
* Source Code http://www.postgresql.org/ftp/source/
* Windows and One-click Installer http://www.enterprisedb.com/products/pgdownload.do
* Details of Security Issues http://www.postgresql.org/support/security

The PostgreSQL Global Development Group will stop releasing updates for PostgreSQL versions 7.4 and 8.0 after June of 2010. We urge users of those versions to start planning to upgrade now.

regards, tom lane

13.05.2010 - PostgreSQL 9.0beta1 und Feature List

Die Beta der PostgreSQL 9.0 ist online unter http://www.postgresql.org/about/news.1198 verfügbar. Ausserdem gibt es unter http://www.postgresql.org/about/featurematrix eine Feature Matrix die beschreibt, in welcher Version welche Features enthalten sind. Die Core Developer und Commiter haben aufgerufen die PostgreSQL 9 beta zu installieren und zu testen.

08.05.2010 - PHP Magazin 4.10 Buch Kritik von Thomas Wießeckel

PostgreSQL
Thomas Pfeiffer und Andreas Wenk

PostgreSQL spielt vor allem in businesskritischen Anwendungen eine immer größere Rolle. Kein Wunder also, dass das Angebot an Fachliteratur weiter anwächst, darunter auch PostgreSQL von Thomas Pfeiffer und Andreas Wenk, das vor allem mit umfangreichen Kapiteln zu User Defined Functions, Volltextsuche, Performance und Administration punkten möchte.

Das Buch beginnt erwartungsgemäß mit einer Vorstellung der Werkzeuge wie pgAdmin III und psql, dicht gefolgt von der Vermittlung der Grundlagen. Mit dem Kapitel Fortgeschrittene Funktionen wird es dann richtig interessant. Mit regulären Ausdrücken, Typecasting, Sequenzen dem Rechte- und Rollen- sowie dem Regelsystem steigen die Autoren soweit in die Materie ein, dass man langsam aber sicher versteht, weshalb PostgreSQL immer beliebter wird. Es folgt ein Einblick in die User Defined Functions und umfangreich das Thema PL/pgSQL, einer Erweiterung der PostgreSQL-Datenbank, die dem Nutzer viele neue Möglichkeiten eröffnet. Bevor es im letzten Kapitel um die Installation unter Linux und Windows geht, behandeln Pfeiffer und Wenk im sechsten Kapitel in aller Ausführlichkeit die Volltextsuche und Administration. Auch der Bereich Administration lässt keine Fragen offen; einzig im Bereich Performance hätte man sich etwas mehr gewünscht, doch damit lassen sich bestimmt Bücher füllen.

Die Qual der Wahl liegt bei dem umfangreichen Angebot momentan eindeutig beim Käufer. Mit PostgreSQL erhält der geneigte Leser jedoch ein toll geschriebenes Buch, das ihn hervorragend in die Materie einführt und dabei keine Referenz sein möchte, sondern die Vorzüge der Open-Source-Datenbank näher bringen will - und das ohne Probleme schafft.

03.05.2010 - PostgreSQL 9.0 Beta 1 Now Available (Josh Berkus)

The first beta release of PostgreSQL version 9.0 is now available. Version 9.0 is the first version of PostgreSQL to include built-in real-time binary database replication with query scale-out, consisting of two features, "hot standby" and "streaming replication". Combined with its other major features, this release will expand adoption of PostgreSQL by new users and in new types of applications.

... read more

26.04.2010 - Creeping to Beta (Bruce Momjian)

In der Community sind Fragen aufgekommen, warum es noch keine Beta version der PostgreSQL 9 gibt. Bruce Momjian gibt ind seinem blog einen Kommentar dazu ab (englisch).

Blog post lesen

25.04.2010 - Neue PL/Proxy Version 2.1 (Marko Kreen)

Es gibt ein neues PL/Proxy Release 2.1.PL/Proxy ist ein Datenbank Partitionierungs System

Release Notes: http://pgfoundry.org/frs/shownotes.php?release_id=1635
Download: http://pgfoundry.org/projects/plproxy/
Homepage: http://wiki.postgresql.org/wiki/PL/Proxy
Code: http://git.postgresql.org/gitweb?p=plproxy.git;a=summary

23.04.2010 - PGCon 2010 - registered yet? (Dan Langille)

Registration for PGCon 2010 is open.

http://www.pgcon.org/2010/registration.php

The full list of talks and a preliminary schedule is available here:

http://www.pgcon.org/2010/schedule/

There are still some rooms available on campus but I recommend booking soon as they always fill up.

22.04.2010 - Piggly: PL/pgSQL code coverage tool (Kyle Putnam)

First public release of piggly, version 1.2.0.

Piggly recompiles a PL/pgSQL stored procedure with instrumentation code to track the execution of branches, loops, and blocks of code. After running your unit tests, It generates a syntax-highlighted view of the code, annotated with code coverage notes.

Homepage: http://github.com/kputnam/piggly/

Features
* Consecutive loop iterations are counted (pass through, once, more than once)
* Each branch condition is checked for evaluating both true and false
* Execution of the start of each code block is tracked to report untested regions
* Low test execution overhead
* Installable as a Ruby gem: gem install piggly

Unit tests must be written in Ruby, though future releases may lift this requirement.

21.04.2010 phpPgAdmin 4.2.3 Released (Robert Treat)

The phpPgAdmin Team is happy to announce a new bugfix release for phpPgAdmin. Version 4.2.3 fixes several long standing bugs and fixes some PHP 5 compatability issues in the 4.2.x branch. All users of phpPgAdmin are encouraged to upgrade to this new version.

Donwload: http://phppgadmin.sourceforge.net/?page=download

Demo: http://phppgadmin.kattare.com/phppgadmin4/

Note, this may likely be the last version of phpPgAdmin released on the 4.2.x branch. We are currently planning to release phpPgAdmin 5.0 this summer, which will support PHP 5+ only, and Postgres 7.4+. Legacy users should continue to use 4.2.3.

13.04.2010 AMOOCON 2010 Konferenz in Rostock

Vom 4. - 6. Juni findet in Rostock die AMOOCON statt. Was ist AMOOCON? Zitat:
"This is a conference about stuff we find interesting. We are not so much looking for Buzz-Word-Bingo-Talks but for exceptional topics and for very good speakers."

Michael Renner von der PGUG wird dort über die PostgreSQL 9 sprechen:
http://www.amoocon.de/talks/138

12.04.2010 PG software updates (Weekly Newsletter April 11 2010)

Versions 1.2.21 and 2.0.3 of Slony1, a master-slave cascading replication system for PostgreSQL, released.
http://www.slony.info/

Postgre-XC, a synchronous multi-master cluster for PostgreSQL, released.
https://sourceforge.net/projects/postgres-xc/

py-postgresql version 1.0, a pure Python 3 driver for PostgreSQL, released.
http://python.projects.postgresql.org/docs/1.0/changes.html

ODBC-Link 1.0, and ODBC-based database link system, released.
http://www.cybertec.at/en/postgresql_downloads

07.04.2010 Backup Scripte für cronjobs (Andreas Wenk)

Ich habe im Rahmen des letzten Teils der PostgreSQL Artikel Serie zwei kleine Shell scripte geschrieben um ein Backup wieder in die Datenbank zurück zu spielen. Der Code steht auf GitHub zur freien Verfügung

http://github.com/andywenk/pg_backup_scripts

06.04.2010 ODBC-Link 1.0for PostgreSQL released (Hans-Juergen Schoenig)

we are glad to accounce generic database links for PostgreSQL, ODBC-Link. ODBC-link is a dblink-style implementation of PostgreSQL database links. It allows users to connect from PostgreSQL to any other ODBC compliant database such as Informix, Oracle, DB2, MySQL, etc.. You can integrate data from remote databases into your local query results. Writing requests are fully supported.i

ODBC-Link is fully implemented and C and does not need any other scripting language on the system.

To download ODBC-Link refer to http://www.cybertec.at/en/postgresql_downloads

06.04.2010 py-postgresql v1.0 released (James Willia Pye)

I'm pleased to announce the release of py-postgresql version 1.0, the pure Python 3 driver for PostgreSQL formerly known as 'pg_proboscis'.

Highlights:

* CopyManager for connection-to-connection COPY operations.
* NotificationManager for receiving asynchronous notifications with payloads.
* Advisory Lock Context Manager.
* hstore type support.
* Improved performance. 2x, in some cases.

For a more detailed list of changes, visit: http://python.projects.postgresql.org/docs/1.0/changes.html

24.03.2010 2nd set of PostgreSQL 9.0 Alpha4 RPMs are available (Devrim Gündüz)

I just released 2nd set of RPMs for 4th Alpha of the upcoming 9.0 release.

[...]

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

http://developer.postgresql.org/pgdocs/postgres/release-9-0.html

As usual, please find detailed info about RPMs from:

http://yum.pgrpms.org/howtoyum.php

Also, these packages will be distributed over the PostgreSQL FTP network, later in the day:

ftp://ftp.postgresql.org/pub/binary/v9.0alpha4

A mini howto about 9.0 alpha release + RPMs are here:

http://yum.pgrpms.org/news-9.0alpha-packages-ready-for-testing.php

These packages don't support upgrading from any of the previous alphas, if you have all packages installed. I did not bother to fix it, since this is just an alpha. A workaround is removing postgresql-contrib package before running yum update.

Please note that these packages are **not** production ready.

20.03.2010 Release Notes für PostgreSQL 9

Obwohl der Release Termin der neuen PostgreSQL 9 noch nicht fest steht, können die Änderungen und Neuerungen unter http://developer.postgresql.org/pgdocs/postgres/release-9-0.html nachgelsene werden.

17.03.2010 pgreplay log file replayer released (Albe Laurenz)

I announce the first release of pgreplay, version 0.9.0 (Beta).

Project home page: http://pgreplay.projects.postgresql.org/

pgreplay reads a PostgreSQL log file (*not* a WAL file), extracts the SQL statements and executes them in the same order and relative time against a PostgreSQL database cluster.

16.03.2010 New PostgreSQL RPM Repository (Devrim Gündüz)

Over the last month, I worked on new PostgreSQL RPM repository based on the existing build machines, and existing package signs.

As of today, it is officially live with the new PostgreSQL releases (another announcement is on the way)

The new URL is: http://yum.pgrpms.org

Repository packages are here:

http://yum.pgrpms.org/reporpms/repoview/letter_p.group.html

Thanks a lot to Darcy Buskermolen for his great support over the 2,5 years on this project.

All people who want to contribute to spec files are welcome, I'd like to see this as a community project for the community.

15.03.2010 PostgreSQL Cumulative Bugfix Release (Josh Berkus)

The PostgreSQL Project today released minor versions updating all active branches of the PostgreSQL object-relational database system, including versions 8.4.3, 8.3.10, 8.2.16, 8.1.20, 8.0.24, and 7.4.28. This release provides a workaround for some third-party SSL libraries, as well as multiple fixes for minor uptime and data integrity issues. All database administrators are urged to update your version of PostgreSQL at your next scheduled downtime.

... weiter lesen

15.03.2010 PostgreSQL product updates

pgAdmin 1.10.2, a GUI management tool for PostgreSQL, released.
http://www.postgresql.org/ftp/pgadmin3/release/v1.10.2/

PostGIS 1.4.2 and 1.5.1 released.
http://postgis.org/download

09.03.2010 - PostGIS 1.4.2 and 1.5.1 released (Paul Ramsey)

Patch releases of the 1.5 and 1.4 PostGIS series are now available!

http://postgis.org/download

01.03.2010 - PGCon 2010 registration now open (Dan Langille)

Folks,

Registration for PGCon 2010 is now open.

http://www.pgcon.org/2010/registration.php

The full list of talks and a preliminary schedule will be published later this week. Watch this space.

28.02.2010 - Andreas Wenk auf der CeBit

Am 02.03.2010 werde ich zusammen mit Andreas Scherbaum in Halle 2 in der "Project Lounge" den PostgreSQL Stand betreuen. Wir werden Fragen zur PostgreSQL in allen Bereichen beantworten. Sei es technisch oder aber auch über die Community. Natürlich haben wir auch Rechner dabei um die PostgreSQL live zeigen zu können.

24.02.2010 - 9.0 Alpha 4 Available Now (Josh Berkus)

The fourth alpha release for PostgreSQL version 9.0, 9.0alpha4, is now available. This alpha contains several new major features added since the previous alpha. Please download, install, and test it to give us early feedback on the features being developed for the next version of PostgreSQL.

Features added in Alpha4 include:

  • Streaming Replication for binary log-based replication of PostgreSQL
  • New in-memory, high-performance Listen/Notify queue
  • Automatic row-count return to drivers on SELECT queries
  • ROWS PRECEDING and ROWS FOLLOWING windowing functions

... mehr lesen

25.01.2010 - PGUG bei den Chemnitzer Linux Tagen

Die Deutsche PostgreSQL User Gruppe hat einen Stand auf den Chemnitzer Linuxtagen 2010 am 13. und 14. März 2010 in Chemnitz, Deutschland.
... mehr Info

18.01.2010 - PGUG mit Stand auf der Cebit 2010

Andreas Scheerbaum hat für die PostgreSQL User Group Deutschlandi (PGUG) auf der Cebit in Halle 2 in "Project Lounge" einen Stand organisiert. Andereas Wenk wird dort am 05.03.2010 auch mit von der Partie sein.

Außerdem hat die PGUG einen Stand auf den Chemnitzer Linuxtagen am 13. und 14.03.2010 in Chemnitz.

12.01.2010 - PostrgreSQL Konferenzen 2010

Am 20. und 21.05.2010 findet die PGCon 2010 in der Universiyt of Ottawa in Ottawa (USA) statt. Die Infoseite ist hier zu finden.

Vom 25. - 28.03.2010 findet die PostgreSQL Conference U.S in Philadelphia (USA) statt. Weiter Information sind hier zu finden.

10.01.2010- PostgreSQL at FOSDEM 2010 (Markus Hagander)

As has become tradition, PostgreSQL will be present at FOSDEM 2010 in Brussels, Belgium. This is a great, *free*, conference for people interested in just PostgreSQL, and even more for those interested in other OpenSource products as well. For information about the conference, see http://www.fosdem.org

PostgreSQL will have a stand where we will be answering questions, talking to people in general, and selling PostgreSQL merchandise.

... weiter lesen

07.01.2010 - PostgreSQL Source Code jetzt auf github.com

Bruce Momjian hat auf github.com einen Mirror für den "head branch"(aktuellster Entwicklungszweig) der PostgreSQL als git repository eingerichtet. Es ist hier zu finden.

04.01.2010 - Missing Features for PostgreSQL SQL Conformance (Blog Peter Eisentraut)

A thought to start the new year: Perhaps it's time for the final push to complete the core SQL conformance for PostgreSQL.

Where do we stand? The PostgreSQL documentation lists in its appendix the currently supported and unsupported SQL features. As explained there, a certain subset of these features represents the "Core" features, which every conforming SQL implementation must supply, while the rest is purely optional. The unsupported features page currently lists 14 remaining Core features and subfeatures that are missing from PostgreSQL. Two of those are about client-side module support that is actually not mandatory if the implementation provides an embedded language (e.g., ECPG), so there are 12 items left.

... weiter lesen

30.12.2009 - psqlODBC 08.04.0200 Released (Hiroshi Inoue)

We are pleased to announce the release of psqlODBC 08.04.0200. For details of the changes in this release, please see the notes at: http://psqlodbc.projects.postgresql.org/release.html

28.12.2009 - Npgsql 2.0.8 released! (Francisco Figueiredo Jr.)

The Npgsql Development Team is proud to announce the Npgsql2 2.0.8 release!

Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained frome http://www.npgsql.org

PostgreSQL 8.5alpha3 Now Available (Peter Eisentraut)

The third alpha release for PostgreSQL version 8.5, 8.5alpha3, is now available. This alpha contains several new major features added since the previous alpha. Please download, install, and test it to give us early feedback on the features being developed for the next version of PostgreSQL.

Alpha Release page: http://www.postgresql.org/developer/alpha

...weiter lesen

21.12.2009 - PostgreSQL Live CD for 8.4.2 released (Devrim Gündüz)

I released second version of my PostgreSQL 8.4 live CD, which is based on Fedora 12. It includes the PostgreSQL related packages that I build on http://yum.pgsqlrpms.org , along with PostgreSQL 8.4.2.

Details are here:
http://yum.pgsqlrpms.org/livecd.php http://www.pglivecd.org

14.12.2009 - PostgreSQL 2009-12-14 Security Update (Josh Berkus)

The PostgreSQL Project today released minor versions updating all active branches of the PostgreSQL object-relational database system, including versions 8.4.2, 8.3.9, 8.2.15, 8.1.19, 8.0.23, and 7.4.27. This release fixes one moderate-risk and one low-risk security issue: an SSL authentication issue, and a privilege escalation issue with expression indexes. All PostgreSQL database administrators are urged to update your version of PostgreSQL at the earliest opportunity.

...weiter lesen

14.12.2009 - pg_rman - PostgreSQL Recovery Manger released (Takahiro Itakagi)

Announcing the first release of pg_rman - PostgreSQL Recovery Manger.

pg_rman - http://code.google.com/p/pg-rman/

pg_rman is an online backup and restore tool for PostgreSQL. The goal of the pg_rman project is providing a method for online backup and PITR as easy as pg_dump. Also, it maintains a backup catalog per database cluster. Users can maintain old backups including archive logs with one command.

Supported features:
* Ease of use. Backup and restore can be done with just one command.
* Online full backup, incremental backup, and archive backup.
Incremental backup can reduce backup size extreamly.
* Backup compression. Unused area in pages are removed and only
actual data are compressed with gzip.
* Automatic backup maintenance. Backup and archive WAL files older
than specified days are deleted automatically.
* Backup validation. Backup can be validated with CRC checks.
* No transaction lost in restore. Configuration file generator for
point-in-time recovery is supported.

Takahiro Itagaki
NTT Open Source Software Center

26.11.2009 - Andreas

Wir sind online!

Ja es ist soweit. Das Buch ist in den Läden und diese Seite ist online. Wie man in einigen Bereichen sehen kann, sind wir allerdings noch nicht ganz fertig. Wir bitten noch um ein wenig Geduld.

Momentan bin ich gerade dabei die ganzen SQL Statements in den Bereich SELECT einzupflegen. Das Importieren war nicht das Problem, allerdings muss jedes einzelen Statement formatiert werden. Das kann noch einen Augenblick dauern. Ich hoffe jedenfalls, dass der Code so gut zugänglich ist.

© 2009 Andreas Wenk / Thomas Pfeiffer | Impressum | hacking by Netzmeister St.Pauli