Skip to content

Software Development News: .NET, Java, PHP, Ruby, Agile, Databases, SOA, JavaScript, Open Source

Methods & Tools

Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!

PostgreSQL News
Syndicate content
PostgreSQL news
Updated: 8 hours 46 min ago

walbouncer: partial transaction log replication

Wed, 10/22/2014 - 01:00

We are proud to announce walbouncer 0.9 - a tool to filter transaction log. At this point we are moving rapidly closer to a production-ready tool.

The key advantage of walbouncer is that it is no longer necessary to replicate entire database instances. You can filter out entire databases and tablespaces and selectively choose what to replicate.

walbouncer can act as a WAL proxy distributing data flexible to various servers containing different subsets of data.

walbouncer is open source and can be downloaded freely from our website. Currently PostgreSQL 9.4 is supported.

Categories: Database, Open Source

CopyCat Replication Suite 3.07.0 -- PG support added!

Fri, 10/17/2014 - 01:00

I am pleased to announce a new release of our database replication engine, CopyCat Developer ! This new release adds PostgreSQL support!

CopyCat Developer is a set of Delphi / C++Builder components providing customizable replication for Firebird, Interbase, Microsoft SQL Server, MySQL, NexusDB, SQLite, PostgreSQL and Oracle, including heterogeneous replication between different database types.

Have a look at our site for more information : http://www.copycat.fr

Full list of changes in this release : http://copycat.fr/wordpress/copycat-developer-v-3-07-0-2/

Best regards, Jonathan Neve

Categories: Database, Open Source

Announcing PGConf US 2015: Mar 25 - 27, NYC - Call for Presentations Open

Fri, 10/10/2014 - 01:00

The United States PostgreSQL Association announces that PGConf US 2015 will be held from March 25 to March 27, 2015 at the New York Marriott Downtown in New York City.

Please visit http://www.pgconf.us for more information about PGConf US 2015.

Thanks to the support of our attendees, speakers, volunteers, and sponsors, PGConf NYC 2014 was the largest PostgreSQL conference ever in the United States, with 259 attendees representing 140 different companies from 5 continents gathering in New York last year. With the support of the United States PostgreSQL Association, we have renamed the conference to PGConf US to reflect the growth and excitement around PostgreSQL in the United States and to help build a stronger community.

PGConf US 2015 will feature the familiar two-day conference format on March 26 - 27 with a mix of specialized sessions, keynotes, and the ability to connect with PostgreSQL fans at various receptions throughout the day. As with past PostgreSQL conferences in NYC, we will feature presentations from the perspective of developers, DBAs, systems administrators, business-intelligence analysts, and decisions makers.

We have added on an additional day to the conference on March 25 for hosting trainings and summits. Trainings will occur at the conference venue and the training schedule will be announced in the near future. We are also launching the "First Annual Regulated Industry Summit: Finance, Government, Healthcare, and PostgreSQL" hosted at the Goldman Sachs headquarters across from the PGConf US 2015 venue, which will bring together PostgreSQL contributors and enterprise developers to discuss challenges and solutions in utilizing PostgreSQL in regulated environments. For more information about the summit and how to attend, please visit http://www.pgconf.us/2015/training/

And with that, the call for presentations is now open! For more information, please visit http://www.pgconf.us/2015/submit/

Presentation submissions will be allowed until December 17th, 2014. All speakers will be confirmed by January 10, 2015, when we will announce the schedule. As with our past conferences, there will be no extensions of the submission deadline, so we suggest you get your submissions in early!

PGConf US 2015 would not be possible without the generous support of our sponsors, which allows us to continue to produce a high-quality event while keeping registraiton fees low to encourage growing our community. We extend a very warm thank you to our launch sponsors:

For more information about sponsorship, we invite you to view our sponsorship prospectus slideshow at http://www.pgconf.us/static/prospectus/PGConf-US-2015-Prospectus.pdf

We look forward to seeing everyone in March to make this the best PostgreSQL conference in the United States to date!

