VMware SQL with Postgres for Kubernetes
VMware Postgres Operator helps you quickly and reliably deploy Postgres instances on Kubernetes.
VMware Postgres Operator packages a collection of 100% open source software, based on the PostgreSQL source code published at http://www.postgresql.org and other open source software from the PostgreSQL community. The VMware Kubernetes Operator helps you deploy and manage one or more instances of the PostgreSQL database. It includes the following components:
- PostgreSQL – the core ORDBMS database engine.
- pgBackRest – reliable backup and restore for PostgreSQL.
- pg_auto_failover – simple and robust High Availability solution for PostgreSQL.
- PostgreSQL ODBC Driver (psqlODBC) ‐ connectivity for Linux client applications.
- PostgreSQL JDBC Driver (pgjdbc) – connectivity for Java clients.
All components included in the VMware Postgres Operator software distribution are intended for Enterprise deployments, and are supported by VMware. See the Support Lifecycle Policy and the Product Support Lifecycle Matrix for details about the duration of support for VMware Postgres Operator.
The deployed Postgres images are based on Ubuntu 22.04.
IMPORTANT: VMware Postgres does not support any additional extension components or versions outside the following list. For component inquiries, please contact VMware Support.
| VMware Postgres Version | Component | Component Version |
|---|---|---|
| 2.0.2 | PostgreSQL | 15.2, 14.7, 13.10, 12.14, and 11.19 |
| pgBackRest | 2.44 | |
| pg_auto_failover | 2.0.0 | |
| postGIS | 3.3.2 | |
| Orafce | 4.1 | |
| pgAudit | 1.7.0 (for 15), 1.6.2 (for 14), 1.5.2 (for 13), 1.4.3 (for 12), 1.3.4 (for 11) |
VMware SQL with Postgres for Kubernetes STIG Readiness Guide
The Security Technical Implementation Guides (STIGs) provide technical, standards-based hardening guidance used by customers in the Department of Defense (DoD) space.
Use the PostgreSQL STIG Readiness Guide, which provides steps on how to configure PostgreSQL for STIG compliance.
To meet the checks outlined in the STIG, ensure that:
- you use the Postgres 14 or Postgres 15 versions provided with VMware Postges Operator 2.0.2, which use OpenSSL with FIPS enabled. Refer to Release Notes.
- you configure the Postgres server behavior as outlined in updating PostgreSQL parameters.
PostgreSQL
PostgreSQL is a powerful, open source object-relational database system that has more than 15 years of active development. It offers a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. PostgreSQL is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. PostgreSQL has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.
Major features of PostgreSQL include:
- Multi-Version Concurrency Control (MVCC)
- Point in time recovery
- Tablespaces
- Asynchronous replication
- Nested transactions (savepoints)
- Online/hot backups
- A sophisticated query planner/optimizer
- Write ahead logging for fault tolerance
- International character sets
- Multibyte character encodings
- Unicode
- Locale-aware support for sorting case-sensitivity, and formatting
