I Use This!
Activity Not Available


Analyzed about 1 month ago. based on code collected about 1 month ago.
Posted 10 days ago
PostgresOpen and PGConf SV have joined forces this year to put together a fantastic PostgreSQL conference, PostgresOpen SV 2017, being held in downtown San Francisco from September 6th to 8th. ... [More] Early Bird Registration for PostgresOpen SV 2017 is now open! Simply go to our tickets page and register to attend the longest running annual PostgreSQL conference in the US. The Program Committee is excited to be able to offer tickets for PostgresOpen SV at the same rate as last year, with a $200 discount for early bird registrations! We also want to remind you that the Call for Papers is only open until May 30th, Anywhere on Earth (AoE), this is the last chance for you to submit your talk for PostgresOpen SV 2017, there's only two weeks left! Presentations on any topic related to PostgreSQL including, but not limited to, case studies, experiences, tools and utilities, application development, data science, migration stories, existing features, new feature development, benchmarks, and performance tuning are encouraged. Tutorials will be announced in the coming weeks- watch our blog for updates! The Program Committee looks forward to bringing the best PostgreSQL presentations and tutorials from speakers around the world to the fantastic Parc55 in downtown San Francisco. Speakers will be notified by June 6th, 2017 AoE, with the schedule to be published once selected speakers have confirmed. PostgresOpen SV 2017 is only able to happen with the support of our fantastic sponsors. We are extremely pleased to be able to recognize our Diamond launch sponsors: 2ndQuadrant CitusData and head to our site to see all of our Gold, Silver and Supporter sponsors Sponsorship opportunities are still available! We look forward to seeing everyone in San Francisco! Any questions? Please contact: program2017@postgresopen.org [Less]
Posted 11 days ago
The PostgreSQL Global Development Group announces today that the first beta release of PostgreSQL 10 is available for download. This release contains previews of all of the features which will be available in the final release of version 10 ... [More] , although some details will change before then. Users are encouraged to begin testing their applications against this latest release. Major Features of 10 The new version contains multiple features that will allow users to both scale out and scale up their PostgreSQL infrastructure: Logical Replication: built-in option for replicating specific tables or using replication to upgrade Native Table Partitioning: range and list partitioning as native database objects Additional Query Parallelism: including index scans, bitmap scans, and merge joins Quorum Commit for Synchronous Replication: ensure against loss of multiple nodes We have also made three improvements to PostgreSQL connections, which we are calling on driver authors to support, and users to test: SCRAM Authentication, for more secure password-based access Multi-host "failover", connecting to the first available in a list of hosts target_session_attrs parameter, so a client can request a read/write host Additional Features Many other new features and improvements have been added to PostgreSQL 10, some of which may be as important, or more important, to specific users than the above. Certainly all of them require testing. Among them are: Crash-safe and replicable Hash Indexes Multi-column Correlation Statistics New "monitoring" roles for permission grants Latch Wait times in pg_stat_activity XMLTABLE query expression Restrictive Policies for Row Level Security Full Text Search support for JSON and JSONB Compression support for pg_receivewal ICU collation support Push Down Aggregates to foreign servers Transition Tables in trigger execution Further, developers have contributed performance improvements in the SUM() function, character encoding conversion, expression evaluation, grouping sets, and joins against unique columns. Analytics queries against large numbers of rows should be up to 40% faster. Please test if these are faster for you and report back. See the Release Notes for a complete list of new and changed features. Test for Bugs and Compatibility We count on you to test the altered version with your workloads and testing tools in order to find bugs and regressions before the release of PostgreSQL 10. As this is a Beta, minor changes to database behaviors, feature details, and APIs are still possible. Your feedback and testing will help determine the final tweaks on the new features, so test soon. The quality of user testing helps determine when we can make a final release. Additionally, version 10 contains several changes that are incompatible with prior major releases, particularly renaming "xlog" to "wal" and a change in version numbering. We encourage all users test it against their applications, scripts, and platforms as soon as possible. See the Release Notes and the What's New in 10 page for more details. Beta Schedule This is the first beta release of version 10. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2017. For further information please see the Beta Testing page. Links Downloads Page Beta Testing Information 10 Beta Release Notes What's New in 10 10 Open Items [Less]
Posted 12 days ago
SQL Multi Select 3.2 Basic Edition is now free. Run multiple scripts on multiple PostgreSQL databases with a single click. A description for how to use SQL Multi Select with other PostgreSQL tools is available here. Changes in version 3.2: ... [More] various GUI changes to improve Wine compatibility. added option to define default scripts for PostgreSQL, MySQL, and Oracle servers modified the upgrade process to avoid having to reboot the Linux OS. System requirements: Runs on Windows XP to Windows 10. Runs on Wine, tested on Ubuntu and Fedora. Supports PostgreSQL 8.3 to 9.6, without the need for any additional database drivers. For more information about SQL Multi Select for PostgreSQL, please visit http://www.yohz.com/sms_details.htm, or download a free 14-day trial. About Yohz Software Yohz Software is a developer of free and commercial database applications for most popular database engines. Visit our site at http://www.yohz.com. [Less]
Posted 12 days ago
Mapt - powered by Packt - is a comprehensive tech library stuffed full of the latest PostgreSQL knowledge. Mapt boasts over 170 hours of PostgreSQL courses, including the latest Packt PostgreSQL eBooks. It’s been designed for developers who need ... [More] answers fast. Newly released on Mapt, the PostgreSQL Administration Cookbook, High Performance Cookbook and High Availability Cookbook give you essential answers right at your fingertips. Now PostgreSQL community members can access these titles and more with an exclusive 50% off discount on Mapt Annual subscription. You can receive a discount off of a whole year of Mapt with the discount code MptPgSQL50 Mapt’s PostgreSQL courses cover everything you need to know whether you’re just starting out with the basics, or looking for advanced tips and tricks to get the most from PostgreSQL. Get practical insight from real PostgreSQL experts with decades of database experience. Mapt authors include Simon Riggs, CTO of PostgreSQL consultancy 2ndQuadrant; Greg Smith, principal consultant for 2ndQuadrant, and Postgre Open speaker Shaun M Thomas. On top of all that PostgreSQL knowledge, a Mapt subscription nets even more insight. Access to over 4,500 eBook and video courses on data, development, and more. Get career development guidance from Mapt’s Skill Plans. Make your learning stick with assessments, and take advantage of a global author community. [Less]
Posted 18 days ago
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.3, 9.5.7, 9.4.12, 9.3.17, and 9.2.21. This release fixes three security issues. It also patches a number of other bugs ... [More] reported over the last three months. Users who use the PGREQUIRESSL environment variable to control connections, and users who rely on security isolation between database users when using foreign servers, should update as soon as possible. Other users should plan to update at the next convenient downtime. Security Issues Three security vulnerabilities have been closed by this release: CVE-2017-7484: selectivity estimators bypass SELECT privilege checks CVE-2017-7485: libpq ignores PGREQUIRESSL environment variable CVE-2017-7486: pg_user_mappings view discloses foreign server passwords The fix for CVE-2017-7486 applies to new databases, see the release notes for the procedure to apply the fix to an existing database. Any user relying on the PGREQUIRESSL environment variable is encouraged to use the sslmode connection string option, as use of PGREQUIRESSL is deprecated. CVE-2017-7485 does not affect the 9.2 series. For more information on these issues and how they affect backwards-compatibility, see the Release Notes. Bug Fixes and Improvements This update also fixes a number of bugs reported in the last few months. Some of these issues affect only the 9.6 series, but many affect all supported versions. There are more than 90 fixes in this release, including: Fix to ensure consistent behavior for RLS policies Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT Fix incorrect support for certain box operators in SP-GiST which could yield incorrect results Fixes for handling query cancellation Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index Fix possibly-invalid initial snapshot during logical decoding Fix possible corruption of init forks of unlogged indexes Several fixes to postmaster, including checks for when running as a Windows service Several planner fixes, among others assorted minor fixes in planning of parallel queries Avoid possible crashes in walsender and some index-only scans on GiST index Fix cancelling of pg_stop_backup() when attempting to stop a non-exclusive backup Updates to ecpg to support COMMIT PREPARED and ROLLBACK PREPARED Several fixes for pg_dump/pg_restore, among others to handle privileges for procedural languages and when using --clean option Several fixes for contrib modules, such as dblink, pg_trgm and postgres_fdw Fixes to MSVC builds, such as using correct daylight-savings rules for POSIX-style time zone names and supporting Tcl 8.6 Several performance improvements Fix cursor_to_xml() to produce valid output with tableforest = false Fix roundoff problems in float8_timestamptz() and make_interval() Fix pgbench to handle the combination of --connect and --rate options correctly Fixes to commandline tools such as pg_upgrade and pg_basebackup Several fixes to VACUUM and CLUSTER Users of replication tools based on logical decoding, as well as users of unlogged indexes, should consult the release notes for potential extra steps during the upgrade. This update also contains tzdata release 2017b with updates for DST law changes in Chile, Haiti, and Mongolia, plus historical corrections for Ecuador, Kazakhstan, Liberia, and Spain. Switch to numeric abbreviations for numerous time zones in South America, the Pacific and Indian oceans, and some Asian and Middle Eastern countries. The timezone library is synchronized with IANA release tzcode2017b. EOL Warning for Version 9.2 PostgreSQL version 9.2 will be End-of-Life in September 2017. The project expects to only release one, or two, more updates for that version. We urge users to start planning an upgrade to a later version of PostgreSQL as soon as possible. See our Versioning Policy for more information. Updating 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. After update, users of replication tools based on logical decoding, as well as users of unlogged indexes, should consult the release notes for potential extra steps during the upgrade. See the Release Notes for more details. Users who have skipped one or more update releases may need to run additional, post-update steps; please see the release notes for earlier versions for details. Links: Download Release Notes Security Page Versioning Policy [Less]
Posted 22 days ago
pg_chameleon is a MySQL to PostgreSQL replica system developed in python 2.7/3.3+. The release 1.0 comes with the following features Copy schema and data from MySQL to a PostgreSQL schema MySQL to PostgreSQL replica Basic DDL Support ... [More] (CREATE/DROP/ALTER TABLE, DROP PRIMARY KEY/TRUNCATE) Discards of replicated rubbish data Replica from multiple MySQL sources Basic replica monitoring Detach replica from MySQL for easy migration to PostgreSQL Usage examples Analytics Migrations Data aggregation from multiple MySQL databases Download and documentation Pypi package Github page Documentation [Less]
Posted 25 days ago
Oxford, United Kingdom - May 4, 2017 2ndQuadrant is pleased to announce the release of pglogical 2.0 – the next generation in logical replication for PostgreSQL. This version will continue to be supported until EOL for PostgreSQL server versions ... [More] 9.4, 9.5 and 9.6 and will also work with PostgreSQL 10 due to release in Fall 2017. What's New The pglogical 2.0 release brings new features allowing it to be used for even more use-cases. It also includes several bug fixes and behavior improvements, including: Row filter - specify SQL expression which should be used on upstream to filter rows for replicated table Column filter - specify list of columns that should be replicated, this allows replication of just some columns from a table Windows support - pglogical can be now used with PostgreSQL running on Windows as both provider and subscriber (has to be built from the source at the moment) Delayed replication - it’s now possible to set delay for how long behind the downstream should be when replicating data Postgres-XL support - Postgres-XL can become a pglogical subscriber, which means you can replicated from PostgreSQL to Postgres-XL directly New command line tool pglogical_create_subscriber which can convert physical standby (or base backup) into pglogical subscriber Performance improvements for applying transactions containing many INSERTs (including transactions that did large import using COPY) Improved behavior of TRUNCATE, especially the TRUNCATE triggers Users executing DDL in database no longer need USAGE privilege on pglogical schema Fixed reporting of false positives on UPDATE conflicts Log level for conflicts can now be changed About pglogical pglogical is a logical replication system implemented entirely as a PostgreSQL extension. 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. About 2ndQuadrant 2ndQuadrant leads the drive for improving the enterprise functionality for PostgreSQL, continuously contributing major features to every release for performance, replication, business intelligence and usability. pglogical has been developed by 2ndQuadrant. It is open source and fully supported for 2ndQuadrant 24/7 Support customers. We also offer consulting services to help organizations with application development, conflict handler design, cluster design, deployment, feature development and performance analysis. [Less]
Posted about 1 month ago
Yohz Software has just released DB Doc 4.1, the PostgreSQL schema documentation tool, and is available for immediate download. Changes in this version: All reports now display the 20 largest tables (by total size, indexes size, and toast size) ... [More] and indexes for each schema. Added ability to sort table and index lists by any text or numeric property. Schema inspector added so you can view the properties of each database object before printing your reports. Search function in schema inspector allows you to quickly filter database objects by name and/or comment. Fixed consistency of PDF portrait and landscape layouts. Improved consistency of Word reports with PDF reports. Improved search function dialog in script editor. DB Doc benefits: Create documents 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 Document a database in 4 simple steps 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 documentation Runs on Windows XP to Windows 10 Runs in Wine, so you can use DB Doc on your favorite Linux distribution Supports PostgreSQL 8.3 to 9.6, without the need for any additional database drivers. For more details about DB Doc, visit the product page here. [Less]
Posted about 1 month ago
New version of MySQL-to-PostgreSQL has been released with verified support for Heroku, option to convert views and other improvements. Visit https://www.convert-in.com/mysql-to-postgres.htm for details.
Posted about 2 months ago
Yohz Software has released PgComment, a FREE Windows tool to easily add/modify comments to your database objects. PgComment reads your database schema in seconds, and displays the schema in a hierarchical tree view, together with any existing ... [More] comments. You can then edit the comments directly in the tree view. With PgComment, you can add comments to tables, columns, indexes, views, domains, sequences, and functions. Changes are cached locally, and sent to the server in a batch when applied, so you do not have to wait for individual COMMENT ON commands to complete after each change. This allows you to work faster. Used together with DB Doc, our PostgreSQL schema documentation generator, PgComment allows you to delegate the task of documenting the database objects to the users who are most familiar with the database objects. For more information on PgComment, please visit http://www.yohz.com/pgc_details.htm, or download the installer. About Yohz Software Yohz Software is a developer of database applications for most popular database engines. Visit our web site at http://www.yohz.com to discover what other products we offer. [Less]