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

Database .NET 14.0 released

Fri, 12/19/2014 - 01:00

I am happy to announce the new major release of Database .NET 14.0, 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 12.7 to 14.0:

  • Compatible with PostgreSQL 9.4
  • Compatible with Microsoft Windows 10
  • Updated to Npgsql.dll 2.2.3
  • Additional Features for all users (Autocomplete/Query Builder/SQL Profiler/Database Diagram/Cell and Form Editor)
  • Added Binding Procedure and Function parameters
  • Added Binding SQL variables
  • Added (De)Compression and (De)Encoding strings
  • Added [ADV] Advanced Browsing Options
  • Added [ADV] Advanced Edit Options
  • Added [ADV] Advanced Search Options
  • Added Column Properties
  • Added Exporting and Displaying Hexadecimal string
  • Added Restoring last object location
  • And more...
The new version is immediately available for download.
Categories: Database, Open Source

PostgreSQL 9.4 Increases Flexibility, Scalability and Performance

Thu, 12/18/2014 - 01:00

18 DECEMBER 2014: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.4, the latest version of the world's leading open source database system. This release adds many new features which enhance PostgreSQL's flexibility, scalability and performance for many different types of database users, including improvements to JSON support, replication and index performance.


With the new JSONB data type for PostgreSQL, users no longer have to choose between relational and non-relational data stores: they can have both at the same time. JSONB supports fast lookups and simple expression search queries using Generalized Inverted Indexes (GIN). Multiple new support functions enable users to extract and manipulate JSON data, with a performance which matches or surpasses the most popular document databases. With JSONB, table data can be easily integrated with document data for a fully integrated database environment.

"JSONB brings PostgreSQL to the JavaScript development community by allowing JSON data to be stored and queried natively. Node.js and other server-side JavaScript frameworks can benefit from the safety and robustness of PostgreSQL, while still storing data in the schema-less format that they prefer," said Matt Soldo, Product Manager, Heroku Postgres.


In 9.4, Logical Decoding supplies a new API for reading, filtering and manipulating the PostgreSQL replication stream. This interface is the foundation for new replication tools, such as Bi-Directional Replication, which supports the creation of multi-master PostgreSQL clusters. Other improvements in the replication system, such as replication slots and time-delayed replicas, improve management and utility of replica servers.

"The main reason behind our immediate adoption of PostgreSQL 9.4 in production is the new Logical Decoding feature," said Marco Favale, Cartographic Production Manager of Navionics. "The ability to write custom and flexible output plugins will allow us to transparently collect changes on selected tables and replicate changes where we like, by removing heavier - and more complex to manage - trigger based replication solutions."

"Zalando relies on the stability and performance of hundreds of PostgreSQL database servers to continuously serve millions of customers all around Europe," said Valentine Gogichashvili, Team Lead Database Operations at Zalando Technologies. "We are excited to run time-delayed standby servers which work out of the box, and will evaluate the new bi-directional replication tools as soon as they are released."


Version 9.4 also introduces multiple performance improvements which will allow users to get even more out of each PostgreSQL server. These include:

  • Improvements to GIN indexes, making them up to 50% smaller and up to 3X faster.
  • Concurrently updatable Materialized Views for faster, more up-to-date reporting.
  • Rapidly reload the database cache on restart using pg_prewarm.
  • Faster parallel writing to the PostgreSQL transaction log.
  • Support for Linux Huge Pages for servers with large memory.

"We will definitely benefit from concurrent refresh of materialised views, delayed standby servers (which will make our disaster recovery even more robust) as well as the usual performance improvements every new release carries on," added Marco Favale.

Links About PostgreSQL

PostgreSQL is the leading open source database system, with a global community of thousands of users and contributors and dozens of companies and organizations. The PostgreSQL Project builds on over 25 years of engineering, starting at the University of California, Berkeley, and has an unmatched pace of development today. PostgreSQL's mature feature set not only matches top proprietary database systems, but exceeds them in advanced database features, extensibility, security and stability. Learn more about PostgreSQL and participate in our community on our web page.

Categories: Database, Open Source

FOSDEM PGDay 2015 and Devroom - Schedule posted and registration open

Tue, 12/09/2014 - 01:00

We have finished the schedule for FOSDEM PGDay and the PostgreSQL Devroom at FOSDEM 2015 - our apologies for the delay in processing!

You will find a number of great talks both on PostgreSQL usage and development from great speakers. And of course, it will as usual feature the Hallway Track, where you can network with fellow PostgreSQL users!

We have also opened registration. Number of seats are limited, and as we sold out last year, we recommend that you make your reservation as soon as possible. Registration is €50 for all attendees for the PGDay on Friday. No registration is necessary if you only want to attend the Devroom at FOSDEM on Saturday.

Finally, we'd like to remind you that our rate with the conference hotel (Marriott Brussels) will expire on Dec 15th. Therefore, we recommend that you book your accommodations as soon as possible!

We hope to see you in Brussels in January!

Categories: Database, Open Source

PostgreSQL 9.4 RC1 Released

Thu, 11/20/2014 - 01:00

The PostgreSQL Global Development Group has released 9.4 RC 1, the first release candiate for the next version of PostgreSQL. This release should be identical to the final version of PostgreSQL 9.4, excepting any fixes for bugs found in the next two weeks. Please download, test, and report what you find.

For a full listing of the features in version 9.4, 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 RC 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 this release candidate should be identical to 9.4.0, allowing you to build and test your applications against it. More information on how to test and report issues

Get the PostgreSQL 9.4 RC 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

PostgreSQL PHP Generator 14.10 released

Wed, 11/05/2014 - 01:00

SQL Maestro Group announces the release of PostgreSQL PHP Generator 14.10, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your PostgreSQL database.

The new version is immediately available at:

Online demo:

Top 10 new features:
  1. New and updated controls.
  2. Enhanced JavaScript API.
  3. New security-related features.
  4. Extended template management.
  5. Multi-group menus.
  6. New application-level events.
  7. Custom CSS and JavaScript.
  8. Usability improvements.
  9. PHP Generator UI enhancements.
  10. Support for PHP 5.6 and other core features.

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

Categories: Database, Open Source

POWA 1.2 is out !

Tue, 10/28/2014 - 01:00

DALIBO is proud to present a new release of POWA, a 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 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 metrics and a better UI

This release includes some new features and some fixes since the first public release.

The core is responsible of statistics gathering. It relies on pg_stat_statements. As a first change, in order to avoid storing useless informations, DEALLOCATE and BEGIN statements are now ignored by the core. The snapshot timestamps were fixed. In order to ease backups and diagnostics, now PoWA history tables are now marked as "to be dumped" by pg_dump. Performance for "per database aggregated stats" were also improved. And last thing, some more metrics were made available throught the SQL API : temporary data, I/O time, average runtime.

The UI was also improved. In addition to displaying the new available metrics, several features were added. First, the UI follows the selected time interval from page to page. The displayed metrics are now human readable. Also, the query metrics are now displayed on each query page. Each page now has a different title, regarding its context. In order to get a better display area, the original database selector as been removed. A menu entry now permits the user to navigate between databases. Several bugs were fixed, like the empty graph bug. Note that the configuration file has changed since the previous release.

For the complete list of changes, please checkout the release notes

For complete installation and upgrading instructions, please checkout the documentation


DALIBO would like to thank the users and developers who contributed to this release, especially Christopher Liu, menardorama, Victor D, Justin Miller, Arthur Lutz.

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


Download :

Demo : (login/pass = powa/demo)

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

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 :

Full list of changes in this release :

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

And with that, the call for presentations is now open! For more information, please visit

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

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

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

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.


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


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

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