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

Call for Papers, PostgreSQL Session #7, September, 24th

Mon, 04/20/2015 - 01:00

After six successful sessions dedicated to the new features of PostgreSQL 9.0 (February 2011), to PostGIS (June 2011 & September 2014), to replication systems (February 2012), to migration from Oracle to PostgreSQL (October 2012), and to PostgreSQL performance (March 2013), we'd like to announce that the 7th PostgreSQL Session will be held on September 24th, 2015, in Paris, France.

This year, another place, but always the same format! This day of lectures will be dedicated especially to the next version of PostgreSQL, but not exclusively!

For more information, see

We're launching a call for papers for this event. You may now submit your talks, in English or in French. Each talk should last 30 minutes (questions included). We are interested in any talks on the following subjects:

  • What's New in PostgreSQL
  • Use cases
  • Migration to PostgreSQL
  • Performance Tuning
  • Backup and Restore
  • High-Availibity
  • Data Warehouse / Big Data
  • PostGIS

Talks can be either: a case study, a Proof of Concept, a tutorial, a benchmark, a presentation of a new feature, etc. Of course, we're open to propositions on any other migration related topics (monitoring, hardware, replication, etc.) !

The submission deadline is June 15, 2015.

You can now send your proposals to

Please give us a little information about yourself and your talk, such as:

  • First Name and Last Name
  • Twitter Account (if any)
  • Company
  • Short Biography (contributions to the PostgreSQL community)
  • Talk title
  • Talk abstract
  • Any specific needs

Slides should have a free licence (Creative Commons BY-ND 3.0 or compatible), and sent to Dalibo.

This day will be filmed, and all the lectures will be recorded and published after the Session. By sending a proposal, you agree to be recorded and waive any compensation for it.

The selected speakers not living in France will be reimbursed for travel and one night accomodation.

See you in Paris in September!

About the PostgreSQL Sessions:

The PostgreSQL sessions are designed to be a time to discover and meet the PostgreSQL community. Each session is a single day consisting of lectures, organized around a specific theme and a guest. The proposed talks aimed at all levels and all profiles: Developer, Administrator, Project Managers, IT Managers, ...

Entry is free and open to all, within the limits of available seats.

About Dalibo:

Since 2005, Dalibo is the leading French PostgreSQL company and provides its experience and expertise to its clients in Europe. The company delivers a full range of PostgreSQL services: Training, Development, Performance Tuning, High Availibilty setup, Oracle to PostgreSQL migration, Troubleshooting, and PostgreSQL support.

Categories: Database, Open Source

PostgreSQL Maestro 15.4 released

Thu, 04/09/2015 - 01:00

SQL Maestro Group announces the release of PostgreSQL Maestro 15.4, 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. Tablespace Editor now displays objects belonging to the tablespace.
  2. SQL Formatter now supports WITH queries, queries with the RETURNING clause and LATERAL JOINs.
  3. Adding new values to existing ENUM types.
  4. ALTER SYSTEM statement on changing the value of a server variable.
  5. Executing custom SQL scripts in all database connections established by the software.
  6. Support for a number of new encryption algorithms in data grids.
  7. Colored tabs and more informative tab hints.
  8. Updated Data Export and Data Import tools.
  9. Improved Data Input Form.
  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

PostgreSQL Data Sync 15.3 released

Thu, 03/26/2015 - 01:00

SQL Maestro Group announces the release of PostgreSQL Data Sync 15.3, a powerful and easy-to-use tool for PostgreSQL database contents comparison and synchronization.

The new version is immediately available at

Top 5 new features:
  1. An ability to select or disable certain synchronization operations (Insert, Update, and Delete) has been implemented. The corresponding command line switches have been added as well.
  2. Now it is possible to specify SQL scripts to be executed before and/or after synchronizing data of each table.
  3. Synchronization script file name and log file name are now stored in the project file. These settings can be overwritten with the appropriate command line options.
  4. The first page of the wizard has been redesigned in order to provide more comfortable access to recently opened projects and display the latest company news.
  5. The progress windows are redesigned in the modern style and become more informative.

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

Categories: Database, Open Source

PostgresOpen 2015 in Dallas - Call For Papers!

Tue, 03/17/2015 - 01:00

The Call For Papers for PostgresOpen 2015, being held in Dallas, Texas from September 16th to 18th, is now open!

If you are working with PostgreSQL, please visit and submit a talk!

