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

Your Technical Computer Information Resource!  
     

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

12.05.2013 - PostgreSQL Maintenance Releases: 9.3.2, 9.2.6, 9.1.11, 9.0.15, and 8.4.19



View PostgreSQL-Press related news.

The PostgreSQL Global Development Group has released a critical update to all supported versions of the PostgreSQL database system, which includes minor versions 9.3.2, 9.2.6, 9.1.11, 9.0.15, and 8.4.19. This update fixes three serious data-loss bugs affecting replication and database maintenance. All users are urged to update their installations at the earliest opportunity.

The replication issue affects some users of PostgreSQL binary replication, and can cause minor data loss between the master and the standby. While not all users are affected, it is difficult to predict when the bug will occur, so we urge all users of replication and continuous backup (PITR) to update immediately. Additionally, users who had replication running under PostgreSQL minor versions 9.3.0, 9.3.1, 9.2.5, 9.1.10, or 9.0.14 should plan to take a fresh base backup of each standby after update, in order to ensure no prior data corruption already exists. More information about this issue is on its wiki page.

This release also fixes two timing issues with VACUUM, which can cause old, overwritten or deleted rows to re-appear at a later date under some circumstances. Users with very high transaction rates, particularly those who experience "transaction ID wraparound" every few weeks or less, are the most at risk for this issue. Those users should set vacuum_freeze_table_age to 0, and run a database-wide VACUUM after the update. The second of the two VACUUM issues affects only 9.3, making it expecially important for 9.3 users to update.

Additional fixes included in this release, some of which only affect version 9.3, include:

  • Prevent "lock already held" error.
  • Resolve race conditions in timeout management, which could cause server lockup.
  • Fix minor bugs with HOT updates and the Visibility Map.
  • Prevent pg_multixact storage growth on standbys.
  • Fix bug in GIN indexes which caused transient query failures.
  • Remove issue which caused SP-GiST index creation to hang
  • Fix assorted bugs in Materialized Views.
  • Restore ability to use duplicate table aliases in complex queries.
  • Fix two bugs in subquery optimization.
  • Allow pg_receivexlog to resume streaming when more than 4GB of logs are generated.
  • Prevent planner crash on whole-row references.
  • Prevent premature deletion of temporary files.
  • Patch multiple minor memory leaks.
  • Suppress display of dropped columns for CHECK and NOT NULL constraint violations.
  • Allow default and named arguments for window functions.
  • Return a valid JSON value when converting an empty HStore string.
  • Fix GMT timezone offset.
  • Report out-of-disk-space error correctly during pg_upgrade.
  • Time zone updates for several time zones.

Additional changes and details of some of the above issues can be found in the Release Notes.

As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

Links: * Download * Release Notes

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

11.22.2013 - Replication Bug Warning



View PostgreSQL-Press related news.

The PostgreSQL Project has recently discovered an issue which can cause minor data loss for some users of streaming replication on very recent releases. Details on this issue are explained on the November 2013 Replication Data Loss Issue page, as well as steps to protect yourself until the next update release is available.

We apologize for any disruption caused by this issue. We expect to have an update available which fixes this issue in less than 2 weeks.

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

11.18.2013 - Intelligent Converters released PostgreSQL-to-MSSQL and MSSQL-to-PostgreSQL converters



View PostgreSQL-Press related news.

Intelligent Converters has extended their product line with new tools to migrate between Microsoft SQL and SQL Azure databases and PostgreSQL.

For more information, please visit the product pages list below:

MSSQL-to-PostgreSQL Converter

PostgreSQL-to-MSSQL Converter

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

10.31.2013 - pgBadger 4: Brand New Design, Time Period Exclusion and more !



View PostgreSQL-Press related news.

Paris, France - October 31th, 2013

DALIBO is proud to announce the release of pgBadger 4, a PostgreSQL performance analyzer, built for speed with fully detailed reports based on your Postgres log files.

This major version comes with a bunch of new features including a complete overhaul for the HTML reports, some new statistics, compatiblity with PostgreSQL 9.3 and Time Period Exclusion...

Better Reports / Improved user experience

With a full rewrite of its graphic design, pgBadger has now turned the HTML reports into a more intuitive user experience and professional look.

