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.
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).
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_dump with your Postgres credentials to export your database to a file (e.g., dump.sql).
To only migrate a single database schema, add the --schema=PATTERN parameter to your pg_dump command.
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 tocontact our support teamfor assistance in provisioning the required resources and ensuring a smooth migration process.