Thread: VM Instance to Google Cloud SQL Migration

VM Instance to Google Cloud SQL Migration

From
Sathish Kumar
Date:

Hi Team,

We would like to migrate our Postgresql VM instance on Google Cloud Platform to Google Cloud SQL with a minimal downtime. As I checked, we have to export and import the SQL file and our database size is large and cannot afford longer downtime.

Do any have solution to achieve this?.

Thanks & Regards,
Sathish Kumar.V

Re: VM Instance to Google Cloud SQL Migration

From
Andreas Kretschmer
Date:

Am 15.11.2018 um 08:54 schrieb Sathish Kumar:
> We would like to migrate our Postgresql VM instance on Google Cloud 
> Platform to Google Cloud SQL with a minimal downtime. As I checked, we 
> have to export and import the SQL file and our database size is large 
> and cannot afford longer downtime.
>
> Do any have solution to achieve this?.

setup a replication from one to the other?


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



Re: VM Instance to Google Cloud SQL Migration

From
Ian Lawrence Barwick
Date:
2018年11月15日(木) 17:19 Andreas Kretschmer <andreas@a-kretschmer.de>:
>
> Am 15.11.2018 um 08:54 schrieb Sathish Kumar:
> > We would like to migrate our Postgresql VM instance on Google Cloud
> > Platform to Google Cloud SQL with a minimal downtime. As I checked, we
> > have to export and import the SQL file and our database size is large
> > and cannot afford longer downtime.
> >
> > Do any have solution to achieve this?.
>
> setup a replication from one to the other?

Doesn't seem possible at the moment; here:
https://cloud.google.com/sql/docs/postgres/replication/
it says: "Cloud SQL for PostgreSQL does not yet support replication
from an external
master or external replicas for Cloud SQL instances."

Looking at the feature list:

  https://cloud.google.com/sql/docs/postgres/features

among the "Unsupported features" are: "Any features that require
SUPERUSER privileges"
(apart from a limited number of extensions), which pretty much rules
out pglogical or similar solutions.


Regards

Ian Barwick

--
 2ndQuadrant - The PostgreSQL Support Company.
 www.2ndQuadrant.com


Re: VM Instance to Google Cloud SQL Migration

From
Christopher Browne
Date:
On Thu, 15 Nov 2018 at 07:06, Ian Lawrence Barwick <barwick@gmail.com> wrote:
>
> 2018年11月15日(木) 17:19 Andreas Kretschmer <andreas@a-kretschmer.de>:
> >
> > Am 15.11.2018 um 08:54 schrieb Sathish Kumar:
> > > We would like to migrate our Postgresql VM instance on Google Cloud
> > > Platform to Google Cloud SQL with a minimal downtime. As I checked, we
> > > have to export and import the SQL file and our database size is large
> > > and cannot afford longer downtime.
> > >
> > > Do any have solution to achieve this?.
> >
> > setup a replication from one to the other?
>
> Doesn't seem possible at the moment; here:
> https://cloud.google.com/sql/docs/postgres/replication/
> it says: "Cloud SQL for PostgreSQL does not yet support replication
> from an external
> master or external replicas for Cloud SQL instances."
>
> Looking at the feature list:
>
>   https://cloud.google.com/sql/docs/postgres/features
>
> among the "Unsupported features" are: "Any features that require
> SUPERUSER privileges"
> (apart from a limited number of extensions), which pretty much rules
> out pglogical or similar solutions.

That usually also rules out Slony-I, although there's a possibility...

Slony-I includes a feature called log shipping, which could perhaps be used
for this, assuming that the "source" environment does allow superuser
privileges.  (And I think you're running on a PostgreSQL instance where
that's possible...)

See: http://slony.info/documentation/logshipping.html

--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"