Make Homepage | Add To Favorites | Print Page | Submit News | Feedback | Contact | 

Your Technical Computer Information Resource!  
     

  PostgreSQL-Press related Technical Updates [Page: 15 of 61] @ TACKtech Corp.  

03.14.2013 - Database .NET 8.0 released



View PostgreSQL-Press related news.

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

Full View / NID: 44742 / Submitted by: The Zilla of Zuron

03.13.2013 - Datanamic releases new DataDiff for PostgreSQL V4 for simple, fast, data movement and comparison



View PostgreSQL-Press related news.

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.

Full View / NID: 44795 / Submitted by: The Zilla of Zuron

03.07.2013 - Universal Database Tools - DtSQL 2.2.1 is released (FREE)



View PostgreSQL-Press related news.

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
Full View / NID: 44659 / Submitted by: The Zilla of Zuron

02.26.2013 - pgBadger 3 released : now with parallel parsing



View PostgreSQL-Press related news.

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 :


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

Full View / NID: 44612 / Submitted by: The Zilla of Zuron

02.22.2013 - Talks for PyPgDay Selected



View PostgreSQL-Press related news.

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.

Full View / NID: 44585 / Submitted by: The Zilla of Zuron

02.14.2013 - Generate realistic test data with Datanamic Data Generator for PostgreSQL V5



View PostgreSQL-Press related news.

The ultimate database test data generation tool for PostgreSQL is better than ever.

Version 5 of Datanamic Data Generator for PostgreSQL has been redesigned. The tool has a complete new user interface. The new version generates test data faster and generates better sample data, has a new "test run" option and has new generator settings such as the "synchronized selection" option for generators which get data from external sources. Test data generation for MS SQL Server 2012 and SQLite (version 3) databases is supported now also.

This is not all. There is more. A complete list of changes can be found at on our website at:

Datanamic Data Generator for PostgreSQL product page.

Full View / NID: 44514 / Submitted by: The Zilla of Zuron

02.13.2013 - AnySQL Maestro 13.2 released



View PostgreSQL-Press related news.

SQL Maestro Group announces the release of AnySQL Maestro 13.2, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (PostgreSQL, MySQL, SQL Server, Oracle, Access, etc).

The new version is immediately available at
http://www.sqlmaestro.com/products/anysql/maestro/.

AnySQL Maestro comes in both Freeware and Professional editions.

Top 10 new features:

  1. The software has been optimized to work with some popular DBMS including PostgreSQL.
  2. Updated Connection String Reference.
  3. Enhanced Get SQL Dump wizard.
  4. New Start Page with quick access to recently connected databases and latest company news.
  5. Improved SQL Editor.
  6. Highlighted key and required columns and multi-column lookup editors in the data grids.
  7. Data import from CSV files containing multi-line strings.
  8. Data Export: support for custom separators.
  9. Colored profiles in Database Explorer.
  10. New modern progress windows.

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

Full View / NID: 44515 / Submitted by: The Zilla of Zuron

02.09.2013 - Universal Database Tools - DtSQL 2.1.1 is released (FREE)



View PostgreSQL-Press related news.

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
Full View / NID: 44469 / Submitted by: The Zilla of Zuron

02.08.2013 - Just released: Precog (Data Science Platform) for PostgreSQL



View PostgreSQL-Press related news.

Today, the Precog team has released a free implementation of Precog for PostgreSQL. Precog for PostgreSQL empowers users to easily perform data science on PostgreSQL.

This release bundles the core Precog analysis technology into a completely free package that anyone can download and deploy on their existing PostgreSQL database. Precog for PostgreSQL gives you the ability to analyze all the data in your PostgreSQL database, without forcing you to export data into another tool or write any custom code.

Precog for PostgreSQL comes bundled with Labcoat, a high-level analysis tool that lets users analyze data using Quirrel, the statistically-oriented query language. To get started, visit this page to download the zipped file (includes JAR, scripts and config file).

To get started….

  1. Download the zip file
  2. Configure Precog
  3. Launch Precog
  4. Try the API
  5. Try Labcoat
  6. Analyze your data!

See the read me for the complete installation and configuration instructions. We provide full support for this release so if you run into any trouble, please contact the Precog team at support@precog.com.