We're looking for presentations on any topic related to PostgreSQL including, but not limited to, case studies, experiences, tools and utilities, migration stories, existing features, new feature development, benchmarks, performance tuning, and more!

We look forward to bringing the best PostgreSQL presentations and tutorials from speakers around the world to the first multi-day PostgreSQL conference in Texas!

Anyone and everyone in the PostgreSQL community is encouraged to submit a talk. Talks will be accepted up until May 17th, Anywhere on Earth (AoE), also known as: 2015-05-17 23:59:59-12:00.

Speakers will be notified by June 1, 2015 AoE, with the schedule to be published once selected speakers have confirmed.

Early Bird registration for PostgresOpen 2015 will start on May 4th.

We look forward to seeing everyone in Dallas!

Any questions? Please contact:

Categories: Database, Open Source

Registration for PGConf US 2015 Closing Soon. Very Soon.

Tue, 03/17/2015 - 01:00

If you've waited until the last minute to come to PGConf US 2015, that minute has arrived.

In only a week, registration will be closed for PGConf US 2015. PGConf US 2015 is taking place from March 25 - 27 and the New York Marriott Downtown in New York City, and is hosted by the United States PostgreSQL Association.

If you have not already, we invite you to review our schedule at This year we have 4 tracks of talks, including a track focusing just on PostGIS and its applications.

We could not produce PGConf US 2015 without the generous support of our sponsors, including our platinum sponsors EnterpriseDB, 2ndQuadrant, and Citus Data, and our gold sponsors Amazon Web Services and Airfacts.

We hope to see you in a week!

Categories: Database, Open Source

Database .NET 14.7 released

Fri, 03/13/2015 - 01:00

I am happy to announce the new major release of Database .NET 14.7, 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, Single executable file and Multi-language.

Major New features from version 14.1 to 14.7:

  • Updated to Npgsql.dll 2.2.5
  • Added My Favorites
  • Added Specifying dynamic variables
  • Added Specifying specific printers
  • Added Pin to Start Menu and Pin to Taskbar
  • Added Default placeholders
  • Added Hiding and Unhiding columns
  • Added Moving Row Up and Down for Cell Viewer and Form Viewer
  • And more...
The new version is immediately available for download.
Categories: Database, Open Source

Meet the PostgresDAC v3.0.0

Wed, 03/04/2015 - 01:00
We've released our new major version of PostgresDAC component suite. It’s been a long way started almost two years ago. The goals were complicated, and not all of them were accomplished. However, in general we may proudly say without a doubt that this release is a significant milestone. Dump and restore functionality

TPSQLDump and TPSQLRestore components is a pair that is one of a kind on the whole market. There are no more such facilities not only in the Delphi or C Builder world, but for any other IDE's or toolchains. That is why our first goal was to keep this classes up to date. A huge amount of work was done and a year ago the brand new v3 TPSQLDump and TPSQLRestore components were published as part of v2.11.0 release.

TPSQLDump and TPSQLRestore are fully compatible with native pg_dump and pg_restore utilities. Each and every native feature is supported out of the box:

  • output formats (binary, text, directory, gzipped),
  • parallel dumping and restoring,
  • comprehensive selection, filtering and reordering of archived items,
  • SQL-92 specific output options, etc.
Asynchronous Fetch-On-Demand mode

The default TPSQLQuery's mode is suitable for submitting commands and getting result sets in normal, synchronous applications. However, there are few drawbacks, that may be of importance to developers:

  • TPSQLQuery.Open waits for the command to be completed. The application might have other work to do (such as maintaining a user interface), in which case it won’t be a good decision to block while waiting for a response.
  • Since the execution of the client application is suspended while it waits for the result, it is hard for the application to decide that it would like to try to cancel the ongoing command.
  • TPSQLQuery in default mode always collects a command's entire result, buffering it in a single place. While this behavior simplifies some internal logic, it can be impractical for results containing many rows.

To avoid such limitations developers now can use the brand new Fetch-On-Demand mode, which is turned on by dsoFetchOnDemand option in the TPSQLQuery.Options set. There are limitations of course:

  • To get advantages of the Fetch-On-Demand mode one should use read-only TPSQLQuery objects. This restriction will be removed with time probably.
  • Each read-only TPSQLQuery component must have its separate TPSQLDatabase component since Fetch-On-Demand command flow will block a connection until getting the last row of the result set.
Support for built-in range and geometric field types

