Migrating from an Oracle database to PostgreSQL frequently gives organizations benefits that range from lowered costs to a better technical architecture. The OpenSCG Migration Factory speeds the process while reducing risk.
This white paper explores the process for migrating an application from an Oracle database to PostgreSQL. It is intended for people who have already made the wise choice of moving to PostgreSQL and are exploring what is involved in a migration project.
The philosophy of PostgreSQL is a bit different than Oracle. In Oracle, the base data types are fairly basic and put the responsibility on the developer to handle the logic of the data. PostgreSQL optimizes at the lower level data types for common business problems freeing up developer time and effort for more important things.
This paper will delve into PostgreSQL’s built-in data types and talk about when and how to use them most effectively to avoid common pitfalls and mistakes Oracle developers often make using PostgreSQL.
This whitepaper has been designed to deliver valuable information for developers, database architects, or technical staff responsible for managing a large number of PostgreSQL database instances spread across multiple continents, coasts, data-centers and clouds.
Security Hardening PostgreSQL
Recent PostgreSQL security updates are a reminder of the importance of staying up to date with critical software patches. OpenSCG continually updates our open source distributions to ensure software security. However, applying critical patches is just one of the many tasks to perform when securing and hardening your database platforms.