Skip to content

yum users: some -devel RPMs require a new repository

The PostgreSQL Global Development Group has released an update to all supported versions today -- so RPMs also got updated.

As of today's updates, if you are using RHEL/CentOS/OL 7, -devel subpackages in 11 and 12 require an extra repo to be enabled on your system for llvm and clang. Other distros and PostgreSQL versions are not affected. Please note that only -devel subpackage require this repo. Continue reading "yum users: some -devel RPMs require a new repository"

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.

My picks for Postgres Open SV 2018 !

Postgres Open SV 2018 is less than two weeks away now, and I'll speak there as well.

Many people, including me, are flying overseas to attend this great conference, so please hurry up and register before the tickets run out!

Life is hard when there are a lot of talks in parallel, but still I picked up some interesting talks that I want to attend: Continue reading "My picks for Postgres Open SV 2018 !"

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.

Thanks!


London PostgreSQL Users Group: First meetup

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

Talks:

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.

Location

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

Please click here for Google Maps link.

Twitter:

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

Thanks!