> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hydra.so/llms.txt
> Use this file to discover all available pages before exploring further.

# RDS

This guide shows how to migrate your Amazon RDS Postgres database to Hydra. This migration requires the [pg\_dump](https://www.postgresql.org/docs/current/app-pgdump.html) and [psql](https://www.postgresql.org/docs/current/app-psql.html) 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](https://aws.amazon.com/rds/).

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.

<img src="https://mintcdn.com/pgxman/yL_jvOZ3zOfO9lO9/images/migration/migration-rds.png?fit=max&auto=format&n=yL_jvOZ3zOfO9lO9&q=85&s=853c7dd14a29e2ddd766041c248a513e" alt="" width="1200" height="772" data-path="images/migration/migration-rds.png" />

## 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

<AccordionGroup>
  <Accordion title="pg_dump" defaultOpen={false} icon="download" iconType="solid">
    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`).

    ```sql theme={null}
    pg_dump --clean --if-exists --quote-all-identifiers -h $RDS_HOST -U $RDS_USER -d $RDS_DATABASE --no-owner --no-privileges > rds_dump.sql
    ```
  </Accordion>

  <Accordion title="pg_restore" defaultOpen={false} icon="upload" iconType="solid">
    Import the database to your Hydra project. Use `psql` to import the RDS database file to your Hydra project.

    ```sql theme={null}
    psql -d "$YOUR_CONNECTION_STRING" -f rds_dump.sql
    ```
  </Accordion>
</AccordionGroup>

### 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](/platform/support)

  for assistance in provisioning the required resources and ensuring a smooth migration process.

## Enterprise

[Contact us](/platform/support) if you need more help migrating your project.