Jelenlegi hely

PostreSQL.org

Feliratkozás PostreSQL.org hírcsatorna csatornájára
PostgreSQL news
Frissítve: 1 nap 21 óra

Open letter : call to software vendors for an enterprise-grade support of PostgreSQL Database

2017, december 7 - 01:00

PARIS, december 6, 2017

We, at the PostgreSQL Cross-Enterprise Work Group, a non-profit organization advocating for the adoption and use of PostgreSQL, invite software vendors that don’t already do so to take steps to support PostgreSQL as a database management system (DBMS). The ambition of this initiative is to incite them to adapt quickly to the irresistible IT transformation in progress in public and private companies.

Founded in November 2016, PostgreSQL Cross-Enterprise Work Group is a dedicated task force inside the PostgreSQLFr non-profit association, gathering more than 20 participants from public organizations, CAC40 companies, start-ups, including Air France, Carrefour, CASDEN, CNES, EDF, GIE AGORA (MSA), ISOCEL (Leclerc), MAIF, Météo France, French Ministry of Education, PeopleDoc, SNCF, Société Générale and Tokheim Services Group.

Engaged in a common open-source transformation initiative, members of the Work Group have chosen to store all or part of their critical enterprise data in PostgreSQL databases.

The initiative aims at lowering the impact of vendor lock-in strategies in the enterprise database field. A long-standing near-monopolist position in this field has led to a situation in which customers are now facing important risks. They became so dependent on their traditional vendors that they could not move to another vendor without substantial switching costs. This created a context which favors the vendor at the expense of the customer.

With the rise of open source software solutions popularity, mainly due to their maturity, performance and stability, many firms looking for an alternative to proprietary DBMS did migrate or are considering the migration to the open source database PostgreSQL.

PostgreSQL offers qualities of robustness, performance, reliability and respect for open standards. It is a liberal open source license that allows companies to use it without restriction, without fear of audits, and lets the freedom to contribute to its development and ecosystem.

Members of the Work Group agreed to provide mutual assistance, share knowledge, contribute to the project and promote it to increase its public adoption, while strictly respecting procurement processes.

Increased cooperation with third party software vendors

As part of this initiative, and in order to answer the wide variety of business needs of its current and future members, the Work Group now calls to the cooperation of Independent Software Vendors.

"As IT transformation progresses, PostgreSQL becomes a de facto standard in our infrastructures. Part of our business applications rely on third party software we use and that come with proprietary database solutions which require us to override our corporate strategies and policies. To ensure we will continue to use software that do not support PostgreSQL yet, software providers are now urged to take the first steps leading to an adequate certification of PostgreSQL." explains Simon CLAVIER, Vice President of PostgreSQLfr association and spokesperson of the Work Group.

"This compliance is already required in our choice criteria for solutions and will be even more in a near future. In return, Software Vendors that certify their solution on PostgreSQL can count on a reliable support of PostgreSQL developers and users community, community in which they will be very welcomed."

Vendors that already support PostgreSQL are invited to come forward and to be added in our reference software list. Those that don't and are considering to become compliant are warmly invited to contact the Work Group on the following email address, indicating the expected date of support and sharing a reference URL : entreprises.contact@postgresql.fr

More about the PostgreSQL Cross-Enterprise Work Group : https://www.postgresql.fr/entreprises/english

Counting on your participation,

Freely,

The PostgreSQL Cross-Enterprise Work Group

NOTE : This page is a translation of the original page in French.

Kategóriák: Informatika

Announcing the Release of OmniDB 2.4

2017, december 7 - 01:00

Oxford, United Kingdom — December 7, 2017

2ndQuadrant announces the release of OmniDB 2.4 This release includes a new real-time monitoring feature for the dashboard. The monitoring feature included in this release, is an interface present both in omnidb-app and omnidb-server. It allows the user to monitor in real-time, the situation of the database with multiple charts and grids for the major part of aspects that need to be monitored: backends, bloat, sizes, among others.

OmniDB is a browser-based database management tool. It is designed to be a powerful, yet lightweight, user-friendly and fast-performing interface for PostgreSQL databases. OmniDB is fully backed by 2ndQuadrant’s world renowned 24/7 Production Support.

The new features in this release are listed below:

  • Custom Monitoring Dashboard: User defined monitoring dashboard with charts and grids, allowing the user to create custom monitoring in a python sandbox.
  • Persistent user data: Configuration files and logs now persist through upgrades of new releases.
  • Bug fixes