Have fun analyzing your data on your PostgreSQL database and let us know what you think!

Full View / NID: 44470 / Submitted by: The Zilla of Zuron

02.08.2013 - Barman 1.2.0 released



View PostgreSQL-Press related news.

2ndQuadrant is proud to announce the release of version 1.2.0 of Barman, Backup and Recovery Manager for PostgreSQL.

This major release introduces automated support for retention policies based on redundancy of periodical backups or recovery window.

Retention policies are integrated by a safety mechanism that allows administrators to specify a minimum number of periodical backups that must exist at any time for a server.

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

Backup retention policies

A backup retention policy is an user-defined policy that determines how long backups and related archive logs (Write Ahead Log segments in PostgreSQL) need to be retained for recovery procedures.

Through the 'retention_policy' configuration option, Barman retains the periodical backups required to satisfy the current retention policy, and any archived WAL files required for the complete recovery of those backups.

Barman users can define a retention policy in terms of backup redundancy (how many periodical backups, e.g. 5) or a recovery window (how long, e.g. 3 months).

Minimum redundancy safety --

Through the 'minimum_redundancy' configuration option, Barman controls the minimum number of backups available at any time in the catalogue for a specific server. This feature will protect users from accidental delete operations.

Links --

Sponsors --

The open-source development of retention policies under GPL has been sponsored by a large European company that opted to remain anonymous.

Release Notes --

  • Added the "retention_policy_mode" global/server option which defines the method for enforcing retention policies (currently only "auto")
  • Added the "minimum_redundancy" global/server option which defines the minimum number of backups to be kept for a server
  • Added the "retention_policy" global/server option which defines retention policies management based on redunancy (e.g. REDUNDANCY 4) or recovery window (e.g. RECOVERY WINDOW OF 3 MONTHS)
  • Added retention policy support to the logging infrastructure, the "check" and the "status" commands
  • The "check" command now integrates minimum redundancy control
  • Added retention policy states (valid, obsolete and potentially obsolete) to "show-backup" and "list-backup" commands
  • The 'all' keyword is now forbidden as server name
  • Added basic support for Nagios plugin output to the 'check' command through the --nagios option
  • Barman now requires argh => 0.21.2 and argcomplete
  • Minor bug fixes

About Barman --

Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase. Barman most wanted features include backup catalogues, retention policies, remote recovery, archiving and compression of WAL files and backups.

Built on top of PostgreSQL's robust and reliable Point-In-Time-Recovery technology, Barman allows database administrators to manage the backup and recovery phases of several PostgreSQL database servers from a centralised location, using an intuitive command interface. Barman is distributed under GNU GPL 3.

Full View / NID: 44465 / Submitted by: The Zilla of Zuron

02.08.2013 - Just released: Precog for PostgreSQL



View PostgreSQL-Press related news.

Today, the Precog team has released a free implementation of Precog for PostgreSQL. Precog for PostgreSQL empowers users to easily perform data science on PostgreSQL.

This release bundles the core Precog analysis technology into a completely free package that anyone can download and deploy on their existing PostgreSQL database. Precog for PostgreSQL gives you the ability to analyze all the data in your PostgreSQL database, without forcing you to export data into another tool or write any custom code.

Precog for PostgreSQL comes bundled with Labcoat, a high-level analysis tool that lets users analyze data using Quirrel, the statistically-oriented query language. To get started, visit this page to download the zipped file (includes JAR, scripts and config file).

To get started….

  1. Download the zip file
  2. Configure Precog
  3. Launch Precog
  4. Try the API
  5. Try Labcoat
  6. Analyze your data!

See the read me for the complete installation and configuration instructions. We provide full support for this release so if you run into any trouble, please contact the Precog team at support@precog.com.

Have fun analyzing your data on your PostgreSQL database and let us know what you think!

Full View / NID: 44464 / Submitted by: The Zilla of Zuron

02.07.2013 - PostgreSQL 9.2.3, 9.1.8, 9.0.12, 8.4.16 and 8.3.23 released



View PostgreSQL-Press related news.

