Paris, April 9th 2013

Dalibo is proud to announce the release of Ora2Pg 11.1. This major release adds support to multiprocessing so that you can now export data in parallel mode. Importing data from an Oracle database is now ten times faster. With this new feature, Ora2Pg performances are closer to the ones you'd get with any ETL.

Since 2001, Ora2Pg is the best solution to migrate data from Oracle to PostgreSQL and is used by thousands of companies around the world to switch from the most expensive proprietary RDBMS to the most advanced Open Source RDBMS!

Ora2pg 11.1 also brings important improvements :

• You can now generate XML transformation files for Kettle (see http://kettle.pentaho.com/).
• Faster scan of Oracle databases containing huge number of objects.
• Faster partition data export with direct import to tables partition.
• Bug fixes on RAW or LONG RAW data export.
• PL/SQL to PL/PGSQL code rewrite.

Gilles Darold, the project leader and main developer of Ora2Pg, explains: "The development of ora2pg is really fast because more and more companies are moving from Oracle to PostgreSQL. This new version brings speed improvements to migrate multi-terabyte databases faster. For most users, lowering the migration time is critical because it means less downtime during the switch from Oracle to PostgreSQL."

These performance enhancements were developed by Dalibo in collaboration with Photobox, Europe's largest online photo processing service and Bouygues Telecom, a major mobile network operator and ISP in France.

Dalibo would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially : Dominique Fourdrinoy, Ludovic Penet, Thomas Ogrisegg, Alex Delianis, Pierre-Marie Petit and mrojasaquino. Ora2Pg is an open project. Any contribution to build a better tool is welcomed. You just have to send your ideas, features requests, or patches using the GitHub tools at https://github.com/darold/ora2pg.

Useful Links:

• Website: http://ora2pg.darold.net/
• Download: http://sourceforge.net/projects/ora2pg/
• Development: https://github.com/darold/ora2pg
• Changelog: https://github.com/darold/ora2pg/blob/master/changelog

About Ora2Pg :

Ora2Pg is an easy and reliable tool to migrate data from Oracle to PostgreSQL. It is developed since 2001 by Gilles Darold, also author of pgBadger, a PostgreSQL performance tool. Ora2Pg can export most of the Oracle objects (table, view, tablespace, sequence, indexes, trigger, grant, function, procedure, package, partition, data, blob and external table).

Ora2Pg works on any platform and is available under the GPL v3 licence.

Docs, Download & Support at http://ora2pg.darold.net/

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

The PostgreSQL project has again been selected to take part in Summer of Code for 2013. Google will be funding several students to work with mentors from our project in order to hack PostgreSQL code for the summer.

Applications for students open April 22nd. Our Summer Of Code page has all the information you need about applying this year.

If you are connected with a university, please make sure that students know about this opportunity. If you are a student, please apply!

DtSQL is a FREE universal database query and editor tools for developers and database administrators to Query, Edit, Browse, and Manage Database objects such as tables, views, indexes, procedures, functions, triggers, contraints and sequences. It can access most databases : Cache, DB2, Derby, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MaxDB, Mckoi, Mimer, MySQL, Oracle, PointBase, PostgresSQL, Solid, SQLite, SQL Server, SQL Anywhere, Sybase (ASE).

1. Database Browser Tools : browse schemas, tables, columns, primary and foreign keys, constraints, views, indexes, triggers, stored procedures, functions, sequences, and so on.
2. Database Tools : create, alter, view and drop database tables, views, indexes, constraints, stored procedures, functions, triggers, sequences, and so on.
3. Database Management Tools : edit database table data including binary/BLOB and CLOB data types. Filter, sort and search query result. Insert, duplicate, update, and delete database table data. Find and replace database data, preview generated SQL. Redo or undo last table data change before update is commit.
4. SQL Tools : tools to edit, format and execute SQL scripts.
5. SQL Builder : help tools to build database select, insert, update, delete SQL scripts.
6. Import Data : tools to import data from various formats such as CSV files, Excel files, and fixed-width files. Parse import data according to integer, date, time, timestamp, and boolean pattern.

7. Export Data : tools to export database data (single table/multiple tables/query result) in various formats such as CSV files, Excel files, XML, HTML, SQL insert statements and fixed width files. Format export data according to applied integer, date, time, timestamp, and boolean pattern.

8. It is FREE to use.

9. Home: http://www.dtsql.com

The PostgreSQL Global Development Group has released a security update to all current versions of the PostgreSQL database system, including versions 9.2.4, 9.1.9, 9.0.13, and 8.4.17. This update fixes a high-exposure security vulnerability in versions 9.0 and later. All users of the affected versions are strongly urged to apply the update immediately.

A major security issue fixed in this release, CVE-2013-1899, makes it possible for a connection request containing a database name that begins with "-" to be crafted that can damage or destroy files within a server's data directory. Anyone with access to the port the PostgreSQL server listens on can initiate this request. This issue was discovered by Mitsumasa Kondo and Kyotaro Horiguchi of NTT Open Source Software Center.

Two lesser security fixes are also included in this release: CVE-2013-1900, wherein random numbers generated by contrib/pgcrypto functions may be easy for another database user to guess, and CVE-2013-1901, which mistakenly allows an unprivileged user to run commands that could interfere with in-progress backups. Finally, this release fixes two security issues with the graphical installers for Linux and Mac OS X: insecure passing of superuser passwords to a script, CVE-2013-1903 and the use of predictable filenames in /tmp CVE-2013-1902. Marko Kreen, Noah Misch and Stefan Kaltenbrunner reported these issues, respectively.

We are grateful for each developer's efforts in making PostgreSQL more secure.

This release also corrects several errors in management of GiST indexes. After installing this update, it is advisable to REINDEX any GiST indexes that meet one or more of the conditions described below.

This update release also contains fixes for many minor issues discovered and patched by the PostgreSQL community in the last two months, including:

• Fix GiST indexes to not use "fuzzy" geometric comparisons for box, polygon, circle, and point columns
• Fix bugs in contrib/btree_gist for GiST indexes on text, bytea, bit, and numeric columns
• Fix bugs in page splitting code for multi-column GiST indexes
• Fix buffer leak in WAL replay causing "incorrect local pin count" errors
• Ensure crash recovery before entering archive recovery during unclean shutdown when recovery.conf is present
• Avoid deleting not-yet-archived WAL files during crash recovery
• Fix race condition in DELETE RETURNING
• Fix possible planner crash after adding columns to a view depending on another view
• Eliminate memory leaks in PL/Perl's spi_prepare() function
• Fix pg_dumpall to handle database names containing "=" correctly
• Avoid crash in pg_dump when an incorrect connection string is given
• Ignore invalid indexes in pg_dump and pg_upgrade
• Include only the current server version's subdirectory when backing up a tablespace with pg_basebackup
• Add a server version check in pg_basebackup and pg_receivexlog
• Fix contrib/dblink to handle inconsistent settings of DateStyle or IntervalStyle safely
• Fix contrib/pg_trgm's similarity() function to return zero for trigram-less strings
• Enable building PostgreSQL with Microsoft Visual Studio 2012
• Update time zone data files for DST law changes in Chile, Haiti, Morocco, Paraguay, and some Russian areas

As always, update releases only require installation of packages and a database system restart. You do not need to dump/restore or use pg_upgrade for this update release. 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
• Release FAQ

PGConf.EU 2013 will be held on Oct 29-Nov 1, in at the Conrad Hotel in downtown Dublin, Ireland.

The format will be the same as previous years - one day of training before the main event consisting of three days fully packed with sessions about PostgreSQL.

We are hard at work to get our sponsorship campaign ready and intend to launch it within April. Also we are working on the call for papers and opening the registrations. So, please stay tuned and think about possible talk submissions!

So for now - mark your calendars, and start planning your trip! Follow the RSS feed from the website or our twitter feed for updates as soon as we know more details!

We look forward to seeing you this autumn on the Emerald Isle.

The PostgreSQL Global Development Group will be releasing a security update for all supported versions on Thursday April 4th, 2013. This release will include a fix for a high-exposure security vulnerability. All users are strongly urged to apply the update as soon as it is available.

We are providing this advance notice so that users may schedule an update of their production systems on or shortly after April 4th.

As always, update releases only require installation of packages and a database system restart. You do not need to dump/restore or use pg_upgrade for this update release.

Registration for PGCon 2013 is now open. Have a look at our list of speakers. Please be sure to book your accommodation right away. Some hotels will be sold out within a few weeks. We have an accommodation page which will help you find somewhere to stay.

Database .NET is an innovative, powerful and intuitive multiple database management tool, you can Browse objects, Design tables, Edit rows, Export data and run Queries with a consistent interface.

This is a major version release and contains a lot of new features and improvements:

• Added Script all database objects
• Added Form Editor
• Added Form Viewer
• Added Quick Button
• Added DateTime Picker
• Added New export formats: .json/.xlsx
• Improved Data Editor and Cell Editor
• Improved Table Editor
• Improved Database Diagram
• Improved SQL Profiler
• Improved Code Manager
• Improved AutoComplete and IntelliSense
• … and much more.

Free, Portable, All-In-One, Easy to Use and Multlanguage.

More Info: http://fishcodelib.com/Database.htm

Datanamic has released a new version of Datanamic DataDiff for PostgreSQL. Datanamic DataDiff allows the user to compare the data in two databases, view the differences, automatically generate safe data change scripts or apply the changes to the destination database directly.

Version 4 is almost completely re-designed with a new modern user interface, an improved comparison engine and new comparison options. Three (3) editions support PostgreSQL: the MultiDB edition, the PostgreSQL edition and the CrossDB edition. The CrossDB edition allows you to synchronize data between different database platforms (including PostgreSQL).

More information can be found on the Datanamic DataDiff for PostgreSQL product pages.

DtSQL is a FREE universal database query and editor tools for developers and database administrators to Query, Edit, Browse, and Manage Database objects such as tables, views, indexes, procedures, functions, triggers, contraints and sequences. It can access most databases : Cache, DB2, Derby, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MaxDB, Mckoi, Mimer, MySQL, Oracle, PointBase, PostgresSQL, Solid, SQLite, SQL Server, SQL Anywhere, Sybase (ASE).

1. Database Browser Tools : browse schemas, tables, columns, primary and foreign keys, constraints, views, indexes, triggers, stored procedures, functions, sequences, and so on.
2. Database Tools : create, alter, view and drop database tables, views, indexes, constraints, stored procedures, functions, triggers, sequences, and so on.
3. Database Management Tools : edit database table data including binary/BLOB and CLOB data types. Filter, sort and search query result. Insert, duplicate, update, and delete database table data. Find and replace database data, preview generated SQL. Redo or undo last table data change before update is commit.
4. SQL Tools : tools to edit, format and execute SQL scripts.
5. SQL Builder : help tools to build database select, insert, update, delete SQL scripts.
6. Import Data : tools to import data from various formats such as CSV files, Excel files, and fixed-width files. Parse import data according to integer, date, time, timestamp, and boolean pattern.

7. Export Data : tools to export database data (single table/multiple tables/query result) in various formats such as CSV files, Excel files, XML, HTML, SQL insert statements and fixed width files. Format export data according to applied integer, date, time, timestamp, and boolean pattern.

8. It is FREE to use.

9. Home: http://www.dtsql.com

10. Features: http://www.dtsql.com/database_tools.htm

DALIBO is proud to announce the release of pgBadger v3, the new PostgreSQL log analyzer. pgBadger is built for speed with fully detailed reports from your PostgreSQL log file.

This new release brings significant improvements. All pgBadger users should upgrade as soon as possible.

pgBadger 3 parallel log parsing

The first versions of pgBadger were bound to only one CPU. The PostgreSQL log files were scanned sequentially. Analyzing very large log files could take several hours.

This limitation is now removed. You can use as many CPU cores as you want and scan your logs in parallel.

To enable parallel processing, you just have to use the -j N option, N being the number of cores you want to use.

Please note that the parallel mode has a little drawback. With this method, some queries may be truncated. If you enable N cores, then result may differ in a maximum of N queries per log file.

However, this is a minor issue: parallel mode is interesting if you have millions of queries to analyze. And if you have millions of queries in a log file, you can afford to loose a few as it's quite unlikely that the lost queries would have changed the overall results.

However, to avoid this problem, you can use the pgBadger "per-file parallel mode" to analyze your logs but with lower performance than the standard parallel mode. To enable this behaviour, you have to use the "-J N" option instead of "-j N". In per-file mode, the performances start being really interesting when there's hundreds of small log files (e.g. 10MB rotation size limit) and with at least 8 cores.

How fast is pgBadger 3?

The goal was to allow pgBadger to use as many cores as specified to have parallel log parsing. Here are some performance results using pgbadger on five log files for a total of 9.5 GB:

• with 1 core => 1h 41m 18s
• with 2 cores => 50m 25s
• with 4 cores => 25m 39s
• with 8 cores => 15m 58s

We feel this performance gain is quite interesting :)