For more information, please visit http://www.pgconf.us/

Categories: Database, Open Source

PostgreSQL 9.4 Beta 3 Released

Thu, 10/09/2014 - 01:00

The PostgreSQL Global Development Group has released 9.4 Beta 3, the next beta release of the new version. This beta contains previews of all of the features which will be available in version 9.4, plus corrections for many of the issues discovered by users who tested Beta 2. Please download, test, and report what you find.

The primary change in Beta 3 is a modification of the JSONB data type format in order to make JSONB fields more compressable and reduce storage requirements. This change is not backwards-compatible, so users who loaded data into JSONB fields using 9.4 Beta 1 or Beta 2 will need to pg_dump and restore to upgrade to Beta 3.

Among the other changes made since 9.4 Beta 2 are:

  • Rename pg_recvlogical's --create/--drop to --create-slot/--drop-slot
  • Prevent unbounded delay when starting background worker
  • Remove num_xloginsert_locks GUC, replace with a #define
  • Fix pg_dump's --if-exists for large objects
  • Remove ban on zero length JSON object keys
  • Return NULL from json_object_agg if it gets no rows
  • Log ALTER SYSTEM statements as DDL
  • Fix failure of contrib/auto_explain to print per-node timing information
  • Multiple fixes for TAP checks
  • Support ALTER SYSTEM RESET command
  • Fix power_var_int() for large integer exponents
  • Fix vacuumdb --analyze-in-stages --all order
  • Change the way latency is calculated with pgbench --rate option
  • Support ALTER ... ALL IN with event triggers
  • Remove superuser-only restriction from pg_is_xlog_replay_paused()
  • Fix FOR UPDATE NOWAIT on updated tuple chains
  • Fix Var handling for security barrier views
  • Fix superuser concurrent refresh of matview owned by another
  • Don't track DEALLOCATE in pg_stat_statements
  • Fix corner-case behaviors in JSON/JSONB field extraction operators
  • Change the way pg_basebackup's tablespace mapping is implemented
  • Rework 'MOVE ALL' to 'ALTER .. ALL IN TABLESPACE'
  • Fix core dump in jsonb #> operator
  • Revert psql changes to support wrapped expanded mode
  • Expose -S option in pg_receivexlog
  • Reject duplicate column names in foreign key referenced-columns lists
  • Fix checkpointer crash
  • Many minor fixes to JSON and JSONB functionality
  • Many minor fixes to logical decoding
  • Multiple bug fixes for older issues to be included in an upcoming minor release.
  • More documentation improvements and changes

Beta 3 includes changes to pg_control and to the system catalogs. As such, users who have been testing Beta 1 or Beta 2 will need to upgrade in order to test Beta 3. We suggest using pg_upgrade for this upgrade in order to test that as well.

For a full listing of the features in version 9.4 Beta, please see the release notes. Additional descriptions and notes on the new features are available on the 9.4 Features Wiki Page.

We depend on our community to help test the next version in order to guarantee that it is high-performance and bug-free. Please download PostgreSQL 9.4 Beta 3 and try it with your workloads and applications as soon as you can, and give feedback to the PostgreSQL developers. Features and APIs in Beta 3 will not change substantially before final release, so it is now safe to start building applications against the new features. More information on how to test and report issues

Get the PostgreSQL 9.4 Beta 3, including binaries and installers for Windows, Linux and Mac from our download page.

Full documentation of the new version is available online, and also installs with PostgreSQL.

Categories: Database, Open Source

LedgerSMB 1.4.0 Released

Mon, 09/15/2014 - 01:00

15 September 2014, London. The LedgerSMB project - all-volunteer developers and contributors - today announced LedgerSMB 1.4.0.

Based on an open source code base first released in 1999, the LedgerSMB project was formed in 2006 and saw it's 1.0 release in the same year. It has now seen continuous development for over eight years and that shows no signs of slowing down.

