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: 7 hours 30 min ago

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

MicroOLAP Database Designer for PostgreSQL v1.10.0 is out

Fri, 07/04/2014 - 01:00

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL v1.10.0, an comprehensive CASE tool with intuitive graphical interface allowing you to

  • build a clear and effective database structure visually,
  • see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects,
  • easily generate a physical database on a server,
  • modify it according to any changes you made to the diagram using fast ALTER statements,
  • import already existing diagram from a server,
  • export diagram to common graphic formats or as SQL script,
  • create detailed printings and reports.
This release introduces support for the latest v9.4 SQL grammar as well as improved support for inheritance functionality. Modify Engine allows mark constraints as NOT VALID. Several non critical bugs fixed. Download

You're welcome to download the Database Designer for PostgreSQL 1.10.0 right now at: http://microolap.com/products/database/postgresql-designer/download/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full changelog:
  • [!] SQL Executor and Validator support v9.4 grammar now
  • [!] Support for table inheritance improved dramatically
  • [+] "Always make PK columns first" option introduced in Diagram Options
  • [+] Allow CHECK constraints to be declared NOT VALID in Modify script
  • [+] Allow FOREIGN KEY constraints to be declared NOT VALID in Modify script
  • [+] Shortcut for "Save As.." and "Export" menu items added
  • [+] SQL keywords are properly highlighted according to 9.4 version
  • [*] Comments now shown at Preview tab of Table Editor by default
  • [*] Handling of incorrect file paths improved in Generate and Modify Database
  • [*] Merging of reversed user types with existing in model improved during Reverse Engineering
  • [-] "Changing domain schema doesn't affect table representation where domain used" bug fixed
  • [-] "Changing some options in the Model Options doesn't activate OK & Apply buttons" bug fixed
  • [-] "Column default values containing backslashes are corrupted after reloading model" bug fixed
  • [-] "Leak proof option doesn't shown in the Function editor after reopen" bug fixed
  • [-] "LEAKPROOF attribute causes syntax error in the SQL Executor" bug fixed
Categories: Database, Open Source

PGConf.EU 2014 Now Open for Registration

Tue, 07/01/2014 - 01:00

PostgreSQL Conference Europe 2014 in Madrid, Spain, on October 21st - 24th, is now open for registration!

PGConf.EU is the largest PostgreSQL dedicated conference in the world, with three packed days of sessions ranging from beginner level to advanced sessions about database internals, and more than 250 attendees.

The 2014 edition is now open for registration to all attendees. Register before September 15 and receive 20% Early Bird discount! We recommend attendees to register as early as possible, since the conference often sells out!

There will be a full day of training sessions on October 21st, the day before the main conference, held by well known teachers from the PostgreSQL community. These sessions are ordered at registration, and are also available for order now. The training sessions are held in smaller groups, and may sell out quickly, so we suggest that anybody who wish to attend the training register early!

To register, access the registration form on the website.

We'd also like to remind you that our call for papers is still open, where we are looking for even more interesting presentations for the conference. Speakers of the conference receive free attendance, so make sure to submit your ideas!

We look forward to seeing you in Madrid!

Categories: Database, Open Source

PgBackMan 1.0.0 released

Thu, 06/26/2014 - 01:00

Oslo, Norway - June 26,2014

We are proud to announce the first release available to the public of PgBackMan - PostgreSQL backup manager.

About PgBackMan

PgBackMan is a tool for managing PostgreSQL logical backups created with pg_dump and pg_dumpall.

It is designed to manage backups from thousands of databases running in multiple PostgreSQL nodes, and it supports a multiple backup server topology.

The PgBackMan code is distributed under the GNU General Public License 3 and it is written in Python and PL/PgSQL. It has been developed and tested by members of the Database Operations Group at the Center for Information Technology at the University of Oslo.