For a complete list of changes, including detailed bug fixes, read the OmniDB change tracker here.

OmniDB 2.4 download and installation instructions are available here.

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Kategóriák: Informatika

PostgreSQL PHP Generator Lite Released

2017, december 6 - 01:00

SQL Maestro Group announces the release of PostgreSQL PHP Generator Lite, a free yet powerful GUI frontend for Windows that allows you to generate feature-rich web applications for your PostgreSQL database without programming experience.

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

Top 10 features of the new product:
  1. Reliable and proven basis. PHP Generator Lite is based on exactly the same web engine as his "big brother" PHP Generator Professional, a world-class tool for creating data-driven web applications without writing a single line of code.
  2. No usage limitations. PHP Generator Lite allows you to create unlimited number of websites for unlimited number of users. Generated websites can be used for business or personal purposes.
  3. Customization for your needs. Generated pages can be customized with a lot of GUI settings as well as with user-defined styles and JavaScript. 18 color schemes are included.
  4. Responsive and adaptive. PHP Generator Lite allows you to build websites that look good on any device from a mobile phone to an extra-large desktop.
  5. Data filtering and sorting tools. Your end users will be glad to find records they are looking for or sort their data in a couple of clicks.
  6. Wide spectrum of controls. A bunch of available data grid column types and editors in data input forms will help you to create professionally looking websites with minimal efforts.
  7. Security settings. All you need to protect your data against unauthorized viewing or changing is to turn on just a single option and grant permissions to the users.
  8. Various data sources. Generated pages can be based on tables, views, and SELECT queries.
  9. Website navigation. Such features as sidebar menus, page groups, breadcrumbs, and automatic index page generation are at your disposal.
  10. And last but not least: the new tool is absolutely free.

Hope you'll enjoy our new tool. Full press release is available at the SQL Maestro Group website.

Kategóriák: Informatika

Release: check_pgactivity 2.3

2017, december 4 - 01:00
check_pgactivity version 2.3 released

check_pgactivity is a PostgreSQL plugin for Nagios. This plugin is written with a focus on a rich perfdata set. Every new features of PostgreSQL can be easily monitored with check_pgactivity.

Changelog :

add complete support for PostgreSQL 10, including non-privileged monitoring features add some documentation to help new contributors add ability to use time units for thresholds in service backend_status fix a long-standing bug in service backends_status fix several issues

Here are some useful links: Github repo: https://github.com/OPMDG/check_pgactivity French release note: http://blog.dalibo.com/2017/12/04/Sortie_check_pgactivity_2.3.html

This tool is developed by Thomas Reiss, Jehan-Guillaume de Rorthais and Julien Rouhaud.

Kategóriák: Informatika

DB Doc 5.0 released

2017, november 23 - 01:00

Yohz Software has just released DB Doc 5.0, the PostgreSQL schema documentation tool, and is available for immediate download.

Changes in this version:
  • Added support for PostgreSQL 10.1 databases.
  • Fixed a bug related to the rendering of tables with many columns.
DB Doc benefits:
  • Document a PostgreSQL database in 4 simple steps
  • Create documentation in HTML, CHM, PDF, and MS Word formats
  • Eliminate tedious and time-consuming manual documentation tasks
  • Satisfy audit requirements by keeping complete and timely documentation
  • View inter-object and inter-database dependencies in your documents
  • Document layouts can be fully customizable to suit your requirements
  • Keep teams up to date by distributing timely and accurate documentation
  • Runs on Windows XP to Windows 10
  • Runs on Linux using Wine, so you can use DB Doc on your favorite Linux distribution
  • Supports PostgreSQL 8.3 to 10.1, without the need for any additional database drivers.

For more details about DB Doc, please visit the product page here.

Kategóriák: Informatika

Citus 7.1 Released: Distributed Transaction Support

2017, november 22 - 01:00

Citus Data announces the availability of Citus 7.1. Built to scale out, Citus is an extension to Postgres that is available as open source, enterprise software, and a fully-managed database service on AWS.

Whether you have a multi-tenant application that needs scale, or you need to deliver real-time analytics to your customers, with Citus, you can seamlessly scale your PostgreSQL clusters.