New binary format

In addition to the classic HTML, TXT and Tsung output formats, pgBadger 3 is now able to generate a binary input/output format. This new format is useful if you only want to store the log statistics and generate the HTML report with graph later.

In a nutshell, the two main activities of pgBadger are parsing and reporting. With this binary format, you can now split those activities and run them at different times. For exemple, you can parse your log once a day, and generate the HTML reports only when needed.

You can also combine several binary files to . For Instance, you may create a binary report every week and aggregate the last 4 week reports to build a monthly report in HTML.

This new binary format is also compatible with other tools such as pgShark https://github.com/dalibo/pgshark/.

More stats, more pie charts!

This major release also has additional features:

• New pie graph to show number of autovacuum per table and number of tuples removed by autovacuum per table
• No more distinction between log_duration, log_statement and log_min_duration_statement format
• New report of tuples/pages removed in report of VACUUM by table
• New VACUUM and ANALYZE hourly reports and graphs

... and many bugfixes .

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

Deprecated options

WARNING : for the sake of simplicity, the '--enable-log_min_duration' and '--enable-log_duration' command line options have been removed. pgbadger is now parsing any log_duration, log_statement and log_min_duration_statement lines without distinction and adapt the reports following those lines.

If you are running pgBadger using cron, please take care: if one of theses options appears in the command line, pgbadger will refuse to start.

