PostgreSQL is a powerful, enterprise-grade open source database system that is production-proven to multiple terabytes with OLTP workloads. It is freely available for easy on premise installation on all major server operating systems, and is also available as a scalable database cloud service (DBaaS) from trusted providers
like Amazon Aurora for PostgreSQL, which offers self-serve control with cost-effective high availability, security, & scalability. Amazon also provides a robust Data Migration Service and Schema Conversion Tool to facilitate migration and synchronization of data from other databases.
Oracle shops looking to migrate their applications – unchanged – to a more cost-effective database find that the commercially-supported PostgreSQL Plus from Enterprise DB provides virtually seamless Oracle runtime compatibility with dramatically lower DB license fees.
PostgreSQL is the open source database of choice for open source projects that require OLTP scalability, concurrency and data integrity–including the Openbravo ERP Platform (which also natively supports the Oracle database). While PostgreSQL includes its own powerful tools for administration such as pgAdmin, it also includes robust ODBC and JDBC drivers, enabling access from popular cross-database administration tools like DB Visualizer.
At Agility ERP we have deep experience over the years with Microsoft SQL Server, Oracle, IBM DB2, and now PostgreSQL–and we heartily recommend PostgreSQL without reservation for mission critical workloads like ERP.