PostgreSQL 10 offers an exciting new set of features in addition to making further improvements to many of the already existing features including Big Data, Replication and Scaling, Administration, SQL, XML and JSON, Security, Performance and a lot more. If you are planning to try your hands at PostgreSQL 10 and wondering on how you […]
Plan for the unexpected: install diagnostic tools on your PostgreSQL servers
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerThere’s a lot of information out there on how to configure PostgreSQL, on the importance of backups and testing them, etc. But what about the server you run PostgreSQL on? We tend to pay a lot less attention to tools that you won’t need unless something breaks. But it’s worth taking some time to do […]
Why PostgreSQL is better than MySQL
/33 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsSomeone recently tweeted about the fantastic news that MySQL fixed a bug. Now in my world, bugs get fixed quickly and well. Bugs happen and they need to be fixed. It never occurred to me that we should ever tweet or blog about the fixing of a bug. I guess I assume it’s just quality: […]
PG10 at the London PostgreSQL Meetup
/0 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsWe recently hosted the London PostgreSQL Meetup at a new location in Covent Garden. Room was great and its about 100m from Leicester Square tube, so very centrally located and easy to get to. http://www.meetup.com/London-PostgreSQL-Meetup-Group/ I’ve been the organizer of the group for more than 6 years now, in my role as the PostgreSQL Project’s […]
v10, The Best PostgreSQL Yet?
/1 Comment/in Umair's PlanetPostgreSQL /by Umair ShahidThe short answer … Hell Yeah! The long answer lies in extensive improvements and the impressive new feature list that makes up this major release – which, by the way, changes the version scheme of PostgreSQL as well (more details on that here). This wiki page lists out, in detail, all the new features in […]
PostgreSQL 10 easy installation with 2UDA
/0 Comments/in Haroon's PlanetPostgreSQL /by Muhammad HaroonPostgreSQL 10 offers an exciting new set of features in addition to making further improvements to many of the already existing features including Big Data, Replication and Scaling, Administration, SQL, XML and JSON, Security, Performance and a lot more. If you are planning to try your hands at PostgreSQL 10 and wondering on how you […]
Postgres-BDR with OmniDB
/1 Comment/in OmniDB, William's PlanetPostgreSQL /by William Ivanski1. Introduction Postgres-BDR (or just BDR, for short) is an open source project from 2ndQuadrant that provides multi-master features for PostgreSQL. Here we will show how to build a test environment to play with BDR and how to configure it using the OmniDB 2.1 web interface. 2. Building test environment Let’s build a 2-node test […]
Transaction traceability in PostgreSQL 10 with txid_status(…)
/1 Comment/in Craig's PlanetPostgreSQL /by craig.ringerOne feature quietly added to PostgreSQL 10 is the ability to determine the commit status of any transaction by transaction-id. It’s reasonable to wonder why you’d want this, since you know if you committed the transaction, it’s still in progress, or if you or rolled it back. And you can check for in-progress transactions in […]
PG Phriday: pglogical and Postgres 10 Partitions
/6 Comments/in pglogical, Shaun's PlanetPostgreSQL /by Shaun ThomasDuring the Postgres Open 2017 conference in San Francisco, someone came to the 2ndQuadrant booth and struck up a conversation with me. During our shameless geeking out over database mechanics, he asked me if pglogical supported the new Postgres 10 partitions. Given my noted expertise in all things Postgres, I answered in the appropriate manner: […]
Setting up a build machine for Visual Studio 2017
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanRecently we’ve had a patch submitted to support the latest incarnation of the Microsoft build tools, Visual Studio 2017. I didn’t have a spare Windows machine available to test with, so I set up Windows machine on Amazon AWS to test with. I chose Windows Server 2016, a t2.medium instance with a 50 GB root […]
PostgreSQL 10 Logical Replication with OmniDB
/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski1. Introduction Logical replication uses a publish/subscribe model and so we create publications on the upstream (or publisher) and subscriptions on downstream (or subscriber). For more details about it, please refer to this blog post from my colleague Petr Jelinek, and also to the PostgreSQL documentation. Here we will show how to build a test […]