Previously these specific types were mapped to TStringField class. Now PostgresDAC provides new TField descendants for this:

  • TPSQLRangeField
  • TPSQLPointField
  • TPSQLCircleField
  • TPSQLBoxField
  • TPSQLLSegField

All of them will be created automatically if needed, or may be added manually in design time.

TPSQLRangeField encapsulates all built-in PostgreSQL range types: int4range, int8range, numrange, tsrange, tstzrange and daterange. Information about range value is stored in the TPSQLRange record by storing values for each bound using TPSQLRangeBound record. Depending on the underlying table field type developer may access bound values using appropriate methods AsInteger, AsFloat, etc.

Enhanced Manual

We've finished the new help system. It's rewritten it from scratch. Support for such formats provided:

  • chm,
  • pdf.
  • epub (in progress).
Full changelog:
  • [!] Fetch-On-Demand mode introduced for readonly TPSQLQuery objects
  • [!] Support for geometric types added
  • [!] TPSQLRangeField added
  • [!] Support for pre-8.0 PostgreSQL servers is discontinued
  • [!] v9.4.0 client libraries added
  • [!] v9.4.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [*] Components TPSQLUser and TBDE2PSQLDAC marked as deprecated and will be removed shortly
  • [*] EPSQLDatabaseError is raised if TPSQLDatabase is used in non-exclusive mode for TPSQLQuery with dsoFetchOnDemand
  • [*] TPSQLDatabase.CancelBackend checks for connection now to prevent AV
  • [-] "AV may occur if SQL parameter name consists from incorrect characters chain" bug fixed
  • [-] "EPSQLDatabaseError detail error properties are empty after error in TPSQLDirectQuery.Open" bug fixed

You're welcome to download the PostgresDAC v3.0.0 right now at: or login to your private area on our site at


Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at

Categories: Database, Open Source

Fujitsu Develops Column-Oriented Data-Processing Engine that accelerates analytic processing more than fifty-fold on a single server with PostgreSQL open-source database

Tue, 03/03/2015 - 01:00

Fujitsu Laboratories Ltd. today announced that it has developed a column-oriented data-storage and processing engine that enables fast analysis of large volumes of data in a database system.

In recent years, column-oriented databases have emerged as a system that allows for better speed when reading and analyzing large volumes of data, as a counterpart to existing row-oriented databases, which are suited to handling data updates. But problems have been either that the changes to row-oriented data cannot be automatically reflected in column-oriented data, or that the size of the column-oriented data is constrained by installed memory.

Fujitsu has developed an engine that, running on a PostgreSQL open-source database, without being dependent on memory capacity, instantly updates column-oriented data in response to changes in row-oriented data, and processes column-oriented data quickly. The engine quickly analyzes indexes(1), which are provided by most database systems, and can be used by developers without special consideration to whether the storage method is row-oriented or column-oriented. With a parallel-processing engine especially suited for processing column-oriented data, analyses run on a single CPU core are conducted 4 times faster than before, and one server equipped with 15 CPU cores can run analyses at least 50 times faster.

For more information please visit

Categories: Database, Open Source

PoWA 2: Finding the Missing Index !

Mon, 03/02/2015 - 01:00

Paris, March 2 2015

DALIBO is proud to present the second release of PoWA, the PostgreSQL Workload Analyzer.

Complete rewrite of the User Interface

The first major change is the new graphic design : we've rebuilt the web interface from scratch and placed it on a separate module called powa-web. It is now easier to move the PoWA interface out of the database server.

The new interface is based on the previous version and it adds many improvements, including:

  • More graphs
  • New types of graph : Bar / Pie Charts
  • New configuration view
  • New index suggestion widget
  • New physical resource consumption graphs
  • Better Global Query Chart
  • Breadcrumbs
  • Python 2.6, 2.7 and 3.4 compatibility
  • Better browser compatibility



Advanced Filesystem Stats

Second, the core-engine of PoWA is now a separate module too: it's called powa-archivist and we've extended it to archive any kind of internal stats. The main source of stats remains the pg_stat_statements extension but we've integrated 2 other extensions: pg_qualstats and pg_stat_kcache.

With pg_stat_kcache, PoWA is now able to gather statistics about the physical disk access and the CPU consumption of each PostgreSQL backend. This allows the DBA to get a glimpse of the OS-level cache hit ratio.


Missing Index Finder + Advanced WHERE Clause Analyzer

