PostgreSQL

Resource Creation

You can create PostgreSQL databases using the convox resources create command:

$ convox resources create postgres
Creating postgres-3785 (postgres)... CREATING

This will provision postgres database on the Amazon RDS service. Creation can take up to 15 minutes. To check the status use convox resources info.

Additional Options

OptionDescription
--allocated-storage=10Size of the database in GB
--database=appThe name of the database to create
--instance-type=db.t2.microRDS instance type to use
--max-connections={DBInstanceClassMemory/15000000}Maximum connections to allow
--multi-azEnhanced availability and durability
--name=<name>The name of the resource to create
--password=<password>Database server password
--privateCreate in private subnets
--username=<username>Database server username
--version=9.5.2Postgres version

Resource Information

To see relevant info about the database, use the convox resources info command:

$ convox resources info postgres-3785
Name    postgres-3785
Status  running
URL     postgres://postgres:i3tNTHpZ8wmCn88nvN2c@dev-postgres-3785.cbm068zjzjcr.us-east-1.rds.amazonaws.com:5432/app

Resource Linking

You can add this URL to any application with convox env set:

$ convox env set 'DATABASE_URL=postgres://postgres:i3tNTHpZ8wmCn88nvN2c@dev-postgres-3785.cbm068zjzjcr.us-east-1.rds.amazonaws.com:5432/app' --app example-app

Resource Deletion

To delete the database, use the convox resources delete command:

$ convox resources delete postgres-3785
Deleting postgres-3785... DELETING

Deleting the database will take several minutes.

This action will cause an unrecoverable loss of data.