Skip to main content

PostgreSQL

PostgreSQL is a powerful, open source, object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness and performance.

How to run it​

Create volume for the data:

cgc volume create -s 5 psql-volume

Run database with volume attached:

cgc db create --name psql01 -c 4 -m 4 -v psql-volume postgresql

Default configuration​

The default configuration for PostgreSQL is set to use the PostgreSQL database engine. The database will be created with the following parameters:

  • POSTGRES_PASSWORD: The password for the PostgreSQL user. This is set to CGC specific app_token that you receive after creating the database.
  • POSTGRES_USER=admin: The user for the PostgreSQL database.
  • POSTGRES_DB=db: The name of the PostgreSQL database. This is set to the name you provided when creating the database.
  • POSTGRES_HOST_AUTH_METHOD=trust: Configures PostgreSQL to skip password verification for connections, trusting that authentication has already occurred at the system level. This is convenient for development but creates a significant security risk in production environments.
info

If you wish to overwrite POSTGRES_PASSWORD and keep it displayed correctly during cgc compute list -d, we advice using CGC flag -ce app_token=YOUR_PASSWORD

How to connect​

To learn more about the usage of CGC SDK, please visit here