The PostgreSQL Global Development Group has released a security update to all current versions of the PostgreSQL database system, including versions 9.2.3, 9.1.8, 9.0.12, 8.4.16, and 8.3.23. This update fixes a denial-of-service (DOS) vulnerability. All users should update their PostgreSQL installations as soon as possible.

The security issue fixed in this release, CVE-2013-0255, allows a previously authenticated user to crash the server by calling an internal function with invalid arguments. This issue was discovered by independent security researcher Sumit Soni this week and reported via Secunia SVCRP, and we are grateful for their efforts in making PostgreSQL more secure.

Today's update also fixes a performance regression which caused a decrease in throughput when using dynamic queries in stored procedures in version 9.2. Applications which use PL/pgSQL's EXECUTE are strongly affected by this regression and should be updated. Additionally, we have fixed intermittent crashes caused by CREATE/DROP INDEX CONCURRENTLY, and multiple minor issues with replication.

This release is expected to be the final update for version 8.3, which is now End-of-Life (EOL). Users of version 8.3 should plan to upgrade to a later version of PostgreSQL immediately. For more information, see our Versioning Policy.

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

  • Prevent unnecessary table scans during vacuuming
  • Prevent spurious cached plan error in PL/pgSQL
  • Allow sub-SELECTs to be subscripted
  • Prevent DROP OWNED from dropping databases or tablespaces
  • Make ECPG use translated messages
  • Allow PL/Python to use multi-table trigger functions (again) in 9.1 and 9.2
  • Fix several activity log management issues on Windows
  • Prevent autovacuum file truncation from being cancelled by deadlock_timeout
  • Make extensions build with the .exe suffix automatically on Windows
  • Fix concurrency issues with CREATE/DROP DATABASE
  • Reject out-of-range values in to_date() conversion function
  • Revert cost estimation for large indexes back to pre-9.2 behavior
  • Make pg_basebackup tolerate timeline switches
  • Cleanup leftover temp table entries during crash recovery
  • Prevent infinite loop when COPY inserts a large tuple into a table with a large fillfactor
  • Prevent integer overflow in dynahash creation
  • Make pg_upgrade work with INVALID indexes
  • Fix bugs in TYPE privileges
  • Allow Contrib installchecks to run in their own databases
  • Many documentation updates
  • Add new timezone "FET".

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:

Full View / NID: 44460 / Submitted by: The Zilla of Zuron

02.06.2013 - FREE Universal Database Tools - DtSQL 2.1.1 is released



View PostgreSQL-Press related news.

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. Data Management Tools : edit database table data including binary/BLOB and CLOB data types. Filter, sort and search query result. Insert, duplicate, update, and delete table data. Find and replace data, preview generated SQL. Redo or undo last table data change before update is commit.
  4. SQL Tools : 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
Full View / NID: 44457 / Submitted by: The Zilla of Zuron

02.04.2013 - Uniserveral Database Tools - DtSQL 2.1.1 is released (FREE)



View PostgreSQL-Press related news.

DtSQL is an 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. Data Management Tools : edit database table data including binary/BLOB and CLOB data types. Filter, sort and search query result. Insert, duplicate, update, and delete table data. Find and replace data, preview generated SQL. Redo or undo last table data change before update is commit.
  4. SQL Tools : 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 now.

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

  10. Features: http://www.dtsql.com/database_tools.htm
Full View / NID: 44431 / Submitted by: The Zilla of Zuron

01.13.2013 - Australia PGDay 2013



View PostgreSQL-Press related news.

The big blue elephant is making its way to Melbourne (Down Under) for the first time!

We're very fortunate to have Gabriele Bartolini and Josh Berkus from the international PostgreSQL community make their way to Melbourne to share their unique perspectives and experiences with us on the this amazing open source database.

Come join other PostgreSQL enthuisiasts at the first ever Australian PGDay as a kick off to the commencement of the Melbourne PostgreSQL Users Group. This is the first event of its kind in Australia and we're hoping Melbournians, and users Australia-wide, attend the event to help us grow and become a vibrant community in the coming years.

The 2013 Australia PGDay will take place on the 4th of February and will be held at the Experian Hitwise office near St. Kilda. The office is located at Level 6/580 St. Kilda Road, Melbourne - directly opposite Wesley College. You can find the full address together with Google Maps and tram directions on the Meetup group site (see below).

