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

Your Technical Computer Information Resource!  
     
  Server Applications Technical Updates [Page: 1 of 105] @ TACKtech Corp.  

04.28.2016 - PHP 5.5.35 Release



View PHP related news. The PHP development team announces the immediate availability of PHP 5.5.35. This is a security release. Several security bugs were fixed in this release. All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.35 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 59254 / Submitted by: The Zilla of Zuron

04.28.2016 - PHP 5.6.21 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.21. This is a security release. Several security bugs were fixed in this release. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.21 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 59253 / Submitted by: The Zilla of Zuron

04.19.2016 - Postgres-XL 9.5 R1 Released!



View PostgreSQL-Press related news.

The Postgres-XL community is pleased to announce the 1st release of Postgres-XL 9.5. This release has been fully synced up till PostgreSQL 9.5.2.

Postgres-XL is a massively parallel database built on top of, and very closely compatible with PostgreSQL 9.5 and its set of advanced features. Postgres-XL is fully open source and many parts of it will feed back directly or indirectly into later releases of PostgreSQL, as we begin to move towards a fully parallel sharded version of core PostgreSQL.

Postgres-XL is different because it supports both Business Intelligence and OLTP workloads in the same horizontally scalable server. This allows Postgres-XL to support a diverse range of workloads

  • OLTP workloads that need write-scalability as well as read-scalability
  • Business Intelligence requiring OLAP with massive parallelism
  • Operational Data Store/ Central Data Backbone
  • Distributed Key-Value store using JSONB, similar to NoSQL
  • Internet of Things applications
  • Mixed-workload environments

Star schema style SQL queries exhibit large performance gains from massively parallel processing (MPP). Many queries show fully linear performance gains, for example a 16-node XL cluster is 16 times faster than PostgreSQL on one node. Postgres-XL is able to successfully complete the complex TPC-H business intelligence benchmark, showing its capability to address much more than basic operations.

Besides proving its mettle on Business Intelligence workloads, Postgres-XL has performed remarkably well on OLTP workloads when running pgBench (based on TPC-B) benchmark. In a 4-Node (Scale: 4000) configuration, compared to PostgreSQL, XL gives up to 230% higher TPS (-70% latency comparison) for SELECT workloads and up to 130% (-56% latency comparison) for UPDATE workloads. Yet, it can scale much, much higher than even the largest single node server.

Postgres-XL’s High Availability functionality has also been enhanced in this release. Popular features such as BRIN indexes, JSONB and GIN index compression are fully supported, as are many popular extensions.

Postgres-XL is available for download here: www.postgres-xl.org/download/ You can go through XL’s comprehensive documentation here: files.postgres-xl.org/documentation/

We expect R2 to bring further features to Postgres-XL 9.5 in the next few months.

2ndQuadrant has led the development of Postgres-XL 9.5, building upon the work of many others over a long period of continuous development, with easily more than 10 man years of development. After six months of professional formal alpha-level testing & tuning, and an additional 2 months in Beta phase with user feedback, the project has now reached the next stage of maturity and we are now ready to release it for production use.

The research leading to these results has received funding from the European Union’s Seventh Framework Programme (FP7/2007-2015) under grant agreement n° 318633. Postgres-XL has also received support and assistance from European Space Agency's Gaia project, as well as other users in industry.

For more details, please visit: 2ndQuadrant.com/resources/postgres-xl/

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

04.18.2016 - PostgresOpen 2016 - Call For Papers!



View PostgreSQL-Press related news.

Greetings!

The Call For Papers for PostgresOpen 2016, being held in Dallas, Texas from September 13th to 16th, is now open!

If you are working with PostgreSQL, please visit:

https://2016.postgresopen.org/callforpapers/

and submit a talk!

Presentations can be on any topic related to PostgreSQL, including, but not limited to, case studies, experiences, tools and utilities, migration stories, existing features, new feature development, benchmarks, performance tuning, and more!

The 2016 PostgresOpen Committee looks forward to bringing the best PostgreSQL presentations and tutorials from speakers around the world to Dallas, Texas! We're only able to do that with support from our great sponsors! If you are interested in sponsoring, please visit our sponsoring campaign:

https://2016.postgresopen.org/becomesponsor/

Anyone and everyone in the PostgreSQL community is encouraged to submit a talk. Talks will be accepted up until May 30th, Anywhere on Earth (AoE), also known as: 2015-05-30 23:59:59-12:00.

Speakers will be notified by June 6th, 2015 AoE, with the schedule to be published once selected speakers have confirmed.

Early Bird registration for PostgresOpen 2016 will open on May 9th!

Join us in celebrating our 6th conference year! We look forward to seeing everyone in Dallas!

Any questions? Please contact: program2016@postgresopen.org.

Stephen Frost

PostgresOpen 2016 Committee Chair

http://2016.postgresopen.org

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

04.17.2016 - pgBackRest 1.0 Released



View PostgreSQL-Press related news.

April 17, 2016: Crunchy Data is proud to announce pgBackRest 1.0, Reliable PostgreSQL Backup & Restore.

Release 1.0

The first stable of release of pgBackRest introduces a new, more capable repository format, simpler configuration, and comprehensive support for backup and restore of symlinked directories and files.

There are a number of important changes in pgBackRest 1.0 so be sure to read the release notes very carefully before upgrading.

Links

Features

Multithreaded Backup & Restore

Compression is usually the bottleneck during backup operations but, even with now ubiquitous multi-core servers, most database backup solutions are still single-threaded. pgBackRest solves the compression bottleneck with multithreading.

Utilizing multiple cores for compression makes it possible to achieve 1TB/hr raw throughput even on a 1Gb/s link. More cores and a larger pipe lead to even higher throughput.

Local or Remote Operation

A custom protocol allows pgBackRest to backup, restore, and archive locally or remotely via SSH with minimal configuration. An interface to query PostgreSQL is also provided via the protocol layer so that remote access to PostgreSQL is never required, which enhances security.

Full, Incremental, & Differential Backups

Full, differential, and incremental backups are supported. pgBackRest is not susceptible to the time resolution issues of rsync, making differential and incremental backups completely safe.

Backup Rotation & Archive Expiration

Retention polices can be set for full and differential backups to create coverage for any timeframe. WAL archive can be maintained for all backups or strictly for the most recent backups. In the latter case WAL required to make older backups consistent will be maintained in the archive.

Backup Integrity

Checksums are calculated for every file in the backup and rechecked during a restore. After a backup finishes copying files, it waits until every WAL segment required to make the backup consistent reaches the repository.

Backups in the repository are stored in the same format as a standard PostgreSQL cluster (including tablespaces). If compression is disabled and hard links are enabled it is possible to snapshot a backup in the repository and bring up a PostgreSQL cluster directly on the snapshot. This is advantageous for terabyte-scale databases that are time consuming to restore in the traditional way.

All operations utilize file and directory level fsync to ensure durability.

Backup Resume

An aborted backup can be resumed from the point where it was stopped. Files that were already copied are compared with the checksums in the manifest to ensure integrity. Since this operation can take place entirely on the backup server, it reduces load on the database server and saves time since checksum calculation is faster than compressing and retransmitting data.

Streaming Compression & Checksums

Compression and checksum calculations are performed in stream while files are being copied to the repository, whether the repository is located locally or remotely.

If the repository is on a backup server, compression is performed on the database server and files are transmitted in a compressed format and simply stored on the backup server. When compression is disabled a lower level of compression is utilized to make efficient use of available bandwidth while keeping CPU cost to a minimum.

Delta Restore

The manifest contains checksums for every file in the backup so that during a restore it is possible to use these checksums to speed processing enormously. On a delta restore any files not present in the backup are first removed and then checksums are taken for the remaining files. Files that match the backup are left in place and the rest of the files are restored as usual. Since this process is multithreaded, it can lead to a dramatic reduction in restore times.

Advanced Archiving

Dedicated commands are included for both pushing WAL to the archive and retrieving WAL from the archive.