Third major improvement, with pg_qualstats PoWA is now collecting metrics about the operations in the WHERE clause of each query. With this data, you can know what are the most common values in your SQL statements and evaluate their "selectivity". And for columns with a very high selectivity and no index, PoWA will suggest index creation to speed up you queries.


Disruptive changes

It was a hard choice but if we want to implement ground-breaking features like the Missing Index Finder, we need to use the latest capacities of PostgreSQL and thus we decided to drop the compatibility with PostgreSQL 9.3.

Of course, we will continue to maintain PoWA v1.2 and you can continue to use it on your PostgreSQL 9.3 servers. In a nutshell, If you already use PoWA here's what you need to know:

  • If you're running PostgreSQL 9.4, we recommend that you switch to PoWA 2.0
  • If you're running PostgreSQL 9.3, you can either keep PoWA 1.2 or upgrade your PostgreSQL instance and switch to PoWA 2.0


Here's a detailed explanation on why we are Moving Fast and Breaking Things

Credits & Licence

DALIBO would like to thank all the developers who contributed to this release: Rodolphe Quiedeville, Hyunjun Kim, Grégoire Pineau, Ahmed Bessifi, exordium-frozen, Christopher Liu, menardorama and especially Ronan Dunklau 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

Links :

For PoWA 2.0:


For the new stats extensions:


For the complete list of changes, please checkout the release note on

About POWA :

PoWA is a 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

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

Categories: Database, Open Source

PostgreSQL 9.4.1, 9.3.6, 9.2.10, 9.1.15 & 9.0.19 Released

Thu, 02/05/2015 - 01:00

The PostgreSQL Global Development Group has released an important update with fixes for multiple security issues to all supported versions of the PostgreSQL database system, which includes minor versions 9.4.1, 9.3.6, 9.2.10, 9.1.15, and 9.0.19. This update includes both security fixes and fixes for issues discovered since the last release. In particular for the 9.4 update, there is a change to the way unicode strings are escaped for the JSON and JSONB data types.

All users should update their PostgreSQL installation at the next opportunity.

Security Fixes

This update fixes multiple security issues reported in PostgreSQL over the past few months. All of these issues require prior authentication, and some require additional conditions, and as such are not considered generally urgent. However, users should examine the list of security holes patched below in case they are particularly vulnerable.

  • CVE-2015-0241 Buffer overruns in "to_char" functions.
  • CVE-2015-0242 Buffer overrun in replacement printf family of functions.
  • CVE-2015-0243 Memory errors in functions in the pgcrypto extension.
  • CVE-2015-0244 An error in extended protocol message reading.
  • CVE-2014-8161 Constraint violation errors can cause display of values in columns which the user would not normally have rights to see.

This update also fixes the previously reported problem that, during regression testing on Windows, the test postmaster process was vulnerable to unauthorized connections. This vulnerability was fixed on non-Windows platforms in the prior update releases.

More information about these issues, as well as older patched issues, is available on the PostgreSQL Security Page.

JSON and JSONB Unicode Escapes

The handling of Unicode escape strings for JSON and JSONB in PostgreSQL 9.4.0 has been changed in a way which may break compatibility for some users. To fix some inconsistencies, type JSONB no longer accepts the escape sequence "\u0000". Type JSON accepts "\u0000" only in contexts where it does not need to be converted to de-escaped form. See the release notes for more detail.

Other Fixes and Improvements

In addition to the above, more than 60 reported issues have been fixed in this cumulative update release. Some of them affect only version 9.4, but many of them fix problems present in older versions. These fixes include:

  • Cope with the non-ASCII Norwegian Windows locale name.
  • Avoid data corruption when databases are moved to new tablespaces and back again.
  • Ensure that UNLOGGED tables are correctly copied during ALTER DATABASE operations.
  • Avoid deadlocks when locking recently modified rows.
  • Fix two SELECT FOR UPDATE query issues.
  • Prevent false negative for shortest-first regular expression matches.
  • Fix false positives and negatives in tsquery contains operator.
  • Fix namespace handling in xpath().
  • Prevent row-producing functions from creating empty column names.
  • Make autovacuum use per-table cost_limit and cost_delay settings.
  • When autovacuum=off, limit autovacuum work to wraparound prevention only.
  • Multiple fixes for logical decoding in 9.4.
  • Fix transient errors on hot standby queries due to page replacement.
  • Prevent duplicate WAL file archiving at end of recovery or standby promotion.
  • Prevent deadlock in parallel restore of schema-only dump.

