PostgreSQL

A quick repository creation utility (part II)

How to create a documentum repository in under a minute. The global_parameters file.

PostgreSQL 16: reserved_connections

The maximum number of connections that PostgreSQL will allow, is controlled by the max_connections parameter. By default this allows a maximum of one hundred connections: postgres=# show max_connections; max_connections ----------------- 100 (1 row) In reality not one hundred connections(…)

Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (2) – Adding a client

In the last post we’ve installed and configured the Uyuni server. In this post we’ll add our first client we later on can manage through the Uyuni server. Quite some distributions are(…)

Some tips when developing in PostgreSQL’s PL/pgSQL

When you develop functions or procedures in PostgreSQL’s PL/pgSQL there are some points to consider, which make your life easier. This post is not about control structures, nor(…)

PostgreSQL: Dropping a table automatically if another table is dropped

Imagine the following use case: You have a table t1, and based on it’s contents you create another table t2. What you want to achieve is: If table t1 gets dropped, you want to have table t2 to be dropped(…)

2022.pgconf.eu Berlin conference for tech

Last week, the biggest European PostgreSQL event of the year took place in Berlin (2022.pgconf.eu). This event is an excellent opportunity to meet developers from the PostgreSQL community and to attend high profile tech presentations. Tuesday evening we started(…)

2022.pgconf.eu, what a blast

2022.pgconf.eu is currently happening in Berlin. We have a record number of 600 attendees, this makes it the largest ever PostgreSQL Conference Europe and we’re hitting the hard limits of the venue.

Helvetia used AWS SCT & DMS to migrate to AWS RDS for PostgreSQL

One of our long term-time customers, Helvetia, successfully migrated on-prem Oracle databases to AWS, not only because of the licenses, but more importantly: to deploy faster, innovate faster, and use the state-of-the-art open source(…)

PostgreSQL 15: Some new features

PostgreSQL version 15 is on its way and we get a better and better look, what will be included in the future release. So it's time to have a look at some new future features(…)

PostgreSQL 15: More flexibility with setting parameters

Another nice feature just made it into PostgreSQL 15: You can now control who is allowed to set specific parameters. This gives you a lot more flexibility, especially when you are hosting PostgreSQL instances for your customers. You can delegate(…)