The push command automatically detects WAL segments that are pushed multiple times and de-duplicates when the segment is identical, otherwise an error is raised. The push and get commands both ensure that the database and repository match by comparing PostgreSQL versions and system identifiers. This precludes the possibility of misconfiguring the WAL archive location.

Asynchronous archiving allows compression and transfer to be offloaded to another process which maintains a continuous connection to the remote server, improving throughput significantly. This can be a critical feature for databases with extremely high write volume.

Tablespace & Link Support

Tablespaces are fully supported and on restore tablespaces can be remapped to any location. It is also possible to remap all tablespaces to one location with a single command which is useful for development restores.

File and directory links are supported for any file or directory in the PostgreSQL cluster. When restoring it is possible to restore all links to their original locations, remap some or all links, or restore some or all links as normal files or directories within the cluster directory.

Compatibility with PostgreSQL >= 8.3

pgBackRest includes support for versions down to 8.3, since older versions of PostgreSQL are still regularly utilized.

About

pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads. Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses a custom protocol for communicating with remote systems. Removing reliance on tar and rsync allows for better solutions to database-specific backup challenges. The custom remote protocol allows for more flexibility and limits the types of connections that are required to perform a backup which increases security.

Crunchy Data supports the ongoing and active development of pgBackRest as an entirely open source project, released under the BSD-compatible MIT license.

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

04.15.2016 - Amazon RDS for PostgreSQL now supports PostgreSQL 9.5



View PostgreSQL-Press related news.

April 8, 2016 – Amazon RDS for PostgreSQL now supports major version 9.5, which contains several new features including UPSERT capability, Row Level Security (RLS) and several Big Data capabilities. In addition to supporting the new major version of PostgreSQL, 9.5, RDS for PostgreSQL also supports new minor versions 9.4.7 and 9.3.12, which contain several enhancements and fixes. All three versions are available to use starting today.

PostgreSQL 9.5 (supported via minor version 9.5.2) offers the following new features:

UPSERT: Shorthand for "INSERT, ON CONFLICT UPDATE", this feature allows new and updated rows to be treated the same way, enabling the database to handle conflicts between concurrent data changes and simplifying application development. Row Level Security (RLS): RLS implements true per-row and per-column data access control which integrates with external label-based security stacks, giving you more control over securing your data. Big Data features: PostgreSQL 9.5 includes multiple new features for integrating with Big Data systems, including BRIN Indexing to create tiny but effective indexes for "naturally ordered" tables; faster sorts using "abbreviated keys" algorithm to sort through text and NUMERIC fields faster; CUBE, ROLLUP and GROUPING SETS to produce reports with multiple levels of summarization to allow integration with OLAP tools such as Tableau; Foreign Data Wrappers (FDWs) with IMPORT FOREIGN SCHEMA and JOIN pushdown to make query connections to external databases easier and more efficient; and TABLESPACE to generate a statistical sample of huge tables to avoid expensive sorting. You can create a new PostgreSQL 9.5.2 database instance with a few clicks on the AWS Management Console (learn how). You may also upgrade an existing PostgreSQL 9.4 instance to version 9.5.2 using major version upgrade. If you wish to upgrade from version 9.3 to 9.5, you will have to perform point-and-click upgrade twice. Each upgrade operation involves a short period of unavailability for your database instance. Learn more about upgrading your database instances.

In addition to PostgreSQL 9.5.2, we also now support PostgreSQL 9.4.7 and 9.3.12, which include several fixes and enhancements as listed here. To learn more about these new versions, please refer to their release notes:

Release Notes for 9.5.2

Release Notes for 9.4.7

Release Notes for 9.3.12

All three versions also now provide visibility into the status of autovacuum by allowing rds_superuser access to autovacuum sessions in pg_stat_activity. Read more about the new features in PostgreSQL 9.5 on the PostgreSQL website. For more details on using Amazon RDS for PostgreSQL, please refer to the Amazon RDS User's Guide.

Amazon RDS

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.

Contact:

Kevin Jernigan

Product Manager, RDS for PostgreSQL

+1-415-710-8828

kmj (at) amazon (dot) com

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

04.12.2016 - E-Maj 1.3.0 is released



