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​

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.

How to connect​

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