Ability to connect to Google Cloud SQL from App Engine about postgres-kit HOT 7 CLOSED

I think it would be necessary to re-implement Google's client authentication code for Cloud SQL in Swift; here's a Java example.

Note that it is already possible to connect to Cloud SQL from Kubernetes Engine, however, through the Cloud SQL Proxy sidecar. I am successfully using that approach in production.

from postgres-kit.

After doing some additional research and looking into the ruby implementation, the socket should be something like
/cloudsql/<project-id>:<sql-locaiton-id>:<sql-instance-name>

databases.add(database:
    PostgreSQLDatabase(config:
        PostgreSQLDatabaseConfig(
            hostname: Environment.get("POSTGRES_SOCKET_PATH") ?? Environment.get("POSTGRES_HOST") ?? "localhost",
            port: Int(Environment.get("POSTGRES_PORT") ?? "5432") ?? 5432,
            username: Environment.get("POSTGRES_USER") ?? "default",
            database: Environment.get("POSTGRES_DATABASE") ?? "default_database",
            password: Environment.get("POSTGRES_PASSWORD")
            )
        ),
    as: .psql)

My env variable POSTGRES_SOCKET_PATH has the socket path in the format above. According to what I have read, that is the socket that App Engine should connect to.

With the current implementation of Postgres' driver, that socket form wouldn't work, right?

from postgres-kit.

All that was needed to connect to the Postgres database was a unix socket, which I had originally thought, but I was missing the socket file at the end of the path. The full path should look like this
/cloudsql/project-id:location-id:instance-name/.s.PGSQL.5432

from postgres-kit.

Wow, I didn’t know that. Does App Engine auto-mount a virtual file system in that location?

Anyway, glad to hear that adding Postgres support to the driver was useful.

from postgres-kit.

The virtual file system, I'm not sure of. I assume it has something mounted there for you to gain access to.

from postgres-kit.

Did you ever see a similar error when trying to use the unix socket like connect(descriptor:addr:size:) failed: No such file or directory (errno: 2)

from postgres-kit.

Did you ever see a similar error when trying to use the unix socket like connect(descriptor:addr:size:) failed: No such file or directory (errno: 2)

This is the current error I'm having, has anyone had success connecting using unix sockets?

from postgres-kit.