mjmoriarity
mjmoriarity

I can’t even manage to get my tiny App Engine app to do something as basic as connect to a PostgreSQL database. This is pretty damn discouraging.

|
Embed
wilsongis
wilsongis

@mjmoriarity is your PostgreSQL instance allowing nonlocal connections? That and IP restrictions always get me.

|
Embed
mjmoriarity
mjmoriarity

@wilsongis I’m not sure. It’s a Google Cloud SQL instance in the same project as the App Engine app. Trying to connect for the socket using the Cloud SQL Proxy.

|
Embed
wilsongis
wilsongis

@mjmoriarity try connecting via pgadmin. You can also try upping the debug level on your PostgreSQL instance and see what the logs are saying.

|
Embed
mjmoriarity
mjmoriarity

@wilsongis I can connect from Cloud Shell with psql. But deploying the app fails, can’t find a socket at /cloudsql/whatever to connect to.

|
Embed
In reply to
mjmoriarity
mjmoriarity

@wilsongis I got it working but I don't really know why. Installed the local SQL proxy, connected successfully, ran my migrations, then the next deploy of the app worked.

|
Embed