Main Features
  • Central database with metadata information.
  • PgBackMan shell for interaction with the system.
  • Management of multiple backup servers.
  • Management of multiple PostgreSQL servers.
  • Management of thousands of backups dumps through a catalogue.
  • Manual and scheduled backups.
  • Management of retention policies for backups.
  • Fully detailed backup reports.
  • Multiple predefined database backup types, CLUSTER,FULL,SCHEMA,DATA.
  • Full backup of role information for a database.
  • Full backup of database configuration for a database.
  • Automatic definitions of backups for all databases running in a PgSQL node.
  • Automatic restore procedures.
  • Autonomous pgbackman_dump program that functions even if the central database with metadata information is not available.
  • Handling of error situations.
Categories: Database, Open Source

Bucardo 5 released

Mon, 06/23/2014 - 01:00

Version 5 of Bucardo, a multi-source, multi-target replication system for PostgreSQL has been released. You can find more information about the release here:

http://blog.endpoint.com/2014/06/bucardo-5-multimaster-postgres-released.html

For more information on how to download Bucardo, please visit:

http://bucardo.org/wiki/Bucardo

Checksums for the tarball:

d87d109c1cba300d074603b2dd4d1019302acdfd Bucardo-5.0.0.tar.gz f4e68f473a4669d465d0d8f23910d4b3 Bucardo-5.0.0.tar.gz

Categories: Database, Open Source

Admin4 V2.1.4 featuring PostgreSQL module released

Thu, 06/05/2014 - 01:00

The new Admin4 release is the first to contain a greatly enhanced PostgreSQL module. It includes:

  • Object browser with Favourites
  • Query tool with Snippets, sql text fragments stored for frequent usage
  • Data tool for table data modification, with Presets to remember frequently used data retrieval filters.

Favourites, Snippets and Presets are stored centrally in the database, making them available for roaming usage. Your day-to-day code snippets, standard filters and frequently used objects are right there no matter which workstation you're using to maintain the database.

Download it here from sourceforge, it's free (Apache2 licensed). Contributors/testers for this fresh project are welcome!

Categories: Database, Open Source

Postgres Open 2014 Early Bird Tickets and Tutorials on Sale!

Thu, 06/05/2014 - 01:00

The 2014 Postgres Open Program Committee is pleased to announce the opening of Early Bird Tickets and Tutorial Registration sales.

Early Bird Tickets: Book early through July 6, 2014 to save $200 on your registration! Postgres Open has received such strong support from our community sponsors that we’re retaining our ticket prices from 2013 - no increase this year.

Conference Tutorials: We’ve brought in some new presenters and topics this year for our tutorial sessions held Wednesday, September 17th.

  • Adv. SQL + Functions - Joe Conway, Stephen Frost
  • Intro to PostGIS Core and Popular Add-ons - Regina Obe, Leo Hsu (a 2 part/full day session)
  • Writing and Using Extensions - Dimitri Fontaine

In addition, Heroku is offering a free platform tutorial covering dynos and their environment, buildpacks, deployment, releases, HTTP routing, add-ons, and of course Postgres.

Early Bird Tickets and All Tutorials can be purchased here: https://postgresopen.org/2014/tickets/

The CfP has been extended through Sunday June 8th: We’ve received some impressive submissions thus far, however a few of you have asked for some extra time, as such we’re giving you until this Sunday June 8. https://postgresopen.org/2014/callforpapers/

We look forward updating you in the coming weeks and with more speaker info and the presentations schedule for Postgres Open 2014!

Categories: Database, Open Source

PostgreSQL Maestro 14.5 released

Mon, 05/26/2014 - 01:00

SQL Maestro Group announces the release of PostgreSQL Maestro 14.5, a powerful Windows GUI solution for PostgreSQL database server administration and database development.

The new version is immediately available for download.

Top 10 new features:
  1. PostgreSQL 9.4 compatibility.
  2. Support for materialized views.
  3. Support for range types.
  4. Enhanced Function Editor.
  5. Updatable views generation.
  6. SQL Editor: support for DML statements with the RETURNING clause.
  7. Data import from several files to a single table.
  8. Advanced Column Builder for text files with fixed column width.
  9. Data export to the JSON format.
  10. Some performance and usability improvements.