In addition to the fixes above, the following contrib modules and extensions have had bugs fixed in this release: pg_upgrade, auto_explain, hstore, pageinspect, pgcrypto, pg_test_fsync, tablefunc, and xml2. Also, multiple functions across several contrib modules have been modified with the correct level of volatility. There are also multiple cleanup fixes based on minor issues found by the Coverity Scan static analyzer.

This update also contains many changes to PostgreSQL's timezone files. This includes an update to tzdata release 2015a, with updates to Chile, Mexico, Caicos Islands, and Fiji. PostgreSQL now takes date into account when assigning an offset based on a timezone abbreviation for historically changeable timezones. We have also done a general cleanup on timezone abbreviations, and added "CST" as an abbreviation for China Standard Time.

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: * Download * Release Notes * Security Page

Categories: Database, Open Source

PostgreSQL codeless sync with Office 365, SharePoint, Exchange, Dynamics and others

Tue, 01/27/2015 - 01:00

Layer2, one of the leading providers of codeless data integration and synchronization tools in Europe, has announced full PostgreSQL support for their Cloud Connector.

You will find more Information here:

Categories: Database, Open Source

Nordic PGDay 2015 - registration open and schedule posted

Mon, 01/26/2015 - 01:00

Nordic PGDay 2015 will be held in Copenhagen, Denmark, at the Radisson Blu Falconer hotel in Fredriksberg, on March 11. It will feature a full day with a single track of PostgreSQL presentations from both Nordic and global PostgreSQL experts, covering a wide range of topics.

The schedule has now been posted, and is available on the website.

We have also opened up registration for the event. Early bird registration (before Feb 11th or the first 40 registrations) costs €40, and normal registration costs €60. There is a limited number of seats available, so we suggest you register early to make sure you get a seat.

We also still have openings for Supporter sponsorship, which includes free entrance to the conference. For more information and instant sign-up.

We look forward to seeing you in Copenhagen in March!

Categories: Database, Open Source

Barman 1.4.0 released

Mon, 01/26/2015 - 01:00

26 January 2015: 2ndQuadrant is proud to announce the release of version 1.4.0 of Barman, Backup and Recovery Manager for PostgreSQL.

This major release features file-level incremental backup, a kind of full periodic backup which saves only data changes from the latest full backup available in the catalogue for a specific PostgreSQL server. Depending on the context and the database workload, the data deduplication ratio might easily reach 50-70% per full backup, leading to significant reductions in both backup time and disk space.

PostgreSQL 9.4 users will transparently benefit from the integration of Barman with "pg_stat_archiver" view. In particular, any continuous archiving problem will be immediately spotted by the "barman check" command directly on the source.

Management of WAL files has been improved, by optimising the calculation of WAL statistics, tying archiving with backup and by distinctively managing WAL trashing for exclusive and concurrent backups.

Relevant efforts in unit testing have made the code more robust. Minor bugs have also been fixed.

