Test the connection between your RDS and EC2 instances
- In https://console.aws.amazon.com/rds/home#databases:, select the RDS instance to migrate.
- On your intermediary EC2 instance, use the values of
Endpoint,Port,Master username, andDB nameto create the postgres connectivity string to theSOURCEvariable.
The value of Master password was supplied when this Postgres RDS instance was created.
Test your connection:
You are connected to your RDS instance from your intermediary EC2 instance.
===== PAGE: https://docs.tigerdata.com/_partials/_migrate_live_setup_connection_strings/ =====
These variables hold the connection information for the source database and target Tiger Cloud service. In Terminal on your migration machine, set the following:
You find the connection information for your Tiger Cloud service in the configuration file you downloaded when you created the service.
Avoid using connection strings that route through connection poolers like PgBouncer or similar tools. This tool requires a direct connection to the database to function properly.
===== PAGE: https://docs.tigerdata.com/_partials/_psql-installation-windows/ =====