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

1. Log in to your Amazon RDS account.

2. Select the region where your RDS database is located.

3. Navigate to the Databases tab.

4. Select the database that you want to migrate.

5. In the Connectivity & Security tab, note down the Endpoint and the port number.

6. In the Configuration tab, note down the Database name and the Username.

7. If you do not have the password, create a new one and note it down.

​

Retrieve your Hydra connection string

1. If you’re new to Hydra, create a project.

2. Go to the Dashboard section for your project in the Hydra Platform to get your credentials.

​

Migrate the database

pg_dump --clean --if-exists --quote-all-identifiers -h $RDS_HOST -U $RDS_USER -d $RDS_DATABASE --no-owner --no-privileges > rds_dump.sql

psql -d "$YOUR_CONNECTION_STRING" -f rds_dump.sql

​

Additional options

• 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 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.