Google Managed PGSQL DB migration to DigitalOcean Managed PGSQL DB
Install pg_dump and pg_restore or install entire PostgreSQL Binaries on your local machine or EC2, Droplet compute.
Create a dump file using pg_dump that contains the data to be loaded from GCP PG:
pg_dump -Fc -v --host=&lt;IP or hostname&gt; --username=&lt;dbadmin&gt; --dbname=&lt;DB name&gt; -f  dbname.dump


Restore the data into the target Database for PostgreSQL using pg_restore :
After you've created the target database, you can use the pg_restore command and the -d, --dbname parameter to restore the data into the target database from the dump file.
pg_restore -v --no-owner --host==&lt;IP or hostname&gt; --port=&lt;port&gt; --username=&lt; dbadmin &gt; --dbname=&lt;target database name&gt; dbname.dump

--no-owner parameter causes all objects created during the restore to be owned by the user specified with --username. For more information , click on pg_restore.