Citus 7.1 adds full SQL support for distributed transactions. This release also expands SQL coverage for parallel subqueries, window functions, and distinct clauses. You can find more information in Citus release notes.

Citus 7.1 is compatible with PostgreSQL 9.6 and 10. You can try Citus 7.1 by following the download instructions or one-click deploy through the Citus Cloud console.

Kategóriák: Informatika

Announcing the Release of repmgr 4.0

2017, november 21 - 01:00

Oxford, United Kingdom - November 21, 2017

2ndQuadrant is proud to announce the release of repmgr 4.0. repmgr has been the most popular tool for PostgreSQL replication and failover management since 2010. It enhances and complements PostgreSQL's built-in replication capabilities, making it easy to set up and manage standby servers, check replication status, and perform administrative tasks such as switchover operations.

The repmgrd daemon provides automatic failover capability to maximise database uptime and can easily be integrated with other tools such as PgBouncer for high application availability.

This new release is a complete rewrite of the existing repmgr codebase, implementing repmgr as a fully-fledged PostgreSQL extension and providing full support for the recently released PostgreSQL 10. This release includes other important enhancements, some of which are listed below:

  • Improved switchover functionality
  • Redesigned failover mechanism
  • --dry-run mode for many operations
  • New “repmgr node rejoin” command to reintegrate former primaries
  • Replication monitoring checks
  • Improved logging output
  • Automatic configuration file detection in RPM and DEB packages
  • Easier upgrade process for future repmgr versions

Read the full release notes for repmgr 4.0 here

repmgr is developed and maintained by 2ndQuadrant. It is fully supported by their respected 24/7 Production Support, providing the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide. repmgr is distributed under GPL v3.

Repmgr 4 download and installation instructions are available here

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Kategóriák: Informatika

PostgreSQL 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, and 9.2.24 released!

2017, november 9 - 01:00

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, and 9.2.24. This release fixes three security issues. This release also fixes issues found in BRIN indexing, logical replication and other bugs reported over the past three months.

All users using the affected versions of PostgreSQL should update as soon as possible. If you use BRIN indexes or contrib/start-scripts, please see the release notes for additional post-upgrade steps.

Security Issues

Three security vulnerabilities have been fixed by this release:

  • CVE-2017-12172: Start scripts permit database administrator to modify root-owned files
  • CVE-2017-15098: Memory disclosure in JSON functions
  • CVE-2017-15099: INSERT ... ON CONFLICT DO UPDATE fails to enforce SELECT privileges
CVE-2017-12172: Start scripts permit database administrator to modify root-owned files

Prior to this release, the startup log file for the postmaster (in newer releases, "postgres") process was opened while the process was still owned by root. With this setup, the database owner could specify a file that they did not have access to and cause the file to be corrupted with logged data.

This fix ensures that the startup log file is opened as the user specified to run the PostgreSQL server. Any users who have made use of the start scripts will need to ensure the startup log files are owned by the user specified to run the PostgreSQL server.

CVE-2017-15099: INSERT ... ON CONFLICT DO UPDATE fails to enforce SELECT privileges

Prior to this release, the "INSERT ... ON CONFLICT DO UPDATE" would not check to see if the executing user had permission to perform a "SELECT" on the index performing the conflicting check. Additionally, in a table with row-level security enabled, the "INSERT ... ON CONFLICT DO UPDATE" would not check the SELECT policies for that table before performing the update.

This fix ensures that "INSERT ... ON CONFLICT DO UPDATE" checks against table permissions and RLS policies before executing.

Bug Fixes and Improvements