Links & Credits

DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Matt Romaine, Luke Cyca, Kevin Brannen, Adam Schroder, pilat66, Euler Taveira de Oliveira, stuntmunkee, pierrestroh, Vipul, Dirk-Jan Bulsink and Vincent Laborie.

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 :

• Download
• Mailing List

About pgBadger :

pgBagder is a new generation log analyzer for PostgreSQL, created by Gilles Darold, also author of ora2pg 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 server and identify which SQL queries need to be optimized.

Docs, Download & Demo at http://dalibo.github.com/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.com

The PyPgDay committee has selected the speakers and talks for PyPgDay 2013. We have an awesome program for you, including talks about monitoring, scaling, performance, Python application development, Django and mobile applications, and speakers from Disqus, Apsalar, VMware, 2ndQuadrant and Uber. While we can't give you everything you want to know about PostgreSQL and Python in one day, we can certainly give you a lot.

You also want to register soon, because registration is already 50% full.

Check out the list of speakers on the draft schedule. We may reorder them from here, but the talks and speakers are pretty solid. We still have room for some lightning talks.

PyPgDay is presented by Disqus.

The PyPgDay Party Sponsor is Salesforce.com. The Wifi Sponsor is Heroku.com. PyPgDay is sponsored by Urban Mapping, Uber.com, TransLattice, PostgreSQL Experts, Pandora.com, File-Away.UK and Apsalar.