There are also some other useful things. Full press release is available at the SQL Maestro Group website.

Categories: Database, Open Source

DBD::Pg 3.2.1 released

Sun, 05/25/2014 - 01:00

Version 3.2.1 of DBD::Pg, the Perl interface to Postgres, has just been released. For more information and to download please visit:

http://search.cpan.org/dist/DBD-Pg/

Categories: Database, Open Source

PostgreSQL 9.4 beta1 on Debian/Ubuntu

Fri, 05/16/2014 - 01:00

Yesterday saw the first beta release of the new PostgreSQL version 9.4. Along with the sources, we uploaded binary packages to Debian experimental and apt.postgresql.org, so there's now packages ready to be tested on Debian wheezy, squeeze, testing/unstable, and Ubuntu trusty, saucy, precise, and lucid.

If you are using one of the release distributions of Debian or Ubuntu, add this to your /etc/apt/sources.list.d/pgdg.list to have 9.4 available:

deb http://apt.postgresql.org/pub/repos/apt/ codename-pgdg main 9.4

On Debian jessie and sid, install the packages from experimental.

Happy testing!

Categories: Database, Open Source

PostgreSQL 9.4 Beta 1 Released

Thu, 05/15/2014 - 01:00

The PostgreSQL Global Development Group announced that the first beta release of PostgreSQL 9.4, the latest version of the world's leading open source database, is available today. This beta contains previews of all of the features which will be available in version 9.4, and is ready for testing by the worldwide PostgreSQL community. Please download, test, and report what you find.

Major Features

The new major features available for testing in this beta include:

  • JSONB: 9.4 includes the new JSONB "binary JSON" type. This new storage format for document data is higher-performance, and comes with indexing, functions and operators for manipulating JSON data.
  • Replication: The new Data Change Streaming API allows decoding and transformation of the replication stream. This lays the foundation for new replication tools that support high-speed and more flexible replication and scale-out solutions.
  • Materialized Views with "Refresh Concurrently", which permit fast-response background summary reports for complex data.
  • ALTER SYSTEM SET, which enables modifications to postgresql.conf from the SQL command line and from remote clients, easing administration tasks.

These features expand the capabilities of PostgreSQL, and introduce new syntax, APIs, and management interfaces.

Additional Features

There are many other features in the 9.4 beta, all of which need testing by you:

  • Dynamic Background Workers
  • Replication Slots
  • Write Scalability improvements
  • Aggregate performance improvements
  • Reductions in WAL volume
  • GIN indexes up to 50% smaller and faster
  • Updatable security barrier views
  • New array manipulation and table functions
  • Time-delayed standbys
  • MVCC system catalog updates
  • Decrease lock level for some ALTER TABLE commands
  • Backup throttling
  • WITHIN GROUP

There have also been many internal changes in the inner workings of the Write Ahead Log (WAL), GIN indexes, replication, aggregation, and management of the system catalogs. The means we need you to help us find any new bugs that we may have introduced in these areas before the full release of 9.4.

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.

Test 9.4 Beta 1 Now

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 1 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 1 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 1, 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

Postgres-XL Released: Scale-out PostgreSQL Cluster

Wed, 05/14/2014 - 01:00

TransLattice announces the availability of the release candidate for Postgres-XL, an open source, clustered, parallel SQL database designed for both OLTP and Big Data analytics.

The key capabilities of Postgres-XL include OLTP write scalability, massive parallel processing (MPP), cluster-wide ACID (atomicity, consistency, isolation, durability) properties and multi-tenant security.

Open access to Postgres-XL further extends the open source PostgreSQL ecosystem and offers additional choices to the community.

Postgres-XL is based on StormDB, the commercial product acquired by TransLattice in 2013. TransLattice will continue to actively contribute to Postgres-XL.

More information can be found at http://www.postgres-xl.org

The full press release of the announcement can be read here: http://www.translattice.com/pr/TransLattice_Launches_Postgres-XL_an_Open_Source_Database_Designed_for_OLTP_and_Big_Data_Analytics.shtml

Categories: Database, Open Source