# Google Cloud PostgreSQL

**URL:** <https://discuss.konghq.com/t/google-cloud-postgresql/728>\
**Category:** Questions\
**Created:** [March 26, 2018, 10:18pm UTC](https://discuss.konghq.com/t/google-cloud-postgresql/728 "2018-03-26T22:18:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![leeb](https://avatars.discourse-cdn.com/v4/letter/l/4af34b/32.png) [@leeb](https://discuss.konghq.com/u/leeb)\
**Post date:** [March 26, 2018, 10:18pm UTC](https://discuss.konghq.com/t/google-cloud-postgresql/728/1 "2018-03-26T22:18:00Z")

</div>

Hi,

Has anyone had any experience setting up Kong for HA/multi-data center using the Google Cloud PostgreSQL managed service? I was wondering if it’d work, how well it’d work and if it stacks up financially.

Thanks for your help.

leeb

---

<div class="post-metadata">

**Author:** ![JMourisca](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.konghq.com/jmourisca/32/273_2.png) [@JMourisca](https://discuss.konghq.com/u/JMourisca)\
**Post date:** [April 5, 2018, 11:22am UTC](https://discuss.konghq.com/t/google-cloud-postgresql/728/2 "2018-04-05T11:22:14Z")

</div>

Hi, I was able to set it up with GCloud Postgres, but I think I didn’t do it properly. Couldn’t make the migration scripts work using Kubernetes and the proxy container.

I works fine when it’s up and running and it’s not so expensive.

---

<div class="post-metadata">

**Author:** ![leeb](https://avatars.discourse-cdn.com/v4/letter/l/4af34b/32.png) [@leeb](https://discuss.konghq.com/u/leeb)\
**Post date:** [April 5, 2018, 8:25pm UTC](https://discuss.konghq.com/t/google-cloud-postgresql/728/3 "2018-04-05T20:25:52Z")

</div>

Hi, thanks for the info.

Quick question… how did you configure the postgres env config in the yaml? We’re struggling to work out where to point the PGDATA env param to:

e.g.

- name: PGDATA  
value: /var/lib/postgresql/data/pgdata

Thanks,

Lee

---

<div class="post-metadata">

**Author:** ![JMourisca](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.konghq.com/jmourisca/32/273_2.png) [@JMourisca](https://discuss.konghq.com/u/JMourisca)\
**Post date:** [April 6, 2018, 7:18am UTC](https://discuss.konghq.com/t/google-cloud-postgresql/728/4 "2018-04-06T07:18:24Z")

</div>

If you are using the Google Cloud Postgres, you don’t need that since the data will be managed somewhere else. You only have to use the proxy container. We did it by following these instructions [https://cloud.google.com/sql/docs/postgres/connect-kubernetes-engine](https://cloud.google.com/sql/docs/postgres/connect-kubernetes-engine)

It worked fine, except during the migration.

---

<div class="post-metadata">

**Author:** ![leeb](https://avatars.discourse-cdn.com/v4/letter/l/4af34b/32.png) [@leeb](https://discuss.konghq.com/u/leeb)\
**Post date:** [April 7, 2018, 1:20am UTC](https://discuss.konghq.com/t/google-cloud-postgresql/728/5 "2018-04-07T01:20:56Z")

</div>

Do you run this across several regions/zones? If so, did you compare it to running against cassandra? Reason for the question is that I’m trying to work out how the performance/financial scalability compares between the two. Because Gcloud Postgres is a managed platform it seems more advantageous over running my own cassandra cluster as well.

Thanks again, Lee.
