I Use This!
Very High Activity

News

Analyzed 11 days ago. based on code collected 11 days ago.
Posted 4 days ago
December 13, 2017: Crunchy Data is proud to announce pgBackRest 1.26, Reliable PostgreSQL Backup & Restore. Release 1.26 Since the release of 1.09 in October 2016, the pgBackRest team has added S3 support, repository encryption, page checksum ... [More] validation, and made a number of other improvements. The major new features added since 1.09 are detailed below. Links Website Download User Guide Release Notes Support New Features Amazon S3 Repositories can be created in S3 buckets for virtually unlimited storage. Repository Encryption The repository can be encrypted on any supported storage using the industry-standard AES-256 cipher. Page Checksum Validation Page checksums are validated automatically when enabled on PostgreSQL >= 9.3. Improved Asynchronous Archiving Asynchronous archiving is now multi-threaded and no longer maintains a separate WAL queue. This results in significantly better performance with less I/O. Stanza Management Stanzas are managed using the stanza-create and stanza-upgrade commands. Configure Multiple Backup Standbys Up to seven standbys can be configured for backup from standby. The first active standby in the list will be used for the backup. 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. [Less]
Posted 4 days ago
We are pleased to announce that PGConf APAC 2018 will be held in Singapore on 22 & 23 March, 2018. Registrations are now open. To register, please follow this link: http://2018.pgconfapac.org/tickets. Like all Postgres Events, PGConf APAC will ... [More] be a great opportunity for you to get introduced to leading PostgreSQL users, developers, and to learn about the latest PostgreSQL release features. Call For Papers is Extended Call for Papers has been extended! Some of the topics which can be used for submitting a talk are- Migration projects Performance troubleshooting and tuning noSQL and geo-spatial features of Postgres Unique use-case and customer stories 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. You can submit your paper over here: http://2018.pgconfapac.org/cfp. Registrations are Open We have opened up registration and ticket sale. Early bird registration closes on 7th Jan 2018. You can get tickets on http://2018.pgconfapac.org/tickets Why Singapore? Singapore is a global city and is very well connected via flights with major hubs across the globe. It has a unique cultural blend and population from different ethnicities and religions. The coexistence and sound infrastructure has provided the foundation for rapid growth of the country and its positioning as a trade, technological and financial hub. These are the reasons why various PostgreSQL User Groups from Asia have come together to organize one of the largest PostgreSQL shows in Asia Pacific – PGConf APAC 2018, the first large-scale PostgreSQL conference for the Asia Pacific region. Sponsors PGConf APAC 2018 is built on the success of pgDay Asia 2017 and pgDay Asia 2016. These events would not have been possible without the generous sponsorships from various enterprises involved with or using PostgreSQL. We would like to acknowledge our sponsors for this event: Platinum Sponsor: Fujitsu Gold Sponsors: 2ndQuadrant, EDB Postgres Co-Hosts: Ashnik If you would like to sponsor the event, you can find details on our website in Sponsors section. In case of any questions, please write to: pgconfapac[at]googlegroups[dot]com [Less]
Posted 4 days ago
Oxford, United Kingdom - December 13, 2017 2ndQuadrant announces the minor release of repmgr 4. repmgr is the most popular tool for PostgreSQL replication and failover management. It enhances and complements PostgreSQL's built-in replication ... [More] 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. repmgr 4.0.1 is a bug fix release. For a list of all fixed bugs, please read the full release notes here. Because of the important bug fixes present in this release, we highly recommend upgrading to repmgr 4.0.1. Download and install instructions are available 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. 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. [Less]
Posted 5 days ago
New version of Postgres Migration Tookit has been released. Major enhancements include: new Access-to-PostgreSQL, Firebird-to-PostgreSQL and SQLite-to-PostgreSQL converters support for Oracle v12.2 in Oracle-to-PostgreSQL converters options to ... [More] export into PostgreSQL script file and to specify PostgreSQL schema in FoxPro-to-PostgreSQL converter Visit http://www.convert-in.com/pgskit.htm for details. [Less]
Posted 10 days ago
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 ... [More] 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. [Less]
Posted 10 days ago
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 ... [More] 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. [Less]
Posted 11 days ago
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 ... [More] software is immediately available at http://www.sqlmaestro.com/products/postgresql/phpgenerator/download/. Top 10 features of the new product: 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. 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. 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. 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. 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. 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. 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. Various data sources. Generated pages can be based on tables, views, and SELECT queries. Website navigation. Such features as sidebar menus, page groups, breadcrumbs, and automatic index page generation are at your disposal. 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. [Less]
Posted 13 days ago
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 ... [More] 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. [Less]
Posted 24 days ago
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 ... [More] 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. [Less]
Posted 24 days ago
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 ... [More] 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. [Less]