Access to the event is free however we require registration as we only have 60 spots for the day. Tea, coffee and lunch will be provided and we'll be heading over to the Belgian Beer Cafe afterwards.

The event will be an all day affair (starting 10am and finishing at 4:30pm) and will be broken up into two parts to cater to different audiences. The morning session will serve as an introduction to PostgreSQL, detail the features found in the latest version (9.2) and discuss the merits of the project. The afternoon session will be focused on existing users (or keen new users :) and be a look into back-up and recovery, replication and other in-depth topics.

The schedule for the day is still in draft. More information about PGDay AU will be provided on the 2013.pgday.org.au and meetup/melpug websites, the postgresql.org website and on the official Twitter account. Stay tuned and subscribe to the feeds!

Save the date and... see you in Melbourne!

Full View / NID: 44272 / Submitted by: The Zilla of Zuron

01.08.2013 - FOSDEM PGDay 2013 - schedule announced



View PostgreSQL-Press related news.

We've finished the schedule for FOSDEM PGDay 2013 and PostgreSQL Developer Room at FOSDEM in Brussels in February, and published it at

http://fosdem2013.pgconf.eu/schedule/

http://fosdem2013.pgconf.eu/m/ (mobile version)

Of course, a schedule is never truly finished - we will update it if necessary as we get closer to the conference.

We have many great talks from well known speakers in the PostgreSQL community such as Heikki Linnakangas, Devrim Gunduz and Dimitri Fontaine, as well as a number of new speakers.

Please register as soon as possible for the FOSDEM PGDay 2013 on Friday at:

http://fosdem2013.pgconf.eu/registration/

We have only a limited number of seats on Friday. No registration is required for the PostgreSQL Developer Room at FOSDEM on Sunday. Just walk in and enjoy great talks.

We hope to see you all in Brussels next month!

Full View / NID: 44265 / Submitted by: The Zilla of Zuron

12.28.2012 - New Product Launch – dbForge Data Compare for PostgreSQL!



View PostgreSQL-Press related news.

dbForge Data Compare for PostgreSQL is a Postgre Data Diff and Sync tool that allows users to review all the differences in compared tables and execute an automatically generated script to remove these differences. The process of comparison and synchronization is customizable, providing an ability to select tables and fields for comparison and adjust multiple comparison options. With the Windows Task scheduler the database synchronization process can be easily automated.

Data Compare for PostgreSQL key features:

  • Flexible customization of database object mapping.

Automatical or manual schemas, tables, views and columns mapping. Custom mapping can be applied to schemas or database objects that can not be mapped automaticaly.

  • Comfortable view of data differences.

Convenient display of data comparison results in the Data Comparison document considerably facilitates the processing of data comparison results. Database objects can be filtered by the differences.

  • Comparison Report Generation

Generate a comparison results report, choose the most convenient form of its display: Excel or HTML, and select objects that have to be reported.

  • Full control over data to synchronize.

Trouble-free exclusion of tables and individual records from the synchronization after the comparison.

  • Easy to use Data Synchronization wizard.

Synchronization settings can be easily customized with the help of Data Synchronization Wizard. Users can backup target database before synchronization. Generated synchronization script can be immediately applied to the target database or saved in a file.

  • Warnings of possible data loss and various notifications.

If errors or data loss occur because of types incompatibility the user will be warned about it. The user will also receive notifications about data overflow, roundings, etc.

  • Large script execution.

With dbForge Data Compare for PostgreSQL large scripts can be executed without opening script in the SQL editor and loading the whole script in memory. When trying to open a large script, the user will be prompted to execute it instead with the help of the Execute Script Wizard.

  • Compare and sync data via command line.

There is no need to open the application and go through the wizard pages any more. Now command line can be used to compare and synchronize data.

  • Friendly GUI.

Data Compare for PostgreSQL provides a self-intuitive user interface that largely reduces the amount of time spent on learning how to use the new product and benefit from it.

Availability

Give the new dbForge Data Compare for PostgreSQL a test drive by downloading the 30-day trial Standard edition at the product download page. Data Compare for PostgreSQL Standard edition is available for an estimated retail price of $99.95. Provide feedback and speak out about the new tool on the Product Forum. The Devart team is looking forward to receiving your comments and suggestions.