View PostgreSQL-Press related news.

I am proud to announce the 1.3.0 version of E-Maj.

E-Maj is a PostgreSQL extension which enables fine-grained write logging and time travel on subsets of the database.

This version mainly adds some functions to protect "tables groups" and "marks" from unattended "E-maj rollbacks". The E-Maj phpPgAdmin plugin has been improved as well to use these new features.

The core extension is available at pgxn.org or github.org. It includes a general presentation and a detailed documentation. The phpPgAdmin plugin is also available at github.org.

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

04.12.2016 - PGConf US 2016 One Week Away - Registrations Closing



View PostgreSQL-Press related news.

There is only 1 week left until one of the biggest PostgreSQL events in the world: PGConf US 2016, which is in New York from April 18th to 20th: http://www.pgconf.us/2016/schedule/

Some highlights:

  • A keynote presented by Parag Goradia, Executive Director, Cloud Services Engineering, GE Digital
  • An awesome set of general sessions on April 19th - 20th
  • The Regulated Industry Summit on April 18th (free with regular conference pass!)
  • Training sessions from seasoned Postgres trainers!
  • A chance to meet fun people from all over the world

…and the biggest PostgreSQL party of the year - come celebrate the PostgreSQL community turning 20! You can signup for the 20th Anniversary Party separately here: http://www.meetup.com/postgresql-3/events/229101241/

Hope to see you at the conference!

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

03.31.2016 - PHP 5.5.34 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.5.34. This is a security release. Several security bugs were fixed in this release. All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.34 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 58804 / Submitted by: The Zilla of Zuron

03.31.2016 - PHP 5.6.20 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.20. This is a security release. Several security bugs were fixed in this release. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.20 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 58803 / Submitted by: The Zilla of Zuron

03.31.2016 - 2016-03-31 Security Update Release



View PostgreSQL-Press related news.

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.2, 9.4.7, 9.3.12, 9.2.16, and 9.1.21. This release fixes two security issues and one index corruption issue in version 9.5. It also contains a variety of bug fixes for earlier versions. Users of PostgreSQL 9.5.0 or 9.5.1 should update as soon as possible.

Security Fixes for RLS, BRIN

This release closes security hole CVE-2016-2193, where a query plan might get reused for more than one ROLE in the same session. This could cause the wrong set of Row Level Security (RLS) policies to be used for the query.

The update also fixes CVE-2016-3065, a server crash bug triggered by using pageinspect with BRIN index pages. Since an attacker might be able to expose a few bytes of server memory, this crash is being treated as a security issue.

Abbreviated Keys and Corrupt Indexes

In this release, the PostgreSQL Project has been forced to disable 9.5's Abbreviated Keys performance feature for many indexes due to reports of index corruption. This may affect any B-tree indexes on TEXT, VARCHAR, and CHAR columns which are not in "C" locale. Indexes in other locales will lose the performance benefits of the feature, and should be REINDEXed in case of existing index corruption. The feature may be re-enabled in future versions if the project finds a solution for the problem. See the release notes, and the wiki page on this issue for more information.

Other Fixes and Improvements

In addition to the above, many other issues were patched in this release based on bugs reported by our users over the last few months. This includes bugs which affect multiple versions of PostgreSQL, such as:

  • Fix two bugs in indexed ROW() comparisons
  • Avoid data loss due to renaming files
  • Prevent an error in rechecking rows in SELECT FOR UPDATE/SHARE
  • Fix bugs in multiple json_ and jsonb_ functions
  • Log lock waits for INSERT ON CONFLICT correctly
  • Ignore recovery_min_apply_delay until reaching a consistent state
  • Fix issue with pg_subtrans XID wraparound
  • Fix assorted bugs in Logical Decoding
  • Fix planner error with nested security barrier views
  • Prevent memory leak in GIN indexes
  • Fix two issues with ispell dictionaries
  • Avoid a crash on old Windows versions
  • Skip creating an erroneous delete script in pg_upgrade
  • Correctly translate empty arrays into PL/Perl
  • Make PL/Python cope with identifier names