"LedgerSMB 1.4 brings major improvements that many businesses need," said Chris Travers, who helped found the project. "Businesses which do manufacturing or retail, or need features like funds accounting will certainly get much more out of this new release."

Better Productivity

LedgerSMB 1.4 features a redesigned contact management framework that allows businesses to better keep track of customers, vendors, employers, sales leads, and more. Contacts can be stored and categorized, and leads can be converted into sales accounts.

Additionally, a new import module has been included that allows businesses to upload csv text files to import financial transactions and much more. No longer is data entry something that needs to be done entirely by hand or involves customizing the software.

Many smaller enhancements are here as well, For example, shipping labels can now be printed for invoices and orders, user management workflows have been improved,

Better Reporting

The reporting interfaces have been rewritten in LedgerSMB 1.4.0 in order to provide greater flexibility in both reporting and in sharing reports. Almost all reports now include a variety of formatting options including PDF and CSV formats. Reports can also be easily shared within an organization using stable hyperlinks to reports. Additionally the inclusion of a reporting engine means that it is now relatively simple to write third-party reports which offer all these features. Such reports can easily integrate with LedgerSMB or be accessed via a third party web page.

Additionally, the new reporting units system provides a great deal more flexibility in tracking money and resources as they travel through the system. Not only can one track by project or department, but funds accounting and other specialized reporting needs are possible to meet.

Better Integration

Integration of third-party line of business applications is also something which continues to improve. While all integration is possible, owing to the open nature of the code and db structure, it has become easier as more logic is moved to where it can be easily discovered by applications.

There are two major improvement areas in 1.4. First additional critical information, particularly regarding manufacturing and cost of goods sold tracking, has been moved into the database where it can be easily shared by other applications. This also allows for better testability and support. Secondly LedgerSMB now offers a framework for web services, which are currently available for contact management purposes, allowing integrators to more easily connect programs together.

Commercial Options

LedgerSMB isn't just an open source project. A number of commercial companies offer support, hosting, and customization services for this ERP. A list of some of the most prominent commercial companies involved can be found at http://ledgersmb.org/topic/commercial-support

Categories: Database, Open Source

Introducing Open PostgreSQL Monitoring (OPM)

Mon, 09/08/2014 - 01:00
Introducing Open PostgreSQL Monitoring (OPM)

Paris, September 8th 2014

Oversee and Manage Your PostgreSQL Servers

The OPM Development Group (see below) is proud to present the first public release of Open PostgreSQL Monitoring, a fully open source monitoring suite for PostgreSQL.

Get Graphs and Stats from your PostgreSQL instances!

PostgreSQL may be the most advanced database in the world but one of its biggest handicap is the lack of open source dedicated monitoring tools. Compared to its competitors, the PostgreSQL community has not been able to produce tools similar to Oracle Grid Control, MySQL Workbench or SQL Server Management Studio.

Today we'd like to present the OPM project: a fully open-source suite designed to provide dynamic graphs, custom stats series, performance analysis, server health overview and team management...

If you have serveral postgres servers in production, Open PostgreSQL Monitoring is the perfect to watch the current activity of your databases, with DBA-centric stats such as: database size, hit ratio, streaming replication lag, system load, page bloat, longest queries, WAL files generation, locks, backends status, etc.

Extensibility is the key

This initial public version is obviously a first step toward more features and more versatility.

OPM includes remote agents, a stat storage system and a web GUI. Most of the code is currently in Perl and the stat collection is based on Nagios, but the whole suite is designed to be extended to other monitoring frameworks and other languages. It is possible to your own remote agent, a specific stat storage or even an alternative user interface.

The OPM project was started in 2012 and it's been used in production for months, monitoring dozens of servers like a charm. We're publishing today the version 2.3 with the hope that it will be useful for other PostgreSQL users around the world.

Credits

The OPM Development Group would like to thank all the developers who contributed to this release, especially Sebastien Fauveau from Art is Code for his UI/UX design skills.

OPM is an open project available under the PostgreSQL License. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly to contact@opm.io

Links

About OPM :