This update also fixes a number of bugs reported in the last few months. Some of these issues affect only version 10, but many affect all supported versions:

  • Fix a race condition in BRIN indexing that could cause some rows to not be included in the indexing.
  • Fix crash when logical decoding is invoked from a PL language function.
  • Several fixes for logical replication.
  • Restored behavior for CTEs attached to INSERT/UPDATE/DELETE statements to pre-version 10.
  • Prevent low-probability crash in processing of nested trigger firings.
  • Do not evaluate an aggregate function's argument expressions when the conditions in the FILTER clause evaluate to FALSE. This complies with SQL-standard behavior.
  • Fix incorrect query results when multiple GROUPING SETS columns contain the same simple variable.
  • Fix memory leak over the lifespan of a query when evaluating a set-returning function from the target list in a SELECT.
  • Several fixes for parallel query execution, including fixing a crash in the parallel execution of certain queries that contain a certain type of bitmap scan.
  • Fix json_build_array(), json_build_object(), jsonb_build_array(), and jsonb_build_object() to handle explicit VARIADIC arguments correctly.
  • Prevent infinite float values from being casted to the numeric type.
  • Fix autovacuum's “work item” logic to prevent possible crashes and silent loss of work items.
  • Several fixes for VIEWs around adding columns to the end of a view.
  • Fix for hashability detection of range data types that are created by a user.
  • Improvements on using extended statistics on columns for the purposes of query planning.
  • Prevent idle_in_transaction_session_timeout from being ignored when a statement_timeout occurred earlier.
  • Fix low-probability loss of NOTIFY messages due more than 2 billion transactions processing before any queries are executed in the session.
  • Several file system interaction fixes.
  • Correctly restore the umask setting when file creation fails in COPY or lo_export().
  • Fix pg_dump to ensure that it emits GRANT commands in a valid order.
  • Fix pg_basebackup's matching of tablespace paths to canonicalize both paths before comparing to help improve Windows compatibility.
  • Fix libpq to not require user's home directory to exist when trying to read the "~/.pgpass" file.
  • Several fixes for ecpg.

This update also contains tzdata release 2017c, with updates for Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.

EOL Notice for Version 9.2

PostgreSQL version 9.2 is now End-of-Life (EOL). No additional updates or security patches will be released by the community for this version. Users still on 9.2 are urged to upgrade as soon as possible. See our Versioning Policy for more information.

Links
Kategóriák: Informatika

Support for .NET Core 2.0 and PostgreSQL 10 in Updated dotConnect for PostgreSQL

2017, november 6 - 01:00

Devart updated dotConnect ADO.NET data provider for PostgreSQL, LINQ to SQL-compatible ORM solution LinqConnect, and an ORM designer Entity Developer.

.NET Standard Compatible Assemblies

dotConnect provider for PostgreSQL now has .NET Standard compatible assemblies both for .NET Standard 1.3 and .NET Standard 2.0. The new .NET Standard 2.0 compatible assemblies support many features, that are not available in .NET Standard 1.3 compatible assemblies. Particularly, the new assemblies include support for distributed transactions, DataAdapter and CommandBuilder classes, Dump classes, etc.

New Features in Entity Developer

The new version of Entity Developer supports Entity Framework Core 2.0. Now you can design both Entity Framework Core 1.1 and 2.0 models. In Entity Framework Core 2.0 models you can use complex types for entity properties, Entity Framework Core 2.0 native mapping for database scalar functions, table splitting, generate self-contained type configuration code, etc.

Additionally, the new version of Entity Developer now supports executing LINQ queries against the model and retrieving data when working with projects, targeting .NET Core or .NET Standard.

PostgreSQL 10 Support

The new dotConnect for PostgreSQL version also supports PostgreSQL 10.

Kategóriák: Informatika

Aiven first to offer managed PG 10 on all major clouds

2017, november 2 - 01:00

Aiven Oy has been offering PostgreSQL 10 as a fully-managed service on AWS, GCP, Azure, DigitalOcean, and UpCloud platforms since October 2017, making it the first provider to offer production-ready PG 10.

Oskari Saarenmaa, Aiven’s CEO, discussed its importance: “Our push to being the first provider of PG 10 as a managed service is illustrative of our commitment to equipping users with the latest features that will help them get the most from their databases.”

Established in January 2016, Aiven is a DBaaS provider offering scalable managed database and messaging systems worldwide. To sign up for a free trial or to learn more about Aiven, visit aiven.io.

Kategóriák: Informatika

Announcing the Release of OmniDB 2.3

2017, november 2 - 01:00

Oxford, United Kingdom - November 2, 2017

2ndQuadrant announces the release of OmniDB 2.3, which now includes a Debugger for PL/pgSQL functions, and is available for download here.

OmniDB is a browser-based database management tool. It is designed to be a powerful, yet lightweight, user-friendly and fast-performing interface for PostgreSQL databases. OmniDB is fully backed by 2ndQuadrant’s world renowned 24/7 Production Support.