This update also contains tzdata release 2016c, with updates for Azerbaijan, Chile, Haiti, Palestine, and Russia, and historical fixes for other regions.

Updating

Users of version 9.5 will want to REINDEX any indexes they created on character columns in non-C locales. Users of other versions who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

All PostgreSQL update releases are cumulative. 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.

Links:

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

03.29.2016 - PL/Java 1.5.0 announced; security note.



View PostgreSQL-Press related news.

PL/Java brings functions, triggers, and types in Java. 1.5.0 supports latest PostgreSQL and Java versions with a range of improvements and fixes.

Project site: http://tada.github.io/pljava/
Release notes: http://tada.github.io/pljava/releasenotes.html

Security note:

Several security issues are addressed in PL/Java 1.5.0, as described in the release notes, so sites running earlier versions are encouraged to update. The release notes also describe practical mitigations to reduce risk until an update can be completed.

Platforms:

PL/Java 1.5.0 works with Java 8, 7, or 6 and all 9.x PostgreSQL versions as well as 8.4. To support projects based on older PostgreSQL forks, PL/Java 1.5.0 is also intended to build with 8.3 and 8.2, but has not been tested on those versions.

PL/Java 1.5.0 resolves reported build issues on several platforms, and new sections of the build documentation specifically cover Mac OS X, Solaris, Ubuntu, and Windows (using Visual Studio or MinGW-64). FreeBSD 10.2 or later is expected to work but has not been tested.

Changes:

PL/Java 1.5.0 brings more complete, usable, and documented capability for Java-implemented user-defined base types, composite types, and mirrors of existing PostgreSQL types, an annotation-driven SQL generator reducing the effort of writing deployment SQL by hand, and many smaller improvements and fixes detailed in the release notes. The supplied examples cover many of these features.

Availability:

PL/Java 1.5.0 is available from GitHub as a source release, which builds quickly using Maven:

Release page: https://github.com/tada/pljava/releases/tag/V1_5_0

This wiki page will add links to prebuilt packages that become available.

Many thanks to all the individuals and organizations listed in the release notes under Credits.

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

03.24.2016 - PostgreSQL PHP Generator 16.3 released



View PostgreSQL-Press related news.

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

The new version is immediately available at
http://www.sqlmaestro.com/products/postgresql/phpgenerator/.

Live demo and Video tour are available too.

Top 10 new features:

  1. Out-of-the-box Charts.
  2. Enhanced sidebar menus.
  3. Compact themes.
  4. Embedded Video support.
  5. Customizable success/error messages.
  6. Enhanced data export tools.
  7. Custom form titles.
  8. Event management enhancements.
  9. Detailed descriptions.
  10. PHP configuration settings.

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

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

03.21.2016 - Database .NET v18 released



View PostgreSQL-Press related news.

I am happy to announce the new major release of Database .NET v18. It is an innovative, powerful and intuitive multiple database management tool, With it you can browse objects, design tables, edit rows, export data, run queries and migrate data with a consistent interface.

Free, All-In-One, Portable, Single executable file and Multi-language.

Major New features from version 17.1 to 18.0:

  • Compatible with PostgreSQL 8.4 ~ 9.5+
  • Added Visual Execution Plan for PostgreSQL 9.0+
  • Massive performance improvements
  • Added support for Cancelling executing command
  • Added Inspect Object
  • Added Dark Mode
  • Added support for Renaming Results tab
  • Single click for Browsing and Editing
  • Improved Data Import and Export
  • Improved Data Editor and Browser
  • Improved Generating Batch Scripts
  • Improved SQL Editor
  • Improved AutoComplete and IntelliSense
  • Improved SQL File Version Control
  • Improved Database Migration and Data Synchronization (Pro)
  • ...and more

The new version is immediately available for download.

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

03.03.2016 - PHP 5.5.33 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.5.33. This is a security release in which two security bugs were fixed. All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.33 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 58373 / Submitted by: The Zilla of Zuron

03.03.2016 - PHP 5.6.19 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.19. This is a security release in which several security bugs were fixed. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.19 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 58372 / Submitted by: The Zilla of Zuron

