Infrastructure at your Service

PostgreSQL Archives - Blog dbi services

Daniel Westermann

Converting a column from one data type to another in PostgreSQL

By | Database Administration & Monitoring | 2 Comments

Last week at a customer the following question came up: We have a varchar2 column in Oracle that contains a date but actually is stored as a string. When we want to convert this column to be a real date data type in Oracle we can use dbms_redefinition. How can we do that in PostgreSQL? The first answer that came to me mind is: Add a new column (of data type date) and populate it…

 
Read More
Daniel Westermann

Can I do it with PostgreSQL? – 9 – Temporary tables

By | Database Administration & Monitoring | No Comments

It has been quite a while since the last posts in this series, so here is what we looked at until now: Can I do it with PostgreSQL? – 1 – Restore points Can I do it with PostgreSQL? – 2 – Dual Can I do it with PostgreSQL? – 3 – Tablespaces Can I do it with PostgreSQL? – 4 – External tables Can I do it with PostgreSQL? – 5 – Generating DDL…

 
Read More
Daniel Westermann

From PostgreSQL 9.1.8 to PostgreSQL 9.5.5 including a standby database with minimal downtime

By | Database Administration & Monitoring | No Comments

As you might know PostgreSQL 9.1 is out of support since last September. But, no surprise, there are still plenty of PostgreSQL 9.1 instances out there which need to be upgraded to a supported release. At one of our customers we exactly have this situation: The production environment is running on PostgreSQL 9.1.8 and needs to be upgraded to a recent release (9.5.5 in this case). To make life a little bit more fun there…

 
Read More
Daniel Westermann

2016 is over and it was great, 2017 will be even more exciting in the open source area

By | Database Administration & Monitoring | No Comments

Disclaimer: This will not be a technical post at all. The goal is to provide a short overview of what we did in 2016 and what we plan to do in 2017 when it comes to our Open Infrastructure division. We’ll start with a few figures then look at the events we did and some of the projects we completed in 2016. Here we go …  

 
Read More
Stéphane Haby

IT-Tage 2016 Informatik aktuell: feedback

By | Technology Survey | No Comments

Today, to finish the year, I post a brief personal impression of the IT-Tage 2016 in Frankfurt at the Hotel Maritim, where I was also be a speaker. I presented 2 sessions on SQL Server: “SQL Server Errorlog Entmystifizierung” & “SQL Server 2016: Neue Sicherheitsfunktionen”. I wasn’t the only one from dbi services who spoke at that conference: David Barbarin with also 2 sessions: “SQL Server – Locks, latches and spinlocks” & “SQL Server 2016…

 
Read More
Daniel Westermann

Can I do it with PostgreSQL? – 8 – Transportable tablespaces

By | Database Administration & Monitoring | No Comments

My colleague Franck posted a comment to one of my last “Can I do it with PostgreSQL” blog posts. The comment he posted is: “Here is an idea for a future “Can I do it with PostgreSQL?”. My favorite Oracle feature: transportable tablespaces.” When you’ve read my post about how PostgreSQL implements tablespaces then you probably already know the answer: No, you can not do this in PostgreSQL. Having thought about this some time I…

 
Read More
Daniel Westermann

Getting started with Docker – 2 – building your own base image

By | Database Administration & Monitoring | No Comments

In the last post we quickly looked at how you can install everything you need to run docker containers on a CentOS 7 host and did bring up the official PostgreSQL image. However there are good reasons not to rely on an existing image: You want to deliver a pre-configured base image which includes everything your application requires and you want to have control over that image. When this image needs to get updated you…

 
Read More
Daniel Westermann

Getting started with Docker – 1 – overview and installation

By | Database Administration & Monitoring | One Comment

Everybody is talking about Docker nowadays. What it is about? Do you remember Solaris Zones or Containers? It is more or less the same although development of Docker during the last years made Linux Containers the de-facto standard for deploying applications in a standardized and isolated way. Docker is build in a classical client server model: There is the docker server (or daemon) which servers the requests of docker clients. The client is the one…

 
Read More
Daniel Westermann

Can I do it with PostgreSQL? – 7 – Partitioning

By | Database Administration & Monitoring | No Comments

PostgreSQL supports tables up to 32TB. Do you want to be the one responsible for managing such a table? I guess not. Usually you start to partition your tables when they grow very fast and consume more than hundreds of gigabytes. Can PostgreSQL do this? Do you you know what table inheritance is? No? PostgreSQL implements partitioning by using table inheritance and constraint exclusion. Sounds strange? Lets have a look …  

 
Read More
Daniel Westermann

Can I do it with PostgreSQL? – 6 – Server programming

By | Database Administration & Monitoring | No Comments

Today we’ll continue this series with another topic: What does PostgreSQL provide when it comes to server programming, that is: Writing functions and triggers to support your application? In Oracle you can either use PL/SQL or Java, in MariaDB you can use stored procedures written in SQL, MS SQL Server provides Transact SQL and with DB2 you can write stored procedures in a host language or SQL.  

 
Read More