Resources, tips, and tricks on PostgreSQL high availability, monitoring, tuning, security, and migration
How to convert Oracle to PostgreSQL OnlineKashif Zeeshan—9/28/2020
This article discusses tools for migrating schema online from Oracle to PostgreSQL and EDB Postgres Advanced Server. EDB Postgres Advanced Server and PostgreSQL Challenges of converting database schemas online Why migrate to PostgreSQL from Oracle? Why migrate to EDB Postgres Advanced Server from Oracle? Online tools to convert Oracle databases How to convert database schemas using Ora2Pg How to convert schemas using Migration Portal and EDB Postgres Advanced Server How to migrate from Oracle to PostgreSQL using ora_migrator
Creating a dblink from Oracle to PostgreSQLAmit Sharma—6/29/2020
This article shows how to create a dblink connection from Oracle to EDB Postgres Advanced Server or PostgreSQL, Installation Connection Testing connectivity There are several reasons where we might need to use both Orac ...
Porting between Oracle and PostgreSQLArun Gavhane—6/22/2020
This article discusses the possible complications that can arise when migrating databases from Oracle to PostgreSQL. The steps for migration are covered and issues and their fixes are identified: Approach to migration Schema migration Code ...
How to easily convert Oracle procedures to PostgreSQLTushar Ahuja—3/5/2020
<p>This article gives five examples of converting procedures from Oracle’s PL/SQL procedural language into PostgreSQL’s PL/pgSQL language.</p>
Strategy for migrating partitioned Oracle database tables to PostgreSQLRajkumar Raghuwanshi—3/5/2020
This article highlights differences in table partitioning between Oracle and PostgreSQL and provides key points to consider before migration partitioned data between them.
How to configure heterogeneous connections from Oracle to PostgreSQLTushar Ahuja—3/3/2020
<p>This article discusses heterogeneous connections and how to set up a connection from Oracle to PostgreSQL using one.</p>
Partitioning commands in PostgreSQL compatible with Oracle databasesShivam Dhapatkar—3/3/2020
<p>This article provides information about the types and benefits of table partitioning and using the table partitioning syntax compatible with Oracle databases supported by EDB’s Advanced Server (EDB’s Postgres database). </p>
Accessing PostgreSQL databases using psqlODBC in OracleRaghavendra Rao—2/21/2020
<p>This article demonstrates how to use the PostgreSQL client interface psqlODBC driver in Oracle to access PostgreSQL data. </p>
How NULL and empty strings are treated in PostgreSQL vs OracleThom Brown—2/12/2020
This article discusses the differences between how Oracle and PostgreSQL evaluate NULL characters and empty strings. Oracle reads empty strings as NULLs, while PostgreSQL treats them as empty. Concatenating NULL values with non-NULL characters results in that character in Oracle, but NULL in PostgreSQL.
How to run Postgres in Oracle compatibility modeAmit Sharma—2/12/2020
This article discusses the advantages of the Oracle compatibility features in EDB Postgres Advanced Server and gives instructions for setting up compatibility during installation and for checking its availability in an existing cluster.
Using Foreign Data Wrappers to access remote PostgreSQL and Oracle databasesPiyush Sharma—1/14/2020
<p>This article explains how to use Foreign Data Wrappers to access data in remote PostgreSQL and Oracle databases.</p>
How to run hierarchical queries in Oracle and PostgreSQLTushar Ahuja—12/19/2019
<p>This article introduces hierarchical queries and shows the differences in their usage between Oracle and PostgreSQL.</p>
Switchover/Failover and Session MigrationBruce Momjian—10/5/2018
<p>I have already covered switchover and failover. In the case of failover, the old primary is offline so there are no options for migrating clients from the old primary to the new primary. If there is a switchover, there are options for client migration. Assuming you are using streaming replication, only one server can accept writes</p>
Why I picked Postgres over Oracle, Part IIIJan Karremans—1/30/2018
<p>This is the final episode of this short series of blog posts on some of my drivers for moving to Postgres from Oracle. Please do read Part I and Part II of the series if you have not done so. It discussed the topics “History”, “More recently”, “The switch to Postgres”, “Realization”, “Pricing”, “Support” and “Extensibility”.</p>
Why I picked Postgres over Oracle, Part IJan Karremans—1/12/2018
<p>I have started with databases quite early on in my career. RMS by Datapoint… was it really a database? Well, at least sort of. It held data in a central storage, but it was a typical serial “database”. Interestingly enough, some of this stuff is maintained up to today. (Talk about longevity!)</p>
Why I picked Postgres over Oracle, Part IIJan Karremans—1/12/2018
<p>Continuing this short series of blog posts on some of my drivers for moving to Postgres from Oracle. Please read Part I of the series if you have not done so. It discussed the topics “History”, “More recently” and “The switch to Postgres”.</p>
BigAnimal: Fully managed PostgreSQL in the cloud
BigAnimal features Oracle compatibility, built-in high availability, and 24/7 support from our team of PostgreSQL experts.Learn more
Demo of Oracle SQL compatibility in BigAnimal
BigAnimal lets you run Oracle SQL queries in the cloud via EDB Postgres Advanced Server. Watch the video, or load up psql and follow along.Learn more