Amazon Redshift clusters are using port 5439 (default port) for database access.
In AWS Console -
In Terraform -
References:
https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-clusters.html
https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/redshift_cluster#port