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

# Render

This guide shows how to migrate your Render 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 Render database credentials

1. Log in to your [Render account](https://render.com/) and select the project you want to migrate.

2. Click **Dashboard** in the menu and click in your **Postgres** database.

3. Scroll down in the **Info** tab.

4. Click on **PSQL Command** and edit it adding the content after `PSQL_COMMAND=`.

<img src="https://mintcdn.com/pgxman/yL_jvOZ3zOfO9lO9/images/migration/migration-render.png?fit=max&auto=format&n=yL_jvOZ3zOfO9lO9&q=85&s=db51bdcbdb4a646ce652ee86500f7f80" alt="" width="1000" height="648" data-path="images/migration/migration-render.png" />

Example:

```
env PSQL_COMMAND=PGPASSWORD=RgaMDfTS_password_FTPa7 psql -h dpg-a_server_in.oregon-postgres.render.com -U my_db_pxl0_user my_db_pxl0
```

## Retrieve your Hydra connection string

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

2. Go to the Project section for your project in the Hydra Platform.

## Migrate the database

<AccordionGroup>
  <Accordion title="pg_dump" defaultOpen={false} icon="download" iconType="solid">
    Export your Render database to a file in consoleUse`pg_dump`with your Render credentials to export your Render database to a file (e.g.,`render_dump.sql`).

    ```bash theme={null}
    pg_dump --clean --if-exists --quote-all-identifiers -h $RENDER_HOST -U $RENDER_USER -d $RENDER_DATABASE --no-owner --no-privileges > render_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 Render database file to your Hydra project.

    ```bash theme={null}
    psql -d "$HYDRA_CONNECTION_STRING" -f render_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.