Open PostgreSQL Monitoring is a free software designed to help you manage your PostgreSQL servers. It's a flexible tool that will follow the activity of each instance. It can gather stats, display dashboards and send warnings when something goes wrong. The long-term goal of the project is to provide similar features to those of Oracle Grid Control or SQL Server Management Studio.

Code & Demo at http://opm.io/

About the OPM Development Group :

This project is driven by the OPM Development Group (OPMDG), a team of developers gathered to build efficient monitoring tools for PostgreSQL. So far the main sponsor of this project is DALIBO, the leading PostgreSQL company in France. However the project team is open to ideas and contributions: individuals and companies who share the goals of the OPMDG are welcome to join the team!

Categories: Database, Open Source

DbWrench Database Design 3.2 Released

Sat, 08/30/2014 - 01:00
DbWrench Database Design v3.2 Released

Although version 3.2 did not contain new features it is still a significant release for DbWrench.

The primary focus of this release was to make it Java 8 compatible. This included:

- Upgrading the underlying NetBeans windowing platform. Which should be more responsive.

- Creating a new syntax highlighting SQL editor from the ground up.

A free trial download of this latest version is available at www.dbwrench.com.

Screen shots can be viewed here.

More About DbWrench

DbWrench is designed to increase the productivity of database developers by making creating and modifying databases much easier.

It's features include:

- Graphic entity relation diagram (ERD) designer

    - Forward engineer database designs with automatic SQL DDL script generation

    - Reverse engineer and visualize existing databases

    - A built in syntax highlighting SQL query editor

    - Runs on Windows, Mac OSX and Linux all in a single license
Categories: Database, Open Source

PGConf.EU 2014 schedule posted - Matt Asay to deliver keynote

Thu, 08/28/2014 - 01:00

PostgreSQL Conference Europe is pleased to announce that the schedule for the 2014 event, to be held in Madrid from 21st - 24th October, has now been published.

As well as a wide range of talks for PostgreSQL users, developers and decision makers, we’re pleased to announce that our opening keynote speaker will be Matt Asay, Vice President of Community at MongoDB, who will discuss how PostgreSQL and NoSQL databases can work together, and where each shine on their own.

The schedule is, of course, subject to changes, and a few slots are still empty as we work to confirm the last set of speakers.

PostgreSQL Conference Europe 2014 is the sixth annual PostgreSQL Conference Europe, previous events having been held in cities such as Dublin, Prague and Amsterdam attracting hundreds of PostgreSQL developers and users. For more information and to register, please visit the website.

A discounted "early bird" registration rate is available until 15th September. A discount room rate at the conference hotel is available until 8th September, so we suggest you book your accommodation soon!

We still have seats left at some of the training sessions held the day before the main conference, taught by PostgreSQL experts from around the world, that are subject to availability at a first come first serve basis. See the training section on the website for details.

We look forward to seeing you in Madrid!

Categories: Database, Open Source

Database .NET 12.6 released

Sat, 08/23/2014 - 01:00

I am happy to announce the new major release of Database .NET 12.6, an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface.

Free, All-In-One, Portable, Standalone (No Installation) and Multlanguage.

Major New features from version 11.1 to 12.6:

The new version is immediately available for download.
Categories: Database, Open Source

Barman 1.3.3 released

Thu, 08/21/2014 - 01:00

21 August 2014: 2ndQuadrant is proud to announce the release of version 1.3.3 of Barman, Backup and Recovery Manager for PostgreSQL.

This major release improves robustness of both backup procedures and their monitoring, by introducing:

  • the so-called "smelly backup" control, allowing DBAs to detect possible problems in scheduling of periodical backups, by receiving complaints by "barman check" when the latest available backup for a server is older than a specified timeframe
  • management of retry attempts for base backup copy (for both "barman backup" and "barman recover" commands), making the operation more resilient to temporary issues such as network connection drops

Performance issues have been fixed in relation to remote recovery over existing directories (incremental recovery), by invoking checksum control only when strictly necessary.