OmniDB 2.3 presents new and exciting features, listed below:

  • Debugger for PL/pgSQL functions. This release presents a new interface and a PostgreSQL plugin for debugging PL/pgSQL functions. Users will be able to visualize the execution state of the debugging process at every step, including duration and final results, with statistics charts at the end of the operation.

  • Automatic saving of query tabs. This feature allows the user to work without manually saving queries. When the user closes OmniDB and restarts it, all the tabs with queries that have been executed will be automatically restored.

This release also includes important enhancements such as:

  • Automatic closing of database connections. OmniDB 2.3 introduces an interface and backend server that are completely synchronized. When a tab is closed, all connections in the backend related to that tab are closed simultaneously, this feature prevents from filling the database with unused backends.

For a complete list of changes, including detailed bug fixes, read the OmniDB change tracker here.

For more information, please send an email to info@2ndQuadrant.com

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Kategóriák: Informatika

MicroOLAP Database Designer meets PostgreSQL 10!

2017, november 1 - 01:00

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL with support for PosgreSQL 10, an comprehensive CASE tool with intuitive graphical interface.

This release introduces support for PostgreSQL v10.

A huge amount of internal and architecture tasks were done either. Updated visual controls used as well as new exception tracer introduced.

Several new sample models were added: “USDA Food database”, “Chinook” and “AdventureWorks for Postgres”. There are many changes and bug fixes.

Download

You're welcome to download the Database Designer for PostgreSQL 1.12.0 right now at: http://microolap.com/products/database/postgresql-designer/download/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full changelog:
  • [!] SQL Executor and Validator support v10.0 grammar now
  • [+] "AdventureWorks for Postgres" model added as sample
  • [+] "Font Color" options added to Display Preferences
  • [+] "Font Color" options added to object editors
  • [+] "Quote Default value" option added for Domain editor
  • [+] Chinook database model added as sample
  • [+] macaddr8 type support added
  • [+] New detailed error dialog introduced for Reverse Engineering
  • [+] PARALLEL option added for stored routines
  • [+] PL/sh procedural language support added
  • [+] PL/v8 procedural language support added
  • [+] SQL keywords are properly highlighted according to 10.0 version
  • [+] USDA Food database model added as sample
  • [*] "Execution interrupted by user" error dialog replaced
  • [*] "Modify process interrupted by user" message box added
  • [*] Copyright info label updated
  • [*] Improved main window position and state restoring for maximized state
  • [*] Old unfancy loader removed
  • [*] Reverse Engineering respects role permissions on sequences now
  • [*] Splash screen updated
  • [-] "'Rules...' pop-up menu doesn't work for tables on diagram" bug fixed
  • [-] "Comments not displayed for views on diagram" bug fixed
  • [-] "Domains with time and timestamp base types were reversed with 0 type modifier, e.g. time(0)" bug fixed
  • [-] "EConvertError during time out for SSH connection" bug fixed
  • [-] "ERangeError after applying some colors to model background" bug fixed
  • [-] "Most Recent Used list of files for Access Import is empty after restart" bug fixed
  • [-] "Rare EAccessViolation during renaming references in the Reference Manager" bug fixed
  • [-] "Some views and stored routines need to be redrawn after Reverse Engineering by Redisplay menu" bug fixed
  • [-] "Universal Reverse Engineering returns empty model for sources with schemas" bug fixed
Kategóriák: Informatika

Announcing General Availability of Amazon Aurora with PostgreSQL Compatibility

2017, október 24 - 02:00

Amazon Aurora is a fully managed relational database that combines the performance and availability of commercial databases with the simplicity and cost-effectiveness of open source databases. In April 2017, we announced an open preview of the PostgreSQL-compatible edition of Amazon Aurora. The service is now generally available to all customers.

Amazon Aurora with PostgreSQL compatibility provides up to three times better performance than the typical PostgreSQL database, together with scalability, durability and security. It also provides a high degree of compatibility with commercial databases, making it a compelling target for database migrations.

The service also includes Performance Insights, an easy-to-use database monitoring tool that helps you quickly detect performance problems and take corrective action. Performance Insights is available for preview at no additional cost and can be enabled with one click in the Amazon RDS Console.

The PostgreSQL-compatible edition of Amazon Aurora is available on r4.large – r4.16xlarge DB Instance Classes in the US-EAST-1 (N. Virginia), US-EAST-2 (Ohio), US-WEST-2 (Oregon) and EU-WEST-1 (Ireland) Regions. Please see the documentation for more information.

