I've recently wanted to try out AlloyDB, which looks like a nice and decent product. And since we are already on GCP, I wanted to just migrate the data from our cloud sql postgres to an alloydb cluster and test how it changes performance.

I first tried myself but quickly ran into issues because I couldn't get the migration job to work. Our cloud postgres runs within a non-default VPC and is usually accessed via private IP or cloud proxy.

Then I handed over that task to a specialized consultant with GCP experience. They spent some time and got much further but eventually listed all the issues that they had on the way, including severe lack of documentation.

I'm baffled that GCP apparently isn't able to offer a simple built-in migration job in which I select my cloud sql postgres instance and it migrates the data from it into a new alloydb cluster which offers the same connectivity like cloud postgres (public IP with certificates or private IP or cloud sql proxy).

Sorry for the rant...