Usability has been enhanced through better exception handling, output and logging messages. PostgreSQL 8.3 is also now supported.

The following major bugs have been fixed:

  • Copies "recovery.conf" during remote "barman recover" (#43)
  • Correctly detect pre/post archive hook scripts (#41)

Minor bugs have also been fixed.

Many thanks for funding towards the development of this release go to Agile Business Group (www.agilebg.com), Jobrapido (www.jobrapido.com), Navionics (www.navionics.com), and Subito.it (www.subito.it).

For a complete list of changes, see the "Release Notes" section below.

Links

Release notes

  • Added "last_backup_max_age", a new global/server option that allows administrators to set the max age of the last backup in a catalogue, making it easier to detect any issues with periodical backup execution
  • Improved robustness of "barman backup" by introducing two global/server options: "basebackup_retry_times" and "basebackup_retry_sleep". These options allow an administrator to specify, respectively, the number of attempts for a copy operation after a failure, and the number of seconds of wait before retrying
  • Improved the recovery process via rsync on an existing directory (incremental recovery), by splitting the previous rsync call into several ones - invoking checksum control only when necessary
  • Added support for PostgreSQL 8.3
  • Minor changes:
    • Support for comma separated list values configuration options
    • Improved backup durability by calling fsync() on backup and WAL files during "barman backup" and "barman cron"
    • Improved Nagios output for "barman check --nagios"
    • Display compression ratio for WALs in "barman show-backup"
    • Correctly handled keyboard interruption (CTRL-C) while performing barman backup
    • Improved error messages of failures regarding the stop of a backup
    • Wider coverage of unit tests
  • Bug fixes:
    • Copies "recovery.conf" on the remote server during "barman recover" (#43)
    • Correctly detect pre/post archive hook scripts (#41)

Download

About Barman

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase. Barman’s most requested features include backup catalogues, retention policies, remote backup and recovery, archiving and compression of WAL files and backups. Barman is distributed under GNU GPL 3.

Categories: Database, Open Source

Introducing POWA ! A new PostgreSQL Workload Analyzer

Tue, 08/19/2014 - 01:00

DALIBO is proud to present the first release of POWA, a brand new performance tool for PostgreSQL.

Realtime traffic analysis and dynamic graphs

POWA is a workload analyzer that gives a clear view of the current activity of your PostgreSQL servers with a query runtime graph and a block hit/read graph along with a chart of time consuming request over the specified time period.

If you zoom anywhere in one of the graphs, the chart will adjust and show you which queries were running at that time. If you click on a specific query, you will get additional graphs such as read/write time, number of rows affected, local and shared hit, etc.

A bunch of PL functions are also available to access and manage the stats.

Extending pg_stat_statements

Basically PoWA is a PostgreSQL extension designed to historize information given by the pg_stat_statements extension. It provides SQL SRF to gather useful information on a specified time interval.

This first release is ready for production but of course we will continue to improve it. Please install it (or test our demo site) and let's us know what you think of it. Right now what we need most is feedback and new ideas, especially to improve the user experience and the graphic interface...

PoWA is available under the PostgreSQL license. The main code is a PostgreSQL extension written in C and SQL. The user interface is based on Perl and Mojolicious. Obviously the stats are stored in a PostgreSQL database :-)

For the complete list of changes, please checkout the release note on https://github.com/dalibo/powa/blob/master/CHANGELOG.md

Credits

DALIBO would like to thank all the developers who contributed to this release, especially : Marc Cousin for the original idea and Julien Rouhaud for the hard work on the GUI.

POWA is an open project available under the PostgreSQL License. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly to powa@dalibo.com

Links :

About POWA :

PoWA is PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graph to help monitor and tune your PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.

Code & Demo at http://dalibo.github.io/powa/

About DALIBO :

DALIBO is the leading PostgreSQL company in France, providing support, trainings and consulting to its customers since 2005. The company contributes to the PostgreSQL community in various ways, including : code, articles, translations, free conferences and workshops

Check out DALIBO's open source projects at http://dalibo.github.io

http://www.dalibo.com

Categories: Database, Open Source

DBD::Pg 3.4.0 released

Mon, 08/18/2014 - 01:00

Version 3.4.0 of DBD::Pg, the Perl driver for Postgres, has been released: http://search.cpan.org/dist/DBD-Pg/

This version greatly enhanced the table_info() and column_info() methods.

Categories: Database, Open Source

pgBadger 6.0 is out!

Tue, 08/12/2014 - 01:00

DALIBO is proud to announce the release of pgBadger 6.0.

pgBadger is a PostgreSQL performance analyzer, built for speed with fully detailed reports based on your PostgreSQL log files.

This new major release fixes several issues and adds some new features:

  • Automatic cleanup of binary files in incremental mode.
  • Automatic handling of retention with a maximum number of weeks to keep reports.
  • Incremental mode improvement by allowing the use of multiprocessing with multiple log file.
  • Now reports the query latency percentiles on the general activity table (percentiles are 90, 95, 99).
  • A new output format: JSON. This format is good for sharing data with other tools.
  • Using the --anonymize option pgBadger will anonymize all literal values in the queries.
  • Add a click-to-select button in front of each query that allow to just use Ctrl+C to copy it on clipboard.
  • Several space usage improvement in incremental mode, the -X option allow the use of external CSS and Javascript files.
  • A new pgBadger logo

 

Warning: the behavior of pgBadger in incremental mode has changed. It will now always cleanup the output directory of all the obsolete binary file. If you were using those files to build your own reports, you can prevent pgBadger to remove them by using the --noclean option. Note that if you use the retention feature, all those files in obsolete directories will be removed too.

For the complete list of changes, please checkout the release note on https://github.com/dalibo/pgbadger/blob/master/ChangeLog

Links & Credits

DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Herve Werner, Julien Rouhaud, Josh Berkus, CZAirwolf, Bruno Almeida, Marc Cousin, Thomas Reiss, Rodolphe Quiedeville, Himanchali, Guilhem Rambal, Shanzhang Lan, Xavier Millies-Lacroix, Kong Man, wmorancfi, flopma and birkosan.

pgBadger is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly on our mailing list.

Links :

About pgBadger :

pgBagder is a new generation log analyzer for PostgreSQL, created by Gilles Darold (also author of ora2pg, the powerful migration tool). pgBadger is a fast and easy tool to analyze your SQL traffic and create HTML5 reports with dynamics graphs. pgBadger is the perfect tool to understand the behavior of your PostgreSQL servers and identify which SQL queries need to be optimized.

Docs, Download & Demo at http://dalibo.github.io/pgbadger/

About DALIBO :

DALIBO is the leading PostgreSQL company in France, providing support, trainings and consulting to its customers since 2005. The company contributes to the PostgreSQL community in various ways, including : code, articles, translations, free conferences and workshops

Check out DALIBO's open source projects at http://dalibo.github.io

Categories: Database, Open Source

PostgreSQL updates 9.3.5, 9.2.9, 9.1.14, 9.0.18, and 8.4.22 released

Thu, 07/24/2014 - 01:00

The PostgreSQL Global Development Group has released an update to all supported version of the database system, including versions 9.3.5, 9.2.9, 9.1.14, 9.0.18, and 8.4.22. This minor release fixes a number of issues discovered and reported by users over the last four months, including some data corruption issues, and is the last update of version 8.4. Users of version 9.3 will want to update at the earliest opportunity; users of version 8.4 will want to schedule an upgrade to a supported PostgreSQL version.

Among the notable issues fixed in this release are:

PostgreSQL 9.3 and pg_upgrade: Users who upgraded to version 9.3 using pg_upgrade may have an issue with transaction information which causes VACUUM to eventually fail. These users should run the script provided in the release notes to determine if their installation is affected, and then take the remedy steps outlined there.

PostgreSQL 9.3 crash recovery: Three issues which could compromise data integrity during crash recovery on master or standby servers in PostgreSQL 9.3 have been fixed.

GIN and GiST indexes: Three issues with GIN and GiST indexes, used for PostGIS and full text indexing, can cause corruption or incorrect query responses. Any indexes on bit or bit varying columns should be rebuilt following the instructions in the release notes.

Security during make check: The insecure socket permissions during "make check", reported in a previous security announcement, have now been fixed.

With this release, version 8.4 is now End-of-Life (EOL), per our Versioning Policy. This means that no additional updates will be released for version 8.4, and users should plan to upgrade to a later version very soon.

In addition the above, this update release includes the following fixes which affect multiple PostgreSQL versions:

  • Fix race condition with concurrent tuple updating
  • Prevent "could not find pathkey item to sort" planner error
  • Properly optimize subqueries with set-returning functions
  • Repair planner regression in optimizing AND/OR NULL
  • Fix planner handling of VARIADIC functions
  • Make json_populate_recordset handle nested JSON properly
  • Prevent corruption of TOAST values when creating complex types
  • Prevent "record type has not been registered" query error
  • Fix a possible crash condition with functions and rewinding cursors
  • Patch three memory leaks
  • Fix row checks for rows deleted by subtransactions
  • Change how pg_stat_activity displays sessions during PREPARE TRANSACTION
  • Prevent multixact ID corruption during VACUUM FULL
  • Fix indentation when displaying complex view definitions
  • Fix client hostname lookup in pg_hba.conf
  • Fix libpython linking on OSX
  • Avoid buffer bloat in libpq
  • Fix an issue with dumping materialized views
  • Fix pg_upgrade's handling of multixact IDs
  • Make sure that pgcrypto clears sensitive information from memory
  • Time zone updates for Crimea, Egypt, and Morocco

Four Windows-specific fixes are included in this release:

  • Prevent tablespace creation recovery errors
  • Fix detection of socket failures
  • Allow users to change parameters after startup
  • Properly quote executable names so they don't fail

A few of the issues above require post-update steps to be carried out by affected users. Please see the release notes for details.

As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

Links:

Categories: Database, Open Source

PostgreSQL 9.4 Beta 2 Released

Thu, 07/24/2014 - 01:00

The PostgreSQL Global Development Group has made available the second beta release of PostgreSQL 9.4. This beta contains previews of all of the features which will be available in version 9.4, plus corrections for many of the issues discovered by users who tested 9.4 Beta 1. Please download, test, and report what you find.

Among the changes made since 9.4 Beta 1 are:

  • Fix handling of two-phase commit and prepared statements for logical decoding
  • Multiple fixes for bugs in pg_recvlogical
  • Change slot handling logic for replication slots
  • Add support for BSD and e2fsprogs UUID libraries.
  • Multiple jsonb bug fixes
  • Remove use_json_as_text options from json functions
  • Make json_build_* functions STABLE instead of IMMUTABLE
  • Prevent ALTER SYSTEM from changing the data directory
  • Prevent autovacuum-related crash
  • Many documentation improvements and changes

Beta 2 includes changes to pg_control and to the system catalogs. As such, users who have been testing Beta 1 will need to upgrade in order to test Beta 2. We suggest using pg_upgrade for this upgrade in order to test that as well.

For a full listing of the features in version 9.4 Beta, please see the release notes. Additional descriptions and notes on the new features are available on the 9.4 Features Wiki Page.

We depend on our community to help test the next version in order to guarantee that it is high-performance and bug-free. Please download PostgreSQL 9.4 Beta 2 and try it with your workloads and applications as soon as you can, and give feedback to the PostgreSQL developers. Features and APIs in Beta 2 will not change substantially before final release, so it is now safe to start building applications against the new features. More information on how to test and report issues

Get the PostgreSQL 9.4 Beta 2, including binaries and installers for Windows, Linux and Mac from our download page.

Full documentation of the new version is available online, and also installs with PostgreSQL.

Categories: Database, Open Source