Please see Jeff Barr’s recent blog post for more information.

Kategóriák: Informatika

PostgresDAC 3.3.0 meets PostgreSQL 10

2017, október 19 - 02:00
New milestone PostgresDAC release is out! Now with PostgreSQL 10 support.

PostgresDAC is a direct access component suite for RAD Studio (Delphi and C++Builder)/FreePascal/Lazarus and PostgreSQL, EnterpriseDB, Amazon RDS, PostgresPro and Heroku Postgres.

Full changelog:
  • [!] v10.0 client libraries added
  • [!] v10.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [!] PostgresDAC components are enabled on IDE Component pallette for all platforms from now
  • [+] doNoPublications option added to TPSQLDump.Options
  • [+] doNoSubscriptions option added to TPSQLDump.Options
  • [+] doNoSync option added to TPSQLDump.Options
  • [+] roNoPublications option added to TPSQLRestore.Options
  • [+] roNoSubscriptions option added to TPSQLRestore.Options
  • [-] Сrash fixed in TPSQLRestore when using parallel mode and using a list file to select a subset of items
Download

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

Kategóriák: Informatika

Announcing the Release of repmgr v4.0 Beta

2017, október 11 - 02:00

Oxford, United Kingdom - October 11, 2017

2ndQuadrant is proud to announce the release of repmgr 4 (Beta). repmgr has been the most popular tool for PostgreSQL failover since 2010. v4 updates repmgr to support the recently released PostgreSQL 10.

This new release contains a number of changes related to WAL functionality and minor bug fixes. Additionally, there is a new log line type: DETAIL. Meaning that additional context for log messages is now provided in a separate DETAIL log line (similar to PostgreSQL). This release includes other important enhancements, some of which are listed below:

  • Improved switchover functionality
  • Redesigned failover mechanism
  • Faster performance
  • Improved checking of prerequisites
  • Easier upgrading
  • Suitable for setting up replication clusters in provisioning environments

Read the full release notes for repmgr 4.0 here

repmgr is an open source package that helps DBAs and System Administrators manage a cluster of PostgreSQL databases. repmgr greatly simplifies the process of setting up and managing databases with high availability and scalability requirements.

repmgr is developed and maintained by 2ndQuadrant. It is fully supported by their respected 24/7 Production Support, providing the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide. repmgr is distributed under GPL v3.

Repmgr 4 download and installation instructions are available here

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Kategóriák: Informatika

PGConf APAC 2018 CFP is Open

2017, október 10 - 02:00

Following the success of two consecutive pan-Asia Postgres event - pgDay Asia 2016 and pgDay Asia 2017 held along with FOSSASIA, we are pleased to announce PGConf APAC 2018 to be held in Singapore from 22nd to 24th of March, 2018. Once again the conference will be held along with FOSSASIA - one of the largest FOSS conference on the planet. PGConf APAC will be PostgreSQL conference series for all PostgreSQL enthusiasts and users in the Asia Pacific region.

For more details on FOSSASIA - http://2018.fossasia.org

You will be able to enjoy one of the largest PostgreSQL conference in Asia and one of the largest FOSS conferences to meet like minded individuals in the same week!

pgDay Asia 2016 and pgDay Asia 2017 would not have been possible without your awesome talks and we would like to invite speakers from all over the globe to present at the PGConf APAC 2018. We would like to open Call For Paper for PGConf APAC 2018. Some of the topics which can be used for submitting a talk are-

  1. Migration projects
  2. Performance troubleshooting and tuning
  3. noSQL and geo-spatial features of Postgres
  4. Unique use-case and customer stories
  5. Useful new features in PostgreSQL 10

For more examples you can refer to the papers which were presented at last year's event - 2016 and 2017.

Of course we are happy to accept paper proposals on any other interesting topics as well.

To submit you proposal for presentation please go to this link - http://2018.pgconfapac.org/cfp

Venue

To be Announced

Call for Papers

2017-10-10: Proposals acceptance begins

2017-12-04: Proposals acceptance ends

2017-12-13: Authors of accepted proposals contacted

If you need any additional information please contact our team at pgconfapac(at)googlegroups(dot)com.

This conference is organized by the PostgreSQL people from Asian communities. If you have any question, feel free to contact us on pgconfapac(at)googlegroups(dot)com.

Kategóriák: Informatika

PostgresOpen SV 2017 - Wrap Up

