PostgreSQL guide
Attach PostgreSQL to an app
Choose PostgreSQL during project creation, then keep schema, migration, data, and recovery work explicit.
Choose the database with the project
- 1Select Attach PostgreSQL during the GitHub checkout flow or when adding a project from the portal.
- 2Choose the app region. The attached database is placed with the project.
- 3Create the project and follow provisioning from its overview.
Use the connection variables
Host Little configures DATABASE_URL and POSTGRES_URL for the app. Their secret values remain redacted in the portal and logs.
Use the variable name your application already expects. The account owner can reveal a separate TLS verify-full connection on the project overview for psql or pg_dump. Do not copy either connection into source control or support messages.
Run migrations deliberately
Your application or release process owns schema migrations, indexes, queries, and seed data. Test destructive changes before running them against production data.
A healthy database resource does not prove that the application schema is current. Verify a path that reads and writes the expected tables.
Own backup and recovery
Use the owner-only TLS connection with pg_dump and test your restore process. Host Little does not include automated backups, managed restores, credential rotation, or managed DBA work.
Deleting the project also deletes its attached PostgreSQL data. Make and verify any required backup before confirming deletion.