RDS
This guide shows how to migrate your Amazon RDS 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 Amazon RDS database credentials
-
Log in to your Amazon RDS account.
-
Select the region where your RDS database is located.
-
Navigate to the Databases tab.
-
Select the database that you want to migrate.
-
In the Connectivity & Security tab, note down the Endpoint and the port number.
-
In the Configuration tab, note down the Database name and the Username.
-
If you do not have the password, create a new one and note it down.
Retrieve your Hydra connection string
-
If you’re new to Hydra, create a project.
-
Go to the Dashboard section for your project in the Hydra Platform to get your credentials.
Migrate the database
pg_dump
pg_dump
Export your RDS database to a file in console. Use pg_dump with your RDS credentials to export your Render database to a file (e.g., rds_dump.sql).
pg_restore
pg_restore
Import the database to your Hydra project. Use psql to import the RDS database file to your Hydra project.
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
for assistance in provisioning the required resources and ensuring a smooth migration process.
Enterprise
Contact us if you need more help migrating your project.