2017, október 10 - 02:00

PostgresOpen SV 2017 was a smashing success! Thank you so much to all of our fantastic attendees, our great speakers and our sponsors for helping make it happen.

All of the videos for all of the general session talks and the keynotes are now available online here:

https://www.youtube.com/PostgresOpen

The slides for most of the talks have been posted to the Wiki, thanks to our wonderful speakers:

https://wiki.postgresql.org/wiki/Postgres_Open_2017

We'll be back in San Francisco again in 2018!

https://2018.postgresopen.org

If you didn't have a chance to check it out already, we encourage you to visit our blog, with posts from our Diamond and Platinum sponsors:

https://2017.postgresopen.org/blog/

Special thanks to our sponsors! We wouldn't be able to put on these awesome events without their help and support. Be on the lookout for our 2018 Call For Sponsors which will be happening soon!

For 2017 we were pleased to be able to recognize our three Diamond sponsors:

2ndQuadrant

CitusData

Microsoft

And our Platinum sponsor:

Heroku

Be sure to check out our site to see all of our Gold, Silver and Supporter sponsors for 2017, and our Community Partners here:

https://2017.postgresopen.org/sponsors/

PostgresOpen wouldn't be able to happen without the tireless efforts of the individuals at the United States PostgreSQL Association (PgUS), please consider joining us to help run events in your area and to work to grow PostgreSQL!

https://postgresql.us

PgUS is the non-profit organization which backs PostgresOpen and other events and we are always looking for help.

We look forward to seeing everyone in San Francisco again next year!

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

Stephen Frost & Craig Kerstiens PostgresOpen SV 2017 Committee Co-Chairs https://2017.postgresopen.org

Kategóriák: Informatika

Announcing the Release of pglogical 2.1

2017, október 9 - 02:00

Oxford, United Kingdom - October 9, 2017

2ndQuadrant is proud to announce the release of pglogical 2.1, the next generation in logical replication, for PostgreSQL 10 - the latest major release of of the world's most advanced open source database. Implemented entirely as a PostgreSQL 10 extension, pglogical is a logical replication system that serves as a highly efficient method of replicating data as an alternative to physical replication.

This new release presents important enhancements and bug fixes including:

  • Fixed dropping of extensions when pglogical is in shared_preload_libraries but not used in the current database
  • Improved compatibility with pglogical 1.x provider
  • Fixed computation of CURRENT_TIMESTAMP on subscriber
  • Improved error reporting
  • Improved replication origins handling

pglogical is fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.

pglogical is supported by 2ndQuadrant. 2ndQuadrant’s respected 24/7 Production Support provides the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide.

Download and installation instructions are available here.

For more information, please send an email to info@2ndQuadrant.com

Kategóriák: Informatika

Database .NET v23 released

2017, október 6 - 02:00

Database .NET v23 is an innovative, powerful and intuitive multiple database management tool. (Full support for PostgreSQL 8/9/10)

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

Major New features from version 22.1 to 23.1:

  • PostgreSQL 10 support
  • Added Finding and Replacing Multiple Documents
  • Added DateTime Picker with TimeZone
  • Added Quick Filter objects
  • Added Search Object DDL (Pro)
  • Added Highlighting Groups of Cells
  • Added Using \r\n as record separator by Exporting and Importing delimited text files
  • Added Multi line search
  • Added Search result highlighting
  • Added JSON Editor and Viewer
  • ...and more
For more information please visit http://fishcodelib.com/Database.htm.
Kategóriák: Informatika

dbMigration .NET v6.5 released

2017, október 6 - 02:00

dbMigration .NET v6.5 is a simple, easy and intuitive multiple database migration and sync tool, With it you can easily migrate schema and data to PostgreSQL and vice versa without complicated procedures.

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

Major New features and improvements from version 5.1 to 6.5:

  • Massive performance improvements (>30%+)
  • Better support for windows display scaling
  • Added Migrating data with a SQL statement
  • Added support for Asynchronous connection open
  • Added automatically reset sequences after migrating the table
  • Improved Graphical User Interface
  • Improved Data Synchronization
  • Improved Automatic Mapping Types
  • Improved Custom Mapping Types (UDT and length)
  • Improved Command-Line parsing
  • ...and more
The new version is immediately available for download.
Kategóriák: Informatika

Oldalak

Theme by me