Migration from PostgreSQL to CloudSQL and PGLOGICAL

[Rodrigo_Albin]

Hi Guys! We are in the process of migrating a PostgreSQL database to Cloud SQL and we have encountered the requirement to install PGLOGICAL in the instance where the DB is located.
The instance runs on Windows, is there a procedure we need to follow to install PGLOGICAL?

Is this possible?

Thank you so much!!

[ms4446]

pglogical is not officially supported on Windows.

 https://www.2ndquadrant.com/en/resources-old/pglogical/pglogical-installation-instructions/.

However, there are some workarounds to install pglogical on Windows but it can be a bit challenging:

https://www.2ndquadrant.com/en/blog/compiling-postgresql-extensions-visual-studio-windows/

https://github.com/mbijon/winpglogical/tree/master

I think a better approach would be to use a tool like pg_dump or pg_dumpall. These tools allow you to export your database to a file, which can then be imported into a PostgreSQL instance running on Google Cloud SQL.

[Rodrigo_Albin]

Hi! Thank you!

What could I do to be able to use the database migration service? (bearing in mind that Postgres runs on Windows)

Does Google not contemplate this casuistry?

[ms4446]

Database Migration Service requires logical replication, which is typically provided by the pglogical extension in PostgreSQL. Unfortunately, pglogical is not officially supported on Windows, and installing it requires some complexities i.e. the use of tools like Visual Studio and compiling DLLs.

The easiest approach to perform a one time migration would be to use pg_dump or pg_dumpall to export your database to a file. This file can then be imported into your new PostgreSQL instance on Google Cloud SQL.