Re: PostgreSQL and Kubernetes

Il 03/04/2017 18:10, Joe Conway ha scritto:
> On 03/31/2017 01:58 AM, Moreno Andreo wrote:
>> Il 30/03/2017 14:38, Vick Khera ha scritto:
>>> On Thu, Mar 30, 2017 at 6:10 AM, Moreno Andreo
>>> <moreno(dot)andreo(at)evolu-s(dot)it <mailto:moreno(dot)andreo(at)evolu-s(dot)it>> wrote:
>>>
>>> Since I'm on Google Cloud Platform, I thought it would be a good
>>> idea to see what it offers.
>>>
>>>
>>> They currently have in beta a Postgres flavor of their cloudsql. I
>>> haven't used it yet, but I plan to test it sometime in the next couple
>>> of months.
>> I'm aware of this (and I'm about to test it too), but while this is in
>> beta I need a solution to keep up with my architecture... I can't stay
>> with a single server and no backup (except a snapshot of the disk made
>> on a daily basis... but that's no real backup) waiting for Cloud SQL to
>> get out of beta...
> Take a look at:
> https://github.com/CrunchyData/crunchy-containers
This is another good post... but I decided to keep the current
architecture, adding a standby server managed by repmgr and load
balanced by PgPool II, with barman taking care of the backup. I don't
think spending more than a week studying the docs and preparing the
whole thing in test lab.

If I'm about to migrate to Cloud SQL I think it's not worth the effort
to create a new structure and migrate in there, just for some time...
and then migrate again to CloudSQL.

Thanks again
Moreno.-

>
> HTH,
>
> Joe
>