Infrastructure at your Service

enterprisedb Archives - Page 3 of 3 - Blog dbi services

Daniel Westermann

Installing EDB Postgres Advanced Server 9.5

By | Database Administration & Monitoring | 5 Comments

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. Some time ago I blogged on how to install the 9.4 release. In this post I want to check if anything changed in the installation process. Installing Postgres Advanced server usually is just clicking next,next,next and you’re done if you…

 
Read More
Daniel Westermann

The Postgres Plus® Cloud Database

By | Database Administration & Monitoring | No Comments

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 is to use the The Postgres Plus® Cloud Database offered by EnterpriseDB. I will not go through the whole setup here as this is described in detail here. So once you went through the registration and setup process you should be able to login. The login URL…

 
Read More
Daniel Westermann

pg_dump: [archiver (db)] query failed: ERROR: schema “sys” does not exist

By | Database Administration & Monitoring, Database management | No Comments

As I could not find any information about this error when I faced it this is just a short hint: If you try to use pg_dump or pg_dumpall out of a PPAS installation to dump or dumpall a community version of PostgreSQL you probably get this: pg_dump: [archiver (db)] query failed: ERROR: schema “sys” does not exist pg_dump: [archiver (db)] query was: SET search_path = pg_catalog, sys, dbo The solution is quite easy but you…

 
Read More
Daniel Westermann

Migrating the Oracle 12cR1 sample schemas to PostgreSQL Plus Advanced Server 9.4

By | Database Administration & Monitoring | No Comments

This post takes a look on how to migrate the Oracle 12cR1 sample schemas to PPAS 9.4 (PostgreSQL Plus Advanced Server 9.4). I’ll not dig into how to install PPAS as this was described in detail some time ago. Just follow this post if you need a setup guide. If you wonder why I am doing this there are two reasons: to see if it works, to have fun and to learn PostgreSQL and PPAS…

 
Read More