Unable to connect to source Postgres DB

Google Cloud Database
1

Hello, I’m getting the following error while trying to test connectivity of my databse migration service.

Failure connecting to the source database. Make sure the connectivity information on the connection profile is correct and the source database is reachable. Address the issues then Start the migration job.
generic::unknown: unable to connect to source database server via database postgres: connecting to the source database “postgres”: connectWithTimeoutAndRetry timeout with error: dial tcp public-ip:5432: connect: connection timed out

Trying to migrate a public database (Cloud SQL) from one project to another new instance(PSC enabled)

Source profile
Hostname: Public IP of the source (It has 0.0.0.0/0 enabled)[Have also conencted to this instance from multiple machines so firewall is not an issue]
Port: 5432
user: User with the correct permissions
password (verified 20 times it is correct)

Migration job details
connectivity : PSC
Type: Continious
PostgreSQL → CloudSQL
Destination DB: psc enabled db which

2

The timeout error indicates that Database Migration Service (DMS) cannot reach your source database over the network, even though the public IP and credentials are correct. Since your destination uses Private Service Connect (PSC), DMS requires a private connectivity path to the source database; public IP access alone won’t work with PSC. To fix this, either enable DMS to connect over a VPC peering or VPN from the PSC-enabled project to the source Cloud SQL instance, or temporarily allow the migration to use public IP connectivity without PSC for testing.