Skip to main content

PostgreSQL Overview

KakaoCloud PostgreSQL is a fully managed database service based on PostgreSQL, an open-source object-relational database management system (ORDBMS). Without separate installation or complex configuration, you can create PostgreSQL instances from the console and operate them securely in a logically isolated VPC environment.

For more information about PostgreSQL, see the official PostgreSQL documentation.

Terms
  • ORDBMS (Object-Relational DBMS): A database management system that extends the relational database model with object-oriented concepts. PostgreSQL supports user-defined types, functions, and extensions, enabling complex data models and queries.
  • PostgreSQL: An open-source object-relational database that supports standard SQL, ACID transactions, JSON, extensions, and more. It is widely used in applications where data consistency and scalability are important.

Supported versions​

KakaoCloud PostgreSQL provides service based on the PostgreSQL 14 series (14.x), and detailed patch and minor versions will continue to be added. The latest supported version is 14.17.
Supported features and end-of-life (EOL) schedules may vary by version. Versions past EOL no longer receive security patches, so refer to the official release notes and official documentation to select a version suitable for your operating environment.

Supported engine and versions
  • PostgreSQL: 14.14, 14.17

Use cases and purpose​

PostgreSQL is used as a data store for applications that require data consistency, scalability, and standard SQL compatibility. It is suitable for environments that need to process complex data models and queries by using object-relational database characteristics and extensions.

  • Services that require stable relational data management, such as web applications and internal business systems
  • Services that require flexible data models using JSON, user-defined types, and extensions
  • Services that require complex query processing, such as log storage and analytics platforms
  • Services where data consistency is important, such as location-based services, financial systems, and healthcare information systems

Features​

Object-relational database​

  • Provides a PostgreSQL-based database environment that supports standard SQL, ACID transactions, JSON, and extensions
  • Can be used for applications that require data consistency and scalability

Extension-based configuration​

  • Provides major extensions by default so PostgreSQL features can be used by database
  • Manages some extensions, such as pg_cron, according to the provided method and usage restrictions

Parameter and storage operation management​

  • Manages PostgreSQL configuration parameters by version and group through parameter groups
  • Supports expanding primary storage and log storage volumes of instance groups

High availability and backups​

  • Secures data recovery points through automated and manual backups
  • Maintains service continuity by failing over to a Standby instance when the Primary instance fails
  • Restores a new instance group from an existing backup

Monitoring and log lookup​

  • Provides metrics for checking system status such as CPU and memory usage and database status such as connection count and average response time
  • Supports viewing PostgreSQL logs from the console through Log Explorer

Managed operating environment​

  • Provides various instance types for use from test environments to high-performance workloads
  • Provides key operational functions in the console, including instance group creation, backup, restore, monitoring, and failover

Network and security​

  • Deploys PostgreSQL instances in a logically isolated VPC network to control external access.
  • Uses security groups to allow database access only from permitted IP ranges and ports.

Getting started​

If you are using PostgreSQL for the first time, start with Key Concepts to understand the resource structure and operational concepts. For actual procedures such as creating instance groups, backups, and failover, see How-to Guides.

If you are new to KakaoCloud, see Getting started with KakaoCloud.