PostgreSQL

Learn how to manage PostgreSQL databases in Andasy.

The postgres command allows you to manage PostgreSQL databases as services within Andasy. It provides tools to create and provision PostgreSQL instances for your applications.

This command can be accessed using any of the following aliases:

  • postgres
  • pg

Usage

andasy database postgres

For creating postgres application service

andasy database postgres create -a <app-name> [flags]

You can also use the alias:

andasy db pg create [APPNAME]

Available flags

FlagDescription
--generate-nameGenerate a random app name
-a, --appThe name of the app (required)
-h, --helpShow help for the command
-j, --jsonOutput result in JSON format
--nameThe app name to use
-o, --orgTarget Andasy organization
-p, --passwordSuperuser password for the database. If not set, a random one will be used
-s, --sizeVolume size in GB (default: 1)
--volumeVolume name (default: "data-source")