Daniel Westermann

Installing EDB Postgres Advanced Server 9.5

Some days ago EnterpriseDB released EDB Postgres Advanced Server 9.5. As usual this release contains all new features that have been introduced with PostgreSQL 9.5 plus the additions that are documented in the release notes.

The Postgres Plus® Cloud Database

In the last posts (1, 2, 3, 4, 5) I looked at PostgreSQL in Amazon RDS. Another option you have if you want to go to the cloud(…)

Avoiding access to the public schema in PostgreSQL

In PostgreSQL every database contains the public schema by default. Every user that gets created and can login is able to create objects there. Here is a little demo: I’ll create a new user named u1 which is allowed to(…)

Using the official PostgreSQL yum repositories

Usually I advice to build PostgreSQL from source as it gives the most flexibility. Another option is to use the official yum repositories. There is one repository for each supported release of PostgreSQL and(…)

Launching a VM with the Amazon AWS command line tools

The cool thing with Amazon AWS is that you can use command line tools on your workstation to bring up and manage your services. In this post I’ll look into how you can launch a Linux VM from(…)

External tables in PostgreSQL?

In Oracle you can use the external table feature to load data from files into the database. The traditional way to do this in PostgreSQL is to use the copy command. But there is(…)

PostgreSQL on Amazon RDS – Loading the beast

The last posts outlined how you can bring up a PostgreSQL instance in the Amazon cloud, how you can restrict access to the instance, how you can configure it and how you can(…)

PostgreSQL on Amazon RDS – Adding a replica to the beast

In the last post I looked on how you can change the PostgreSQL parameters when the instance is running in the Amazon cloud. In this post we’ll look at how to add a replica to the PostgreSQL instance(…)

PostgreSQL on Amazon RDS – Configuring the beast

In the last post I looked at how you can strengthen the security for your PostgreSQL instance in Amazon RDS. In this post I’ll look at how you can configure your PostgreSQL instance. When you login to(…)

PostgreSQL on Amazon RDS – Securing the beast

In the last post I looked at how to bring up a PostgreSQL instance in the Amazon cloud. In this post I’ll look into how to restrict access to this instance to specific IP addresses to strengthen security.