Gilles Darold

Gilles Darold is a PostgreSQL Expert and Developer. He is involved in the world of PostgreSQL and Linux for over 25 years and have worked on many different projects covering PostgreSQL administration, performance tuning, advanced backup and recovery, replication, and high availability. He is also an expert in Oracle to PostgreSQL migrations and the creator of the well known Ora2Pg tool. Gilles started using PostgreSQL in 1995, and since then he has created some well known tools around PostgreSQL like pgBadger for log analysis, Ora2Pg to migrate Oracle database and more recently pgCluu for performance analysis or pgFormatter. He has also contributed to PostgreSQL with various extensions like Global Temporary Tables, Rollback at Statement Level, URI, etc..

Announcing PG_DBMS_JOB in PostgreSQL for Oracle DBMS_JOB compatibility

When you are working on Oracle to PostgreSQL migrations, one of the Oracle packages that cause conversion issues is DBMS_JOB. Traditionally, we used extensions like : pg_agent, pg_cron or more recently pg_timetable for scheduling jobs. All of these tools or extensions use a cronjob like scheduling method which does not give a full compatibility of the features provided …

Announcing PG_DBMS_JOB in PostgreSQL for Oracle DBMS_JOB compatibility Read More »

Validate PostgreSQL extension upgrade scripts using pg_validate_extupgrade

A few days ago, I decided to try this new extension called pg_validate_extupgrade written by Julien Rouhaud. This extension looks very interesting for those who are developing PostgreSQL extensions. The point is that when upgrading the extensions that you develop, you have to create upgrade files and, if necessary, downgrade files to go from one installed version to …

Validate PostgreSQL extension upgrade scripts using pg_validate_extupgrade Read More »

Ora2PG now supports oracle_fdw to increase the data migration speed

It has been 20 Years since i have been maintaining the Ora2Pg project, an Open Source software for Oracle to PostgreSQL migrations. The first version of Ora2Pg released on 9th May, 2001. Since then, there have been several features related to schema conversions and data migrations. Over a period of time, i have witnessed several tens of thousands …

Ora2PG now supports oracle_fdw to increase the data migration speed Read More »

Global Temporary Table in PostgreSQL

One of the common problems while migrating from Oracle to PostgreSQL is the need of Global Temporary Tables in PostgreSQL (GTT). There is no PostgreSQL equivalent for global temporary tables. Due to this reason, I have originally started the developed of an extension called : PGTT, to reduce the overall efforts involved while migrating from Oracle to PostgreSQL. …

Global Temporary Table in PostgreSQL Read More »

Scroll to Top