About Devart

Devart is a widely recognized provider of database connectivity solutions and developer tools for the most popular databases, including MS SQL Server, MySQL, Oracle, PostgreSQL, InterBase, Firebird and SQLite. Since 1998, Devart has been focused on the development of native database data access solutions, development and database tools for a wide range of databases and development technologies. Now, Devart solutions provide the fastest data access available on the market and the broadest database support to many thousands of industry professionals. For additional information about Devart, visit the official web site.

Full View / NID: 44204 / Submitted by: The Zilla of Zuron

12.21.2012 - Ora2PG 10 : Evaluate your database migration costs



View PostgreSQL-Press related news.

Paris, december 19th 2012

Dalibo is proud to announce the release of Ora2Pg 10. This major release allows you to scan your legacy Oracle servers and estimate the migration costs. Ora2Pg also adds numerous improvements and enhancements such as the support of Oracle external tables.

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!

With the 10.x series, Ora2Pg adds a long-awaited feature : the migration assessment tool. When considering a data migration, Ora2Pg is now able to provide a report with a detailed cost estimation of the migration process. This report is generated in 2 steps. First, Ora2Pg scans every object contained in the Oracle database and analyze how they will be exported. Then, for each database object, Ora2Pg will calculate the amount of work required (in man-days unit). This is helpful with very large Oracle databases and with PL/SQL stored procedures.

Gilles Darold, the project leader and main developer of Ora2Pg, explains: "Ora2Pg 10 is the first open source migration tool to provide global reports and migration cost estimations. More and more companies are considering moving from Oracle to PostgreSQL, and, with Ora2Pg, they can now forecast the return on investment of their migration process."

The migration assessment tool was developed by Dalibo in collaboration with Atos and the French DGFiP (the National Public Finance Administration). Dalibo would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially : Dominique Legendre, Philippe Lang, Sebastian Fischer, Dennis Spaag, Sorin Gheorghiu, and Siva Janamanchi. 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:


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

Full View / NID: 44206 / Submitted by: The Zilla of Zuron

12.21.2012 - Free Beta of PG 9.2 from Gandi.net



View PostgreSQL-Press related news.

Gandi.net is creating a PG 9.2 instance in a PaaS format. Feedback wanted!

The PaaS is called "Simple Hosting", and includes Apache and PHP as well as 9.2.

The Instance is available for free beta use on request. Anyone desiring an instance should email:

beta-simple@gandi.net

You will need an account on Gandi's website, which is free, and we will give you a code to use to create an instance.

It's pretty straightforward. You get phppgadmin as well as console access. There is a 10 GB disk, and it's useful out of the box as a moderate web server.

Gandi would appreciate any and all feedback. We want to do PostgreSQL right.

Full View / NID: 44205 / Submitted by: The Zilla of Zuron

12.18.2012 - PyPgDay 2013 Call For Presentations



View PostgreSQL-Press related news.

Do you use Postgres for interesting things? Do you develop nifty applications in Python? Do you use them together? Then submit a talk for PyPgDay!

PyPgDay will be held on March 13th at the Santa Clara Convention Center, the first day of PyCon. We are specifically looking for talks about:

  • General PostgreSQL administration and performance
  • PostgreSQL replication
  • Developing applications with Postgres and Python
  • PostgreSQL administration tools written in Python
  • PL/Python
  • Data-intensive Django/Pylons/SQLAlchemy/etc. applications
  • PostGIS and GeoDjango
  • New Postgres features, like JSON, Range Types and PL/v8

Talks will be 45 minutes in length, and should be pitched to a mixed audience of Python developers and Postgres DBAs. There will also be six lightning talks, each 5 minutes long.

PyPgDay presentations might be broadcast over streaming video. You will need to give your consent to this broadcast.

Submit your proposal here.

The Deadline for submissions is January 20. Speakers will be chosen February 10.

You are encouraged to submit more than one proposal (on different topics).

More information about PyPgDay on the wiki.

Full View / NID: 44130 / Submitted by: The Zilla of Zuron
  Popular Tech News  
  Most Viewed News  
  Top Affiliates  
.....