02.29.2016 - Barman 1.6.0 released



View PostgreSQL-Press related news.

29 February 2016: 2ndQuadrant is proud to announce the release of version 1.6.0 of Barman, Backup and Recovery Manager for PostgreSQL.

Major release

This major release introduces WAL streaming support, improving disaster recovery capabilities of PostgreSQL backup solutions based on Barman, by reducing Recovery Point Objective consistently to nearly 0. Currently, Barman still requires standard WAL archiving based on PostgreSQL's 'archive_command'. This limitation will be removed once Barman supports replication slots (available from PostgreSQL 9.4).

Barman 1.6.0 introduces also support to pigz compression, as well as Python-native gzip and bzip2 compression algorithms.

Bug fixes

Minor bugs have also been fixed.

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

Links

Release notes

  • Support for streaming replication connection through the 'streaming_conninfo' server option

  • Support for the 'streaming_archiver' option that allows Barman to receive WAL files through PostgreSQL's native streaming protocol. When set to 'on', it relies on 'pg_receivexlog' to receive WAL data, reducing Recovery Point Objective. Currently, WAL streaming is an additional feature (standard log archiving is still required)

  • Implement the 'receive-wal' command that, when 'streaming_archiver' is on, wraps 'pg_receivexlog' for WAL streaming. Add '--stop' option to stop receiving WAL files via streaming protocol. Add '--reset' option to reset the streaming status and restart from the current xlog in Postgres.

  • Automatic management (startup and stop) of 'receive-wal' command via 'cron' command

  • Support for the 'path_prefix' configuration option

  • Introduction of the 'archiver' option (currently fixed to 'on') which enables continuous WAL archiving for a specific server, through log shipping via PostgreSQL's 'archive_command'

  • Support for 'streaming_wals_directory' and 'errors_directory' options

  • Management of WAL duplicates in 'archive-wal' command and integration with 'check' command

  • Verify if 'pg_receivexlog' is running in 'check' command when 'streaming_archiver' is enabled

  • Verify if failed backups are present in 'check' command

  • Accept compressed WAL files in incoming directory

  • Add support for the pigz compressor (thanks to Stefano Zacchiroli)

  • Implement pygzip and pybzip2 compressors (based on an initial idea of Christoph Moench-Tegeder)

  • Creation of an implicit restore point at the end of a backup

  • Current size of the PostgreSQL data files in 'barman status'

  • Permit 'archive_mode=always' for PostgreSQL 9.5 servers (thanks to Christoph Moench-Tegeder)

  • Complete refactoring of the code responsible for connecting to PostgreSQL

  • Improve messaging of cron command regarding sub-processes

  • Native support for Python >= 3.3

  • Changes of behaviour:

    • Stop trashing WAL files during 'archive-wal' (commit:e3a1d16)
  • Bug fixes:
    • Atomic WAL file archiving (#9 and #12)
    • Propagate "-c" option to any Barman subprocess (#19)
    • Fix management of backup ID during backup deletion (#22)
    • Improve 'archive-wal' robustness and log messages (#24)
    • Improve error handling in case of missing parameters

Download

About

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, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups. Barman is distributed under GNU GPL 3.

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

02.19.2016 - JDBC 1208 released



View PostgreSQL-Press related news.

Mostly bug fixes and cleanup.

See the changelog for details

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

02.18.2016 - Postgres-XL 9.5 R1 Beta1 Announced



View PostgreSQL-Press related news.

The Postgres-XL community is pleased to announce Postgres-XL 9.5 R1 Beta1.

Postgres-XL is a massively parallel database built on top of, and very closely compatible with PostgreSQL 9.5 and its set of advanced features. Postgres-XL is fully open source and many parts of it will feed back directly or indirectly into later releases of PostgreSQL, as we begin to move towards a fully parallel sharded version of core PostgreSQL.

Postgres-XL is different because it supports both Business Intelligence and OLTP workloads in the same horizontally scalable server. This allows Postgres-XL to support a diverse range of workloads

  • OLTP workloads that need write-scalability as well as read-scalability
  • Business Intelligence requiring OLAP with massive parallelism
  • Operational Data Store/ Central Data Backbone
  • Distributed Key-Value store using JSONB, similar to NoSQL
  • Internet of Things applications
  • Mixed-workload environments

Star schema style SQL queries exhibit large performance gains from massively parallel processing (MPP). Many queries show fully linear performance gains, for example a 16-node XL cluster is 16 times faster than PostgreSQL on one node. Postgres-XL is able to successfully complete the complex TPC-H business intelligence benchmark, showing its capability to address much more than basic operations.

Postgres-XL’s High Availability functionality has also been enhanced in this release. Popular features such as BRIN indexes, JSONB and GIN index compression are fully supported, as are many popular extensions.

Postgres-XL is available for download here: http://www.postgres-xl.org/download/ You can go through XL’s comprehensive documentation here: http://files.postgres-xl.org/documentation/index.html

2ndQuadrant has led the development of Postgres-XL 9.5, building upon the work of many others over a long period of continuous development, with easily more than 10 man years of development. After six months of professional formal alpha-level testing and tuning, the project has now reached the next stage of maturity and we are now ready to have initial users contribute their comments and usage reports to the Postgres-XL community at postgres-xl-bugs@lists.sourceforge.net.

The research leading to these results has received funding from the European Union’s Seventh Framework Programme (FP7/2007-2015) under grant agreement n° 318633. Postgres-XL has also received support and assistance from European Space Agency's Gaia project, as well as other users in industry.

For more details, please visit: http://2ndQuadrant.com/resources/postgres-xl/

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

02.15.2016 - PGConf US 2016 Schedule Posted; Registration Open



View PostgreSQL-Press related news.

The PGConf US 2016 schedule is now available:

http://www.pgconf.us/2016/schedule/

PGConf US 2016 is taking place in New York City from April 18th to April 20th at the New York Marriott Brooklyn Bridge. On April 18th, we are pleased to offer six training sessions as well as the Second Annual Regulated Industry Summit, and our usual program on April 19th and 20th.

Did you know that PostgreSQL turns 20 years old this year? We are celebrating by throwing an elephantine (in other words, a gigantic) birthday party for the community on April 19th. The birthday party will be open to the general public and we will have more details on the PGConf US website in the coming days. Come celebrate PostgreSQL turning 20 at PGConf US!

We are pleased to have Parag Goradia, Executive Director of Cloud Services Engineering at General Electric Digital as our keynote speaker at PGConf US 2016. Parag will be discussing how PostgreSQL is playing a crucial role in GE’s software strategy and is looking forward to sharing his story with the community.

And of course, we would not produce PGConf US 2016 without the awesome talks from our speakers. We had just shy of 140 submissions for 44 session slots and 6 and are delighted to present a group of speakers coming from all over the world and volunteering their time to talk about their experiences with PostgreSQL.

Some, but not all, highlights:

  • PostgreSQL deployments and strategies at enterprises such as MasterCard, Tencent, Capital One, Blackberry, MongoDB, the European Space Agency, InMobi, and more!
  • Want to see what the future of PostgreSQL holds? Come learn how PostgreSQL is developed and how it operates from Major Contributors and PostgreSQL hackers in our internals track.
  • Prefer Ruby and Java to SQL? Not a problem: our developer track has you covered so you can learn to take advantage of PostgreSQL’s robustness.

Want to attend? Our registration is open! Please visit http://www.pgconf.us/2016/tickets/ for registration information. Through February 29th 2016, we are offering a 10% discount on the Regular Admission to the global PostgreSQL community with the code PGDG

PGConf US 2016 is hosted by the United States PostgreSQL Association, a nonprofit 501(c)(3) created to support PostgreSQL in the United States through user group development, conferences, educational initiatives, and fun. There is no way we would be able to produce PGConf US 2016 without the generous support of our Platinum and Gold sponsors:

For more information, please visit http://www.pgconf.us/

We look forward to seeing you in April!

Full View / NID: 58083 / Submitted by: The Zilla of Zuron
  Most Viewed  
  Quick Links  
  Top Affiliates  
........