PostgreSQL

In part one, Nathan Koopmans, cloud platform engineer at OptimaData, showed how to create a simple plain PostgreSQL setup. Even though this works fine, you still want more data security. Therefore, in this second part, we look at the CloudNativePG operator for Kubernetes.

Several years ago now, colleague Craig wrote a three-part blog about PostgreSQL in combination with Docker. Technology has not stood still, so an update is in order, thought Nathan Koopmans, cloud platform engineer at OptimaData. Hence, How to Postgres on Kubernetes. 

On Oct. 13, PostgreSQL version 15 was released. Performance improvements, new features and capabilities for managing workloads in both onpremise and cloud environments make PostgreSQL 15 a valuable update. At the largest European PostgreSQL conference in Berlin, there was therefore a lot of attention for this new version. In this blog, we summarize the most important changes and new options.

Our partner EDB helps organizations to get the most out of PostgreSQL. Joost Wasser, Public Sector Account Executive at EDB, and his colleague Aret Aprahamian, Partner Account Executive Benelux, DACH and Nordics, talk about working with OptimaData.

PostgreSQL 13 has been released over a month ago. The most important changes and new features have already been announced in various ways and (online) stages, mostly by well-known contributors or influential Postgres community players. In this blog we take a look at those who have allready mentioned the new features, changes and handy facts about PostgreSQL 13. We give an overview of interesting articles, webinars and blogs about the important major but also perhaps neglected non-major changes.

I ran into the challenge to determine the best partitioning key on an Amazon RDS Postgres database. Normal approach would be to start a project trying to implement this on a development environment. But in most cases, like during a QuickScan, the customer expects an educated guess in as little time as possible. It concerns running production environments where you would rather not release all kinds of scripts and analysis tooling to avoid disrupting the primary process. Which then also takes up unnecessary extra time.

One of the most popular open source databases is PostgreSQL, in 2018 even declared DBMS of the Year. In this blog Martijn Wallet shares the most important advantages of using Supported PostgreSQL such as EDB Postgres Platform as compared to native PostgreSQL.

My first experience of a Postgres day, where people talk postgreSQL all day. My day started very early – I left home at 05:15 and arrived in Brussels at 09:10. Unfortunately, due to the train schedules (where trains seem to wake up later than I do) I arrived a bit late for the opening talk by Magnus Hagander. Magnus is one of the core members of the PostgreSQL infrastructure team, developer and comitter in the Global development group. And then, straight into the sessions in a packed room, fortunately there was a seat available.

In a previous post I deployed a PostgreSQL database in a container from a standard image. Now I’m going to look at deploying a PostgreSQL cluster. Well, kind of. PostgreSQL uses the term cluster to refer to “a collection of databases managed by a single PostgreSQL server instance”. I’m using it in the more general sense, to refer to High Availability.

In my previous blog post, I quickly ran through how to set up PostgreSQL inside a Docker container, up to the point where you could administer the database with psql or pgAdmin. What I didn’t do was explain how any of it worked. If you’re trying to anything even slightly different, or if you encounter errors running it as I outlined, then you’re going to need to know what all of those commands actually do.  In this blogpost I will explain some Docker basics.

As a multi-platform DBA, I spend a lot of time learning about the latest features available on a variety of open-source and proprietary databases. I usually use VirtualBox images to create my sandbox databases, but they can take up quite a bit a disk space and resources. Especially if I’m playing around with things like database clustering solutions, when I need multiple databases running together. So the other day, I thought about using Docker containers.

Each year there a new version of PostgreSQL is released. That’s the moment in which many new features and improvements become available for all users. During the last PostgreSQL meetup in Amsterdam, Devrim Gündüz, major contributor and passionate PostgreSQL consultant, explained the upcoming release of PostgreSQL 12. In this blog we list the most important changes in PostgreSQL 12 for everyone who does not closely follows all the commits in Github or who did’nt have the opportunity to visit the PostgreSQL Usergroup NL meetup.

In addition to the well-known databases such as Oracle, MySQL or MS SQL, Open Source databases are developing at lightning speed. In fact, they’re developing so quickly that more and more companies will be using open source databases such as PostgreSQL or MongoDB in their IT infrastructure, and an increasing number of IT brokerage and recruitment agencies will start working with open source professionals. On one hand, that is a nice compliment for the Open Source Community, but on the other, there is also a danger: market forces threaten to undermine the principle of Open Source.

I recently started as a multiplatform DBA. Two weeks before I actually started working at the company where I work now, I already got an invite to go to PG day UK, with a few other DBA's. As I had no prior experience with PostgreSQL, I did not know what to expect. The first few weeks there I've looked into both MongoDB and PostgreSQL, just to get to know the products my colleagues were already supporting. So I started my first PG day with very little knowledge of PostgreSQL.

PostgreSQL is an advanced SQL database server, which is available on a wide range of platforms. It has an enviable reputation for performance, stability, and a wide range of advanced features, which have been developed over the course of more than 20 years. With that, PostgreSQL is one of the oldest open source projects in existence, completely free to use, and developed by a very diverse, worldwide community. And best of all, it just works!