The database of your app

On the App plan your app gets its own Postgres database and its own user on a server that is used only for App customers, in the EU (Ireland). The connection string is in DATABASE_URL. Limits: 1 GB and 10 connections per app. Use a connection pool in your app; ten connections is enough for a normal Node app but not for one that opens a connection per request.

Backups: every night a copy of your database, kept for 90 days in two places; you request a restore to an earlier day in your portal. On top of that the server can go back to any moment in the last 7 days; ask for that in a ticket. Deleting the app keeps the database 30 days as a backup, then it is dropped.

Your own server: on the Platform plan you can switch on a dedicated Postgres server (from small to large) at the rate on /rates; a stopped server is kept 7 days, then deleted.

Export: ask in a ticket for a pg_dump of your database; we provide it as a file.