Postgres
This guide shows how to migrate any Postgres database to Hydra. This migration requires the pg_dump and psql CLI tools, which are installed automatically as part of the complete PostgreSQL installation package.
Retrieve your Postgres database credentials
- Log in to your provider to get the connection details for your Postgres database. You’ll need the hostname, username, password, and port (if not 5432).
Retrieve your Hydra connection string
- If you’re new to Hydra, create a project.
- Select the project in the Hydra Platform and obtain your credential.
Migrate the database
You can use the pg_dump and psql command line tools, which are included in a full PostgreSQL installation.
-
Export your database to a file in console
Use
pg_dumpwith your Postgres credentials to export your database to a file (e.g.,dump.sql).PGPASSWORD=$PASSWORD pg_dump --clean --if-exists --quote-all-identifiers -h $HOST -U $USER -d $DATABASE -p $PORT --no-owner --no-privileges > dump.sql -
Import the database to your Hydra project
Use
psqlto import the Postgres database file to your Hydra project.psql -d "$HYDRA_CONNECTION_STRING" -f dump.sql
Additional options
- To only migrate a single database schema, add the
--schema=PATTERNparameter to yourpg_dumpcommand. - To exclude a schema:
--exclude-schema=PATTERN. - To only migrate a single table:
--table=PATTERN. - To exclude a table:
--exclude-table=PATTERN.
Run pg_dump --help for a full list of options.
- If you’re planning to migrate a database larger than 6 GB, we recommend upgrading to at least a Medium compute instance. This will ensure you have the necessary resources to handle the migration efficiently.
- You can increase the size of the disk on paid projects by navigating to the project Settings tab.
- If you’re dealing with a database larger than 150 GB, we strongly advise you to contact our support team for assistance in provisioning the required resources and ensuring a smooth migration process.
Enterprise
Contact us if you need more help migrating your project.