Infrastructure at your Service

PostgreSQL Archives - Page 2 of 23 - Blog dbi services

Daniel Westermann

The size of Oracle Home: from 9GB to 600MB – What about PostgreSQL?

By | Database Administration & Monitoring | 2 Comments

A recent blog post from Franck and a tweet around that topic is the inspiration for this blog post, thanks Jan for requesting :). In short it is about how small you can get the binaries. Is that important? At least when it comes to Docker images it might get important as you usually try make the image as small as possible. Well, comparing PostgreSQL and Oracle in that field is unfair as Oracle comes…

Read More
Daniel Westermann

Bringing up your customized PostgreSQL instance on Azure

By | Database Administration & Monitoring | No Comments

The Azure cloud becomes more and more popular so I gave it try and started simple. The goal was to provision a VM, compiling and installing PostgreSQL and then connecting to the instance. There is also a fully managed PostgreSQL service but I wanted to do it on my own just to get a feeling about the command line tools. Here is how I’ve done it.

Read More
Daniel Westermann

Backing up and restoring EDB containers in MiniShift/OpenShift

By | Database Administration & Monitoring | 4 Comments

The last blogs in the series are already some days old: Setting up MiniShift, Deploying EDB containers in MiniShift/OpenShift, Customizing PostgreSQL parameters in EDB containers in MiniShift/OpenShift, Scaling the EDB containers in MiniShift/OpenShift, EDB Failover Manager in EDB containers in Minishift/OpenShift and EDB Failover Manager in EDB containers in Minishift/OpenShift – Failovers. What is missing is how you can backup and restore instances running in this container deployment and that is the topic of this…

Read More
Daniel Westermann

When does PostgreSQL create the table and index files on disk?

By | Database Administration & Monitoring | No Comments

A question that pops up from time to time is: When we create a table or an index in PostgreSQL are the files on disk created immediately or is this something that happens when the first row is inserted? The question mostly is coming from Oracle DBAs because in Oracle you can have deferred segment creation. In PostgreSQL there is no parameter for that so lets do a quick test.

Read More
Daniel Westermann

Syncing Active Directory users and groups to PostgreSQL

By | Database Administration & Monitoring | No Comments

A lot of companies use Active Directory to manage their users and groups. What most of this companies also want to do is to manage their database users and groups in Active Directory. PostgreSQL comes with ldap/kerberos authentication by default but does not provide anything that helps with managing users and groups in an external directory. And even for the authentication the user already needs to be existent in PostgreSQL. One tool you might want…

Read More
Oracle Team

Drilling down the pgSentinel Active Session History

By | Database Administration & Monitoring, Postgres | No Comments

By Franck Pachot . In pgSentinel: the sampling approach for PostgreSQL I mentioned that one of the advantages of the ASH approach is the ability to drill down from an overview of the database activity, down to the details where we can do some tuning. The idea is to always focus on the components which are relevant to our tuning goal: Filter/Group by the relevant dimension to focus on what you want to tune (a…

Read More
Daniel Westermann

PGDay Amsterdam – follow up 1 – Adding columns with a default value and changing the default value right after

By | Database Administration & Monitoring | No Comments

As always, this time during my talk about the PostgreSQL 11 new features in Amsterdam, there have been question I could not immediately answer. The first one was this: Suppose we add a column with a default value in PostgreSQL 11, what happens when we change that default afterwards? Does the table get rewritten? Do we have more than on distinct default value for that column? Here we go …

Read More
Daniel Westermann

What a great event – PGDay Amsterdam

By | Database Administration & Monitoring | No Comments

PostgreSQL conferences are always cool and this time it was in Amsterdam: PGDay Amsterdam. Beside that meeting all the great people was fun again the location was really outstanding: The TOBACCO Theater: Some impressions: Here you can see Devrim preparing the opening of the event with the introduction session: … and then it happened: We finally started: Jan kicked of the sessions with his talk about the reasons he finally arrived in the PostgreSQL community…

Read More