PostgreSQL on Shiper

Shiper provides a managed PostgreSQL solution with high availability. When you create a new database, you can configure CPU, memory, and storage size based on your requirements. Each setup includes two PostgreSQL instances to ensure data availability.

Connecting to Your Database

You can connect to your Shiper database using any PostgreSQL client. The connection string is provided on the database overview page. By default, databases are private and accessible only by applications within your Shiper account. If you need external access, you can expose the database through the toggle on the right side of the overview page.

Using psql to Connect

To connect using the psql command-line tool, use the following format:

psql -h your-database-slug.db.shiper.app -U <username> -d <database>

Replace <username> with your database username and <database> with the database name from the dashboard. Update your-database-slug.db.shiper.app with your actual database slug.

Extensions

The following extension is enabled by default on all databases:

• pg_stat_statements

Backups

Shiper automatically backs up your database daily and retains backups for the last 14 days. You can restore backups directly from the dashboard. All backups are encrypted and stored securely.

Billing

Billing is based on the number of databases and the compute and storage resources allocated per database. Charges are calculated at the end of each month based on usage time. For example, if a database is created and deleted within 5 minutes, it will still incur a charge for the full hour but not for the entire month.