django cloud sql sample for postgresql

[KushGoyal]

Please add sample for django postgresql settings.

I tried the instructions at: https://cloud.google.com/appengine/docs/flexible/python/using-cloud-sql-postgres

But they are not working. I am getting unix socket error. More details:
http://stackoverflow.com/questions/42950418/postgres-settings-for-django-on-google-app-engine-flexi

[theacodes]

/cc @waprin

[agmathew]

I am also experiencing a similar issue. See here: http://stackoverflow.com/questions/42836927/error-connecting-django-to-google-cloudsql-postgres-database-in-google-app-engin

[ryanmats]

@KushGoyal @agmathew thanks for the feedback. i'll take a look at this today.

[ryanmats]

@KushGoyal @agmathew So I was able to get it to work when deployed, and wasn't able to reproduce your error message :/

I would recommend doing the Django on App Engine Flexible tutorial (https://cloud.google.com/python/django/flexible-environment) from the beginning step-by-step with these PostgreSQL specific changes:

1. When you get to 'Create a Cloud SQL Instance' step 1, use https://cloud.google.com/sql/docs/postgres/create-instance and make sure you create a PostgreSQL instance instead of a Cloud SQL instance. When you create the instance, you'll be asked to create a password. This password is for the 'postgres' default user for this PostgreSQL instance.

2. Skip step 2 of 'Create a Cloud SQL Instance,' since you set the password when creating the instance.

3. In 'Initialize your Cloud SQL instance' step 1, use this command to use port 5432 instead of 3306: "./cloud_sql_proxy -instances="[YOUR_INSTANCE_CONNECTION_NAME]"=tcp:5432"

4. In 'Configure the Database Settings,' when you are editing mysite/settings.py, also change 'ENGINE': 'django.db.backends.mysql' to 'ENGINE':'django.db.backends.postgresql'

5. While you are configuring database settings here, also edit your requirements.txt file and add psycopg2==2.7.1

If you do this and still have difficulties, let us know along with more details about where you got stuck and what error messages you got!

[KushGoyal]

@ryanmats it worked! Although I didn't change a thing 😲
Thanks for the help

[agmathew]

@ryanmats Same for me, it's working now, but I haven't touched anything. Do you know if any changes were made to GAE or CloudSQL Postgres in the last few days? Is there somewhere where we can track changes like this? We're currently evaluating whether to use GAE for a new product and I'm a little concerned about a service "fixing" itself.

[ryanmats]

@KushGoyal @agmathew Great to hear that it works! I just filed a bug for the Cloud SQL / Postgres team to ask them about this - will let you know what they say.

@jonparrott do you know if there are any resources for customers to track product changes? (see @agmathew 's comment above)

[theacodes]

@agmathew @KushGoyal
Postgres for Cloud SQL is in beta, so it's expected that things will be changing rapidly as we approach GA, especially things around reliability. I highly recommend joining the user group so that you can provide us with feedback on the beta.

For Cloud SQL, we have release notes published here:
https://cloud.google.com/sql/docs/release-notes

For GAE flexible, we have release notes published here: https://cloud.google.com/appengine/docs/flexible/python/release-notes

[theacodes]

(Closing as this appears to be resolved, but feel free to comment if you have any more questions/issues).

[KushGoyal]

The issue is repeating again on a new project. I have followed the exact steps which are:

1. create a postgresql instance

2. create a db

3. get name of connection using command: gcloud sql instances describe <instance-name>

4. add connection name to app.yaml

beta_settings:
  cloud_sql_instances: <connection-name>

5. use host as /cloudsql/<connection-name>

[KushGoyal]

I tried to deploy the project again and this time it worked without changing anything.

I don't know what changed. Perhaps this issue is related to app engine not detecting the presence of postgresql db.

[ryanmats]

@KushGoyal we'll ping the CloudSQL engineering team about this. thanks for the feedback.

[ankushagarwal]

@KushGoyal :

1. What was the error message that you received?
2. What was the format of the SQLALCHEMY_DATABASE_URI that you used (eg: postgresql+psycopg2://username:password@/databasename?host=connection-name)
3. Did you try connecting to the instance from your local machine by using cloud-sql-proxy? (look at the Setting up your local environment instructions here : https://cloud.google.com/appengine/docs/flexible/python/using-cloud-sql-postgres)