Many thanks for funding towards the development of this release go to BIJ12 (, Jobrapido (, Navionics (, Sovon Vogelonderzoek Nederland (, and (

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

Incremental backup

Incremental backup is a kind of full periodic backup which saves only data changes from the latest full backup available in the catalogue for a specific PostgreSQL server. The main goals of incremental backup in Barman are:

  • Reduce the time taken for the full backup process
  • Reduce the disk space occupied by several periodic backups (data deduplication)

This feature heavily relies on "rysnc" and hard links, which must be therefore supported by both the underlying operating system and the file system where the backup data resides.

The main concept is that two periodic base backups will share those files that have not changed, leading to relevant savings in disk usage. This is particularly true of VLDB contexts and, more in general, of those databases containing a high percentage of read-only historical tables. Barman implements incremental backup through a global/server option, called "reuse_backup", that transparently manages the "barman backup" command. Behaviour can also be changed at runtime through the "--reuse-backup" runtime option for the "barman backup" command.


Release notes

  • Incremental base backup implementation through the "reuse_backup" global/server option. Possible values are "off" (disabled, default), "copy" (preventing unmodified files from being transferred) and "link" (allowing for deduplication through hard links).
  • Store and show deduplication effects when using "reuse_backup=link".
  • Added transparent support of pg_stat_archiver (PostgreSQL 9.4) in "check", "show-server" and "status" commands.
  • Improved administration by invoking WAL maintenance at the end of a successful backup.
  • Changed the way unused WAL files are trashed, by differentiating between concurrent and exclusive backup cases.
  • Improved performance of WAL statistics calculation.
  • Treat a missing pg_ident.conf as a WARNING rather than an error.
  • Refactored output layer by removing remaining "yield" calls.
  • Check that rsync is in the system path.
  • Include history files in WAL management.
  • Improved robustness through more unit tests.
  • Fixed bug #55: Ignore fsync EINVAL errors on directories.
  • Fixed bug #58: retention policies delete.



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, incremental backup, 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

PGConf US 2015 Schedule & Early-Bird Registration Open

Fri, 01/23/2015 - 01:00

Debates abounded; coffee drunk; phone calls made at 8:30am on Saturday mornings; reporting queries run (of course in PostgreSQL). After reviewing 107 submissions, we are pleased to announce the PGConf US 2015 official schedule:

PGConf US 2015 is taking place in New York City from March 25-27 at the New York Marriott Downtown. We are offering a day of trainings on March 25 in addition to the First Annual Regulated Industry Summit as well as our regular sessions on March 26-27.

There are so many cool sessions (in fact, we added on another track!) that it is hard to highlight everything, but here is a small glimpse of what to expect:

  • Large-scale PostgreSQL deployment case-studies from organizations such as TripAdvisor, Braintree, Children's Hospital of Philadelphia, Zalando, Stony Brook Medicine, and more
  • Theory and applications of those cutting-edge PostgreSQL features, such as JSONB, logical replication, row-level security, and BDR
  • Analyzing all of the latest PostgreSQL deployment options, from bare metal to cloud-based infrastructures
  • A "PostGIS Track" on March 26, featuring key contributors from the PostGIS & PostgreSQL community
  • How to optimize every single I/O op with talks from preeminent PostgreSQL performance experts
  • ...and why not "Fight for Small Data" with a variety of strategy talks

Our early-bird registration is open and tickets at the early bird rate are available through February 1, 2015. Tickets can be purchased directly from here:

PGConf US 2015 is hosted by the United States PostgreSQL Association, a nonprofit 501(c)(3) created to support PostgreSQL in the United States through user group development, conferences, educational initiatives, and fun. We would not be able to produce PGConf US without the generous support of our sponsors. We would like to highlight our Platinum and Gold sponsors:

For more information, please visit

We look forward to hosting you in March!

Categories: Database, Open Source

PoWA 1.2.1 released

Tue, 01/20/2015 - 01:00

Paris, Jan. 20 2015

DALIBO is proud to present a new release of PoWA, a performance tool for PostgreSQL.

Please also note that the project has a new dedicated mailing list, available at (!forum/powa-users)

Feel free to join and ask any question.

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

New features and changed in UI
  • UI is now compatible with mojolicious 5.0 and more
  • UI can now connect to multiple servers, and credentials can be specified for each server
  • The timestamps are now displayed in ISO 8601 format
  • POWA_CONFIG_FILE variable has been added to allow a specific config file location and/or name
  • Better charts display on smaller screens

DALIBO would like to thank the users and developpers who contributed to this release, especially Ahmed Bessifi and Luis Pinto Da Costa.

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 to (!forum/powa-users)

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


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

Categories: Database, Open Source

ByteDesigner version 2.3 is available

Sun, 01/11/2015 - 01:00

NipData, the provider of data modeling, presentation and integration software, is very pleased to announce the release of ByteDesigner 2.3.

See the entire news here:

ByteDesigner is the emerging enterprise tool for designing databases at all levels of an organization, using the same concepts found in tools costing thousands of dollars!

Its a powerful database design tool, with advanced SQL Editor, and support for all major RDBMS, that can design complex systems.

Online documentation is found here:

Supported platforms (13): Linux (Intel and PowerPC), Solaris(Intel and Sparc), Windows (Intel),
Mac OS X(Intel and PowerPC)
for both 32 and 64 bit.

Databases supported (9): Oracle, ODBC, SQL92, MySQL, PostgreSQL, DB2, FireBird, MS SQL, SQLBase

Categories: Database, Open Source

DBD::Pg 3.5.0 released

Wed, 01/07/2015 - 01:00

The latest version of DBD::Pg, the Perl driver for Postgres, has been released. This version includes a much improved ping() method, and support for the new backslash-escaped placeholders, which will make working with things such as JSON much easier. The latest version can always be found on CPAN.

Categories: Database, Open Source