End of the naming game: The PostgreSQL project changes its name

I started using PostgreSQL around September 1998. The first problem I had was pronouncing it, and even using right capital letters at the right place.

Was is PostGreSQL? PostgresSQL? PoStGreSQL? PostgreySQL?

Recently Craig also mentioned about the same problem.

Starting today, the PostgreSQL Global Development Group (abbreviated as PGDG) announced that the project will be written as PostgresQL. This will solve the problems (hopefully), and will also help use to drop the "QL" in 2024. Starting v12, all packages will also "provide" postgresXY as the package name, for a smooth change in 2024. Meanwhile, as of today, the project will accept "Postgre" as an alias for those who did not want to learn about the name of the software they are using. I heard rumours that they also say "Orac" or "SQ Serv" or "MyS", so they will now be free to drop SQL in our name, too.

Thanks to everyone who made this change. This was a real blocker for the community, and it will also help newbies in the PostgreSQL Facebook group -- they will now be free to use "Postgre" from now on.

PGDay Comes to Amsterdam on July 12th

Thought it would be good to make everyone aware that PGDay is coming to Amsterdam for the first time on July 12th and I’m delighted to say I will be there helping to host the day, as well as presenting on Write-Ahead Log (WAL). If you want to find out more you can go to this link and find out more. The event will be at the Tobacco Theatre in Amsterdam, which also happens to be one of my favourite cities.

Having just come back from Postgres Vision 2018 and attending a number of Postgres community events across Europe it is great to see how Postgres really is everywhere now in the enterprise database world.

The event in Amsterdam is going to be a great opportunity for existing Postgres users and those developers looking to explore the technology to hear from some of the leading experts in the field. Bruce Momjian, co-founder of the PostgreSQL Global Development Group, will be keynoting and there will be a wide variety of speakers including Jan Karremans, Oleksi Kliukin, Daniel Westerman, Stefanie Stoelting, as well as Ilya Kosmodemiansky, Jeroen de Graaff, Hans-Jürgen Schönig and Andreas Scherbaum.

All of these speakers have been working with PostgreSQL for a long time and have some insights into upcoming releases, as well as key developments in the project. We will be covering major topics such as PostgreSQL in the Cloud, migrating from Oracle and the upcoming Postgres 11 release, but we will also be delving into more technical topics. There will be presentations on pgBackRest, the ability of pg_chameleon to create replicas from MySQL to PostgreSQL and PostgreSQL as a data integration tool.

The sponsors for the event cover a wide range of expertise and understanding of PostgreSQL, so there will be opportunities to understand how they can help you deploy the technology efficiently. The sponsors include Quest Software, EnterpriseDB, 12Apollos, Kangaroot, Nibble-IT, 2nd Quadrant, GITC Pro and Cybertec.

As a member of the talk committee I witnessed first-hand how seriously everyone took their responsibilities when assessing the talk submissions. So on behalf of everyone in the community I want to say thank you to my fellow committee members Robert Ivens, Magnus Hagander, Andreas Scherbaum and Anja van Elteren.

I’m sure it’s going to be an informative event, so if you can join us please do come along to hear how PostgreSQL is shaking up the market and providing enterprises with the only credible alternative to today’s traditional commercial relational databases.

Announcing PostgreSQL SLES RPM Repository!

I am proud to announce the new and shiny PostgreSQL RPM repository for SLES 12: https://zypp.postgresql.org/. This is a part of EnterpriseDB's contribution to the community: EDB provided hardware, and let me use my time for these packages.

The new repo contains (almost) all of the packages that the PostgreSQL YUM repository has. Currently. we support PostgreSQL 10, 9.6 and 9.5, along with more than a hundred packages on each version.

I also wrote a basic howto for using PostgreSQL RPMs on SLES, so please read it first, if you are not that familiar to SLES.


London PostgreSQL Users Group: First meetup

We recently formed a new London PostgreSQL Users Group recently, and our first meetup is on Oct 5th.


In this first meetup, we have two talks:

- I will speak about the new and exciting features in PostgreSQL 10.

- Ivan Novick will speak about "Merging PostgreSQL into Greenplum v5 and future roadmap"

Each session will be 45 mins.


2nd floor, The Warehouse, The Bower, 211 Old Street EC1V 9NR, London

Please click here for Google Maps link.


Please follow us on Twitter.

Lots of changes at yum.PostgreSQL.org

Over the last few weeks, I spent some time to shuffle the PostgreSQL YUM repo a bit, before 9.6 is released. With the help of Magnus, we also made some changes on the server side, so I will summarize all changes in this post:

- Direct downloads from yum.PostgreSQL.org are now redirected to download.PostgreSQL.org. All RPMs are already being served from download.postgresql.org over the last year, so it is the time to redirect it. Please change your scripts to use download.PostgreSQL.org/pub/repos/yum .

- Starting Sep 25th, yum.PostgreSQL.org started speaking https. I updated all repo packages to point to the new URL for GPG checks. Website will be HTTPS only in near future. Please update repo RPMs!

- Starting Sep 25th, we started keeping only last n-2 minor releases in the repo. This means, when there is new release available, we will delete n-3th one. This is a policy to keep the repo clean. This does not apply for PostgreSQL major releases.

* We started serving delta RPMs for all distros except RHEL 5. This will save great bandwidth.

Please let us know if you have more questions, via mailing list: pgsql-pkg-yum@PostgreSQL.org


PostgreSQL is dropping native Windows port, use RPMs.

Important stuff is going on in IT industry nowadays.

Given that Microsot is merging bash shell into Windows, PostgreSQL is considering to drop native Windows port.

Core Team member Josh Berkus sent an email to PostgreSQL hackers mailing list the other day, and proposed dropping the Windows port.

Unsurprisingly, he got great support from Tom Lane. Tom wrote a response. Here is a quote from his email:

"Really? Good. I just committed my very last Windows-related fix, then. Somebody else can deal with it."

There are some unofficial reports about Tom that he opened up a champagne bottle right after this email, but I cannot disclosure my source.

Josh was also backed up by Joe Conway, who authors the famous PL/R extension:

"I would surely love to dump Windows support in PL/R as it is a major league PITA. It is probably an understatement to say that over the last 10+ years, 95+% of the time I have spent maintaining and supporting PL/R has been directly attributable to the Windows port."

However, users from the field acted promptly, looking for alternatives to run PostgreSQL on Windows.

After discussing with other team members, we, as the PostgreSQL YUM repo developers, decided to add Windows support to our RPMs. We contacted Microsoft, and Microsoft kindly provided us a tech preview of the bash environment. After some hacks, here are the results:

$ rpm -ivh postgresql95-libs-9.5.7-1PGDG.Windows2017.x86_64.rpm

command works as expected.

Please stay tuned, until we release all the remaining RPMs for Windows.

9.6, or 10.0?

Even though PostgreSQL 9.5 was released not too long ago, we are almost getting closer towards the feature freeze for 9.6.

When Windows support and PITR capabilities were added to 7.5, the community decided to change the major version to 8.0, as it represents a significant changes at those times. Similar thing happened at 8.5 development cycle: We now had in core replication, and it was released as 9.0.

Now, as 9.6 is coming closer, I seriously think that we should release 10.0, not 9.6 (I've been ranting about this on my Twitter account for a while). Following the commit of Parallel sequential scan , subsequent commits for:

- Parallel Joins
- Parallel Aggregation

increased parallelism features.

Another big infrastructure change is Tom's patch on "Making the upper part of the planner work by generating and comparing Paths."

Apart from these, following the commit that changes the VM file format, another commit titled
Don't vacuum all-frozen pages will help us to deploy PostgreSQL in some environments that we could not do before, I think.

To keep it short, I think that these infrastructural changes should result in a .0 release, as we did before.

What do you think?

PostgreSQL YUM repo receives largest update set, ever.

Today, the PostgreSQL Global Development Group announced new minor releases for all supported version: 9.5.1, 9.4.6, 9.3.11, 9.2.15 and 9.1.20. As usual, RPMs are out, too: http://yum.PostgreSQL.org

Since the last set of updates, I have been working hard with other members in the community for shuffling the repo a bit, towards an aim for better and easier maintenance.

Below is the list of today's update set. They all include the latest versions of each software as of today:


Please let us know if you encounter any issues with the packaging.


Please join us for testing 9.6!

PostgreSQL 9.6 is coming with some great features, and one of them is parallelism. Robert Haas committed a series of commits about it, and recently he added support for both parallel sequential scan and parallel joins:

To help people test all of upcoming features, I will push regularly updated RPMs for the following platforms to the PostgreSQL YUM repository:

- RHEL/CentOS/Scientific Linux/Oracle Enterprise Linux 6 and 7
- Fedora 23 and 22

Please note that these packages are built using the official daily tarball. The package name contains the date that the package is built on.

More information can be found here.

These packages are for crash testing only, never ever intended for production or even beta or alpha usage.

Please report any PostgreSQL bugs to pgsql-bugs(at)PostgreSQL(dot)org

Page 2 of 8, totaling 112 entries