Changing a Database Port

Scenarios

After Babelfish is enabled, TaurusDB for PostgreSQL listens on two ports. The default port of a PostgreSQL database is 5432, and that of a Babelfish database is 1433.

You can change the database port of the primary instance or Babelfish database.

For primary/standby instances, changing the database port of the primary instance will cause the database port of the standby instance to also be changed.

If specific security group rules have been configured for a DB instance, you need to change the inbound rules of the security group to which the DB instance belongs after changing the database port.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > TaurusDB.
4. On the Instances page, click the primary instance name.
5. On the Basic Information page, find Database Port or Babelfish Port and click under it to change it.

   TaurusDB for PostgreSQL instances can use database ports 2100 to 9500.

   The Babelfish port can be 1433 or between 2100 and 9500.

6. In the displayed dialog box, enter YES and click OK.
   • Changing the primary instance's port updates the standby instance's port as well and causes both of them to reboot.
   • This process takes 1 to 5 minutes.

7. View the results on the Basic Information page.