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!
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!
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
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:
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!
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!
Oslo, Norway - June 26,2014
We are proud to announce the first release available to the public of PgBackMan - PostgreSQL backup manager.
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
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:
For more information on how to download Bucardo, please visit:
Checksums for the tarball:
d87d109c1cba300d074603b2dd4d1019302acdfd Bucardo-5.0.0.tar.gz f4e68f473a4669d465d0d8f23910d4b3 Bucardo-5.0.0.tar.gz
The new Admin4 release is the first to contain a greatly enhanced PostgreSQL module. It includes:
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!
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.
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!
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:
There are also some other useful things. Full press release is available at the SQL Maestro Group website.
Version 3.2.1 of DBD::Pg, the Perl interface to Postgres, has just been released. For more information and to download please visit:
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.
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:
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:
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.
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.
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
EnterpriseDB is pleased to announce the initial release of pg_catcheck, a catalog integrity checker for PostgreSQL and Postgres Plus Advanced Server.
pg_catcheck is a simple tool for diagnosing system catalog corruption, released under the same license as PostgreSQL itself. pg_catcheck reports logical errors in system catalogs, such as a value in pg_catalog.relnamespace that is not present in pg_namespace.oid. It is intended to make it easy to determine the nature and extent of system catalog corruption so that you (or your PostgreSQL support provider) can take whatever recovery actions you might deem appropriate, such as repairing enough of the damage to take a successful pg_dump of the damaged cluster. pg_catcheck has been tested on Linux and Windows and is expected to work on other operating systems, and it supports server versions 8.4 and newer.
For more details, see the source code and README here.
You can join the project mailing list, firstname.lastname@example.org, here.
Paris, France - May 6th, 2014
DALIBO is proud to announce the release of pgBadger 5.1.
pgBadger is a PostgreSQL performance analyzer, built for speed with fully detailed reports based on your Postgres log files.
This new release fixes several issues and adds some new features:
For the complete list of changes, please checkout the release note on https://github.com/dalibo/pgbadger/blob/master/ChangeLogLinks & Credits
DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Herve Werner, Fangr Zhang, Ulf Renman, Thom Brown, Johnny Tan, hkrizek, Magnus Persson, Ronan Dunklau, Adrien Nayrat, William Moran, Orange OLPS department, Josh Kupershmidt, brunomgalmeida, Brian DeRocher, ferfebles and Josh Berkus. With very special thanks to Herve Werner who took time and efforts to heavily test the incremental pgBadger feature.
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.
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
We are pleased to announce the release of TeamPostgreSQL 1.07.
TeamPostgreSQL is a free PostgreSQL web interface, that enables access to PostgreSQL databases through the browser. Ideal for organizations to provide database access via the internet or intranet, or simply as a great database interface on your local machine.
Some feature highlights:
More info, online demo and download links at the website: http://www.teampostgresql.com
You're welcome to download the PostgresDAC v2.12.0 right now at: http://microolap.com/products/connectivity/postgresdac/download/ or login to your private area on our site at http://microolap.com/my/downloads/Feedback
Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/
Database .NET v11 is 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.New features from version 10.1 to 11.0:
14 April 2014: 2ndQuadrant is proud to announce the release of version 1.3.1 of Barman, Backup and Recovery Manager for PostgreSQL.
This minor release introduces support for concurrent backup using physical file based copy through "rsync", in conjunction with pgespresso, a new open source extension available for PostgreSQL 9.2 and 9.3. Concurrent backup allows database administrators that rely on Barman, to finally offload backup operations to a streaming replicated standby server, opening new important scenarios in disaster recovery architectures of PostgreSQL 9.2+ database servers.
The "barman diagnose" command has been implemented to print important information about the system and the configuration of Barman, allowing users to provide detailed diagnostics data in case of support requests.
Version 1.3.1 fixes an important bug on recovery that was affecting only those users having tablespaces created inside the PGDATA directory. This behaviour was introduced in version 1.3.0.
Minor bugs have also been fixed.
Many thanks for funding towards the development of this release go to Adyen (www.adyen.com).
For a complete list of changes, see the "Release Notes" section below.
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.
Postgres Open 2014 will be held in Chicago, IL, at the Hotel Sax, September 17 - 19, 2014. It will feature two full days of multiple parallel tracks of PostgreSQL presentations (September 18 - 19th) from both local and global speakers, covering a wide range of topics. In addition we will also be offering a separate day of tutorials (Wednesday, September 17th). For more information about the conference, please see our website http://postgresopen.org/2014
The Program Committee is currently accepting proposals for presentations at the conference. We are interested in submissions from both seasoned PostgreSQL experts and people new in the community, from both locals and representatives of the global community. In short, from anybody who has an interesting story to tell about PostgreSQL, whether deeply technical or story about a successful (or failed) usage. All presentations are 45 minutes, with time for questions. Talks can be submitted via the website: http://postgresopen.org/2014/callforpapers/
Our early-bird ticket registration will open in May 19, 2014 and are available through June 30, 2014, after which tickets will go up to their regular price.
Finally, we are also looking for sponsors! We several tiers of sponsorship, to make sure there is a choice for everybody. If you are interested, please see the Postgres Open sponsor page http://postgresopen.org/2014/becomesponsor/
We look forward to seeing you in Chicago in September!