Daniel Westermann

GoldenGate 12.2: ERROR: Unable to create a new wallet

Today I had a very strange issue when setting up a brand new GoldenGate 12.2 installation. Installation went fine, patch went fine (PSU 170221) and then I started to configure GoldenGate. One of the first commands we usually do is:(…)

Can I do it with PostgreSQL? – 11 – NLS_DATE_FORMAT

Following the last post about time zones this post is about the display and default format of date and time values. What people usually do to get a consistent display of date and time values in Oracle(…)

Can I do it with PostgreSQL? – 10 – Timezones

This post is inspired by a question we received from a customer: In Oracle there is the sessiontimezone which returns the time zone of the session. Asking for the time zone of the session in Oracle returns(…)

Vertically scale your PostgreSQL infrastructure with pgpool – 3 – Adding another standby

In the first and second post in this series we did the basic pgpool setup including the watchdog configuration and then did a simple setup for automatically failover from a PostgreSQL master instance in case it(…)

Vertically scale your PostgreSQL infrastructure with pgpool – 2 – Automatic failover and reconfiguration

In the first post of this little series we did the basic setup of pgpool and configured the watchdog. So, as of now, pgpool uses a VIP which is active on one of the(…)

Vertically scale your PostgreSQL infrastructure with pgpool – 1 – Basic setup and watchdog configuration

I have written some posts on how you can make your PostgreSQL deployment high available by using PostgreSQL's streaming replication feature in the past ( 1, 2 ). The main issue you'll have to(…)

EDB BART 2.0 – How to upgrade and block level incremental backups

We already have some posts on how you can use EDB BART to backup and restore your PostgreSQL instances from one central server (EnterpriseDB Backup and Recovery Tool (BART), getting started with postgres plus(…)

Is it the right time to move to MariaDB now?

Do you think about adding MariaDB to your database landscape or do you even think about replacing other database systems with MariaDB? Then you should register here. We will be doing a webinar with MariaDB on(…)

OGG: Unable to lock file “/xxx/de000000” (error 11, Resource temporarily unavailable).

When you see the above message in the GoldenGate logfile there are usually orphan processes that prevent GoldenGate from locking the file (typically when your trail files are on NFS). In a case I had at a customer last week(…)

Converting a column from one data type to another in PostgreSQL

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(…)