Every statistic report now include a key value section that shows you immediately some of the relevant informations. Pie charts have also been separated from their data tables using two tabs, one for the chart and the other one for the data.

Tables reporting hourly statistic have been moved to a multiple tabs report following the data. This is used with General (queries, connections, sessions), Checkpoints (buffer, files, warnings), Temporary file and Vacuums activities.

PostgreSQL 9.3 compatibility and new stats

Recent PostgreSQL versions add additional information about checkpoint, the number of synced files, the longest sync and the average of sync time per file. pgBadger collects and shows these informations in the Checkpoint Activity report.

There's also some new reports:

  • Prepared queries ratio (execute vs prepare)
  • Prepared over normal queries
  • Queries (select, insert, update, delete) per user/host/application
  • Pie charts for tables with the more tuples and pages removed during vacuum. The vacuum report will now highlight the costly table during a vacuum or analyze of a database.

The errors are now highlighted by a different color following the level. A LOG level will be green, HINT will be yellow, WARNING orange, ERROR red and FATAL dark red.

Some changes in the binary format are not backward compatible and option --client have been remove as it was replaced by --dbclient for a long time now.

Time Period Exclusion

If you are running a pg_dump or some batch process with very slow queries your report analyze will be annoyed by those queries taking too much place in the report. Before that release it was a pain to exclude those queries from the report. Now you can use the --exclude-time command line option to exclude all traces matching the given time regexp from the report. For example, let's say you have a pg_dump at 13:00 each day during half an hour, you can use pgbadger as follow:

pgbadger --exclude-time "2013-09-.* 13:.*" postgresql.log

If your are also running a pg_dump at night, let's say 22:00, you can write it as follow:

pgbadger --exclude-time '2013-09-\d+ 13:[0-3]' --exclude-time '2013-09-\d+ 22:[0-3]' postgresql.log

or more shortly:

pgbadger --exclude-time '2013-09-\d+ (13|22):[0-3]' postgresql.log

Exclude time always require the iso notation yyyy-mm-dd hh:mm:ss, even if log format is syslog. This is the same for all time related options. Take care that this option has a high cost on the parser performances.

Links & Credits

DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Keith Fiske, Marco Baringe, Herve Werner, Den Untevskiy and Mael Rimbault. The new HTML report was designed by Art Is Code.

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.

  • Download : http://dalibo.github.io/pgbadger/
  • Mailing List : https://listes.dalibo.com/cgi-bin/mailman/listinfo/pgbagder

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

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

10.17.2013 - DbWrench Database Design v3.0.1 Released



View PostgreSQL-Press related news.

DbWrench Database Design v3.0.1 Released

Version 3.0.1 is a major milestone in DbWrench development and the first release of version 3.

This release focused on significant enhancements to the diagram editor. These enhancements include:

- Diagram lines are now movable.

- A new right angle linking algorithm to reduce line collisions and overlap with glyphs.

- A new diagram glyph color fill algorithm to make diagram glyphs more readable.

- Improved memory management to further improve performance.

A free trial download of this latest version is available at www.dbwrench.com.

Screen shots can be viewed here.

More About DbWrench

DbWrench is designed to increase the productivity of database developers by making creating and modifying databases much easier.

It's features include:

- Graphic entity relation diagram (ERD) designer

    - Forward engineer database designs with automatic SQL DDL script generation

    - Reverse engineer and visualize existing databases

    - A built in syntax highlighting SQL query editor

    - Runs on Windows, Mac OSX and Linux all in a single license
Full View / NID: 46001 / Submitted by: The Zilla of Zuron

10.11.2013 - E-Maj 1.1.0 released



View PostgreSQL-Press related news.

A new E-Maj version, named 1.1.0, is now available from pgxn.org or github.

E-Maj is an Open Source extension for PostgreSQL. It contains functions to log updates performed on one or several sets of tables, and cancel ("rollback") these updates if needed, resetting a tables set to a predefined stable state. A dedicated plugin for phpPgAdmin also brings a nice GUI to these features.

The main improvement of this 1.1.0 version resides in the E-Maj rollback mechanism. It has been largely improved in order to get better performance and to allow administrator to monitor in progress operations. Functions that generate sql scripts from logged updates have been also enhanced.

The documentation and the CHANGES file supplied with the extension give all the details about the E-Maj features and usage and the latest improvements.

E-Maj 1.1.0 supports postgres version 8.3 to 9.3.

All E-Maj users working with previous versions are invited to upgrade (supplied migration scripts may help in performing this operation).

Have fun with E-Maj !

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

10.10.2013 - PostgreSQL 2013-10-10 Update Release



View PostgreSQL-Press related news.

The PostgreSQL Global Development Group has released a bug-fix update to all current versions of the PostgreSQL database system, including versions 9.3.1, 9.2.5, 9.1.10, 9.0.14, and 8.4.18. This release fixes many minor issues reported by our community over the last six months. All users should update their PostgreSQL installations at the next regular maintenance window.

In this release are fixes for the recently-released version 9.3, including:

  • Update hstore extension with JSON functionality
  • Prevent memory leak when creating range indexes
  • Fix libpq SSL deadlock bug

In addition to the above, there are a few dozen minor bug fixes for older versions. These patches were already included in 9.3.0 when released. Among them are:

  • Guarantee transmission of all WAL files before replica failover
  • Prevent downcasing of non-ASCII identifiers
  • Fix several minor memory leaks
  • Correct overcommit behavior when using more than 24GB of work memory
  • Improve planner cost estimates for choosing generic plans
  • Fix estimates of NULL rows in boolean columns
  • Make UNION ALL and inheritance query plans recheck parameterized paths
  • Correct pg_dump bugs for foreign tables, views, and extensions
  • Prevent a parallel pg_restore failure on certain indexes
  • Make REINDEX revalidate constraints
  • Prevent two deadlock issues in SP-GIST and REINDEX CONCURRENTLY
  • Prevent GiST index lookup crash
  • Fix several regular expression failures
  • Allow ALTER DEFAULT PRIVILEGES to work on all schemas
  • Loosen restrictions on keywords
  • Allow various spellings of infinity
  • Expand ability to compare rows to records and arrays
  • Prevent psql client crash on bad PSQLRC file
  • Add spinlock support for ARM64

Note that users of the hstore extension on version 9.3 must take an additional, post upgrade step of running "ALTER EXTENSION hstore UPDATE" in each database after update.

As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional, post-update steps; see the Release Notes for details.

Links: * Download * Release Notes

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

10.02.2013 - Announcing PostgreSQL Studio 1.0



View PostgreSQL-Press related news.

OpenSCG is pleased to announce the release of PostgreSQL Studio 1.0. PostgreSQL Studio is an open-source, web-based GUI for PostgreSQL. It allows users to manage and query their database from a browser.

Version 1.0 of PostgreSQL Studio is distributed under the PostgreSQL License. Some of its key features include:

  • Easy to use AJAX web interface
  • Secure access over HTTPS
  • Robust object wizards
  • Query editor with syntax highlighting
  • Cross platform and easy to install

You can find more information about PostgreSQL Studio at www.postgresqlstudio.org

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

10.01.2013 - PostgresDAC with PostgreSQL 9.3 and RAD Studio XE5 support is out!



View PostgreSQL-Press related news.

This important release introduces support for the PostgreSQL 9.3 and the RAD Studio XE5 (Delphi and C++ Builder personalities).

Full changelog:

  • [!] PostgreSQL 9.3 support added
  • [!] Delphi XE5 and C++ Builder XE5 support introduced
  • [!] OpenSSL 1.0.1e libraries added
  • [+] EPSQLDatabaseError.ErrorSchemaName property added
  • [+] EPSQLDatabaseError.ErrorTableName property added
  • [+] EPSQLDatabaseError.ErrorColumnName property added
  • [+] EPSQLDatabaseError.ErrorDatatypeName property added
  • [+] EPSQLDatabaseError.ErroConstraintName property added
  • [-] “Filtering DateTime field not working in early versions Delphi” bug fixed

Download

You're welcome to download the PostgresDAC v2.10.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/

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

09.23.2013 - PostgreSQL Code Factory 13.9 released



View PostgreSQL-Press related news.

SQL Maestro Group announces the release of PostgreSQL Code Factory 13.9, a premier GUI tool for querying PostgreSQL database and managing the data.

The new version is immediately available for download.

Top 10 new features:

  1. Improved SQL Editor.
  2. Updated SQL Dump wizard.
  3. Keyboard-interactive SSH authentication.
  4. New Start Page with quick access to recently connected databases.
  5. Data import from several files to a single table.
  6. Data export to the JSON format.
  7. Enhanced data grids.
  8. The Script Runner tool.
  9. Colored profiles in Database Explorer.
  10. New modern progress windows.

Full press release is available at the SQL Maestro Group website. There are also versions for MySQL, MS SQL Server, Oracle, SQLite, Firebird, DB2, SQL Anywhere and MaxDB.

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

09.09.2013 - PostgreSQL 9.3 released!



View PostgreSQL-Press related news.

The PostgreSQL Global Development Group announces the release of PostgreSQL 9.3, the latest version of the world's leading open source relational database system. This release expands PostgreSQL's reliability, availability, and ability to integrate with other databases. Users are already finding that they can build applications using version 9.3 which would not have been possible before.

"PostgreSQL 9.3 provides features that as an app developer I can use immediately: better JSON functionality, regular expression indexing, and easily federating databases with the Postgres foreign data wrapper. I have no idea how I completed projects without 9.3," said Jonathan S. Katz, CTO of VenueBook.

Writable External Data

Version 9.3 makes PostgreSQL's Foreign Data Wrappers writable, enabling two-way data interchange between systems. Today's complex IT environments involve multiple databases and semi-structured data sources, and PostgreSQL helps you integrate them into a coherent stack. The project has also released postgres_fdw, a higher-performance, read/write PostgreSQL-to-PostgreSQL federation driver.

"Writable foreign data wrappers enable us to plug in and seamlessly test various backend alternatives, allowing us to address different needs quickly and prototype intelligently," explained Lee Holloway, Co-founder and Lead Engineer at CloudFlare. "It is exciting to conceive and toss up new data stores (including our in-house experimental ones written in Go) and then watch them read, write, and even transact each other."

Enhanced Reliability and Availability

"Postgres has been my favorite choice for its well known stability, robustness, strong coherency, safety, ACID, and SQL conformance," said Pascal Bouchareine, director of research and development at Gandi.net. "I'm especially excited to hear more about the fast failover coming in 9.3."

This new release includes features to further improve and extend PostgreSQL's well-known reliability and availability:

  • Data Page Checksums: help administrators quickly detect failing disks and bad hardware that corrupts data
  • Fast Failover: enables sub-second switchoffs from master to replica, supporting "carrier-grade" availability
  • Streaming-Only Remastering: easier, faster reconfiguration of cascading replicas after failover

Developer-friendly Features

As with every annual release, PostgreSQL 9.3 includes many features to make working with PostgreSQL easier, more flexible and more fun for application developers, administrators and architects. These features include:

  • Additional JSON constructor and extractor methods
  • Automatically updatable VIEWs
  • Parallel pg_dump to speed backups of large databases
  • LATERAL JOINs

Further, PostgreSQL 9.3's User-Defined Background Workers allow developers to write task managers, request handlers, parallel processors, queuing tools and other helper applications to enable PostgreSQL as a workload coordinator. One example of this already released is Mongres, a background worker which accepts MongoDB queries, interprets them and passes them on to PostgreSQL.

Links

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

09.05.2013 - Barman 1.2.3 released



View PostgreSQL-Press related news.

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

This minor release adds compatibility with PostgreSQL 9.3.

It also introduces support for the "--target-name" recovery option, which allows to restore to a named point previously specified with pg_create_restore_point (only for PostgreSQL 9.1 and above users).

Experimental compatibility with Python 3 has also been added. We encourage Python 3 users to test this version of Barman and report any feedback to our development team.

Minor bugs have also been fixed.

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

Links

Release Notes

  • Added support for PostgreSQL 9.3
  • Added support for the "--target-name" recovery option, which allows to restore to a named point previously specified with pg_create_restore_point (only for PostgreSQL 9.1 and above users)
  • Fixed bug #27 about flock() usage with barman.lockfile - many thanks to Damon Snyder (damonsnyder at users.sf.net)
  • Introduced Python 3 compatibility

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's most requested 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: 45759 / Submitted by: The Zilla of Zuron

08.29.2013 - SQL Select 1.3.0.32 released



View PostgreSQL-Press related news.

Yohz Software announces the release of SQL Select 1.3.0.32 on August 29, 2013, and is available for immediate download. SQL Select supports PostgreSQL 7.1 to 9.2, without the need for any additional database drivers.

Changes in this release:

  • Improved display of binary/blob fields in result grid. SQL Select now identifies the data type where possible, and display the type and data size accordingly.
  • Fixed bug with exporting multiple result sets to text files.
  • Fixed bug with not saving Excel header options correctly.
  • Fixed bug with running queries against ODBC connections.

For more details about SQL Select, visit the product page here.

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

08.22.2013 - PostgreSQL 9.3 RC1 Available for Testing



View PostgreSQL-Press related news.

Release Candidate 1 of the next version of PostgreSQL is now available. All of the features of version 9.3 should be available and stable in the this release. We need your assistance to verify that all of these features are bug free.

Information on these features can be found at:

Please download 9.3rc1 as soon as possible and report any bugs, deficiencies, missing documentation, or regressions you find. We're hoping to have a trouble-free 9.3.0 release in just a few weeks, but that depends on your testing. Report any issues you find to pgsql-bugs@postgresql.org, or using our bug reporting form.

Source code and binary installers for most platforms are available from our downloads page.

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

07.19.2013 - SQL Spreadsheets 2.1.0.15 released



View PostgreSQL-Press related news.

Yohz Software has just released SQL Spreadsheets 2.1.0.15, a Windows application that lets you export result sets to Excel spreadsheets with embedded images and links to blob data, and deliver them to end users via email, ftp or file copy. It supports various database servers, including PostgreSQL 7.1 upwards.

SQL Spreadsheets allows you to:

  • export result sets to spreadsheets and embed images directly in your spreadsheets
  • create links in your spreadsheets to exported binary files
  • automatically identify most common image formats stored in your blob columns
  • automatically identify most common file formats stored in your blob columns
  • deliver the spreadsheets to your users via ftp, email or file copy
  • schedule jobs to run periodically to export data to spreadsheets
  • connect to PostgreSQL databases without the need to install any additional drivers

Links

About Yohz Software

Yohz Software is a micro-ISV specialising in developing database applications.

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

07.09.2013 - PostgreSQL Maestro 13.7 released



View PostgreSQL-Press related news.

SQL Maestro Group announces the release of PostgreSQL Maestro 13.7, a powerful Windows GUI solution for PostgreSQL database server administration and database development.

The new version is immediately available for download.

Top 10 new features:

  1. Support for foreign data management objects.
  2. Improved support for composite types.
  3. Keyboard-interactive SSH authentication.
  4. Enhanced SQL Dump wizard.
  5. New Nullable Column Checker tool.
  6. New Start Page with quick access to recently connected databases.
  7. Advanced metadata filtering abilities.
  8. Improved SQL Editor and Script Runner.
  9. Highlighted key columns and multi-column lookup editors in the data grids.
  10. Colored profiles in Database Explorer.

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

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

07.03.2013 - PGConf.EU 2013 now open for registration



View PostgreSQL-Press related news.

PostgreSQL Conference Europe 2013 in Dublin, Ireland, on October 29th - November 1st, 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 2013 edition is now open for registration to all attendees. Register before September 15 and receive almost 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 29th, 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!

To register, access the registration form on the website.

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

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

07.02.2013 - New Opportunities for PostgreSQL Backup from Novosoft Handy Backup



View PostgreSQL-Press related news.

Novosoft LLC, one of the leading providers of backup solutions for home and corporate users, has launched an add-on for their popular software Handy Backup. The new plug-in helps to back up PostgreSQL databases in a simple and convenient way.

"PostgreSQL is one of the fastest, most widely used, and reliable free database management systems. It satisfies the requirements of all kinds of consumers: it’s popular among individual programmers and is also used by large corporations. To meet market’s need of information safety, we have implemented advanced support for PostgreSQL backup in Handy Backup. Our new solution is one of the most reliable ways to perform PostgreSQL backup and, I hope, will be appreciated by users,” – said Aleksey Dolgushev, Head of Handy Backup Business Development Department.

PostgreSQL functionality is included in business editions of Handy Backup (Small Server and Network Server) and can be added to other versions through a purchase of a respective plug-in.

The program lets users back up PostgreSQL tables located on both local and remote computers without stopping them due to the Hot Backup technology.

The plug-in presents the smart scheduler that allows setting up program only once to run backup and restore tasks automatically on a minute to monthly basis. The software can be launched as Windows service and will perform backups on time even if a user is not logged on.

Handy Backup provides assured protection for backups: all copies can be saved with advanced encryption and can be protected by password.

PostgreSQL backups could be saved to hard drives, local and remote servers including FTP/SFTP/FTPS servers, WebDav storage, and popular cloud storages such as Amazon S3, Google Drive and others. All copies could be saved with ZIP-compression to minimize required storing space.

Handy Backup is claimed to be one of the market’s most effective solutions for PostgreSQL backup with a broad range of useful features.

More information about Handy Backup can be found on the official website: http://handybackup.net

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

06.27.2013 - PostgreSQL 9.3 Beta 2 Now Available



View PostgreSQL-Press related news.

The second beta release of PostgreSQL 9.3 is now available. This beta contains updated and debugged previews of all of the features which will be available in version 9.3, and is ready for testing by the worldwide PostgreSQL community. Please download, test, and report what you find.

Changes Since Beta 1

The following changes and bug fixes have been made since Beta 1. If you tested a feature in the previous beta, please retest it now to make sure that any issues you discovered have been fixed.

  • prevent xid gaps in Hot Standby startup
  • prevent insertion deadlocks with SP-GiST indexes
  • add user-visible "updatable" flag for foreign tables and views
  • fix two issues with JSON and Unicode
  • make sure that pg_isready displays correct connection info
  • fix pg_dump dependancy order for EventTriggers
  • fix regression tests for postgres_fdw
  • fix pg_xlogdump -r
  • array_remove() no longer emits broken empty arrays
  • fix formatting of automatically generated recovery.conf file
  • simplify handling of crashes after fast failover
  • allow CREATE FOREIGN TABLE to include SERIAL columns
  • make the word "FOREIGN" optional in "ALTER TABLE"
  • translation updates merged
  • many documentation updates

Additionally, all bug fixes prepared for back-branches of PostgreSQL have been applied to Beta 2.

For a full listing of the features in version 9.3 Beta, please see the release notes. Additional descriptions and notes on the new features are available on the 9.3 Features Wiki Page.

Test 9.3 Beta 2 Now

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.3 Beta 2 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 2 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.3 Beta 2, from our download page. Some binary installers for various platforms, including Solaris and FreeBSD, are already available; other will become available over the next week.

Full documentation of the new version is available online, and also installs with PostgreSQL.

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

06.17.2013 - Barman 1.2.1 released



View PostgreSQL-Press related news.

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

This minor release introduces support for bandwidth limitation through the "bandwidth_limit" option. This option allows administrators to set the maximum number of kilobytes per second for backup and recovery operations. Different bandwidth caps can be set for different servers.

More control on bandwidth limitations can be achieved through the "tablespace_bandwidth_limit" option that allows to cap the bandwidth usage for one or more specific PostgreSQL tablespaces.

By default, no bandwidth limitation is enforced, making Barman 1.2.1 fully compatible with configuration files from previous versions. This set of features gives administrators finer control on regular backup activities, reducing the impact of these operations on live systems.

Minor bugs have also been fixed.

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

Links

Release Notes

  • Added the "bandwidth_limit" global/server option which allows to limit the I/O bandwidth (in KBPS) for backup and recovery operations
  • Added the "tablespace_bandwidth_limit" global/server option which allows to limit the I/O bandwidth (in KBPS) for backup and recovery operations on a per tablespace basis
  • Added /etc/barman/barman.conf as default location
  • Bug fix: avoid triggering the minimum_redundancy check on FAILED backups (thanks to Jérôme Vanandruel)

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's most requested 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: 45364 / Submitted by: The Zilla of Zuron
  Popular Tech News  
  Most Viewed News  
  Top Affiliates  
.....