CODEWITHSUNDEEP
postgresqlgoogle-cloud-sqldblink
johan855
johan855

Reputation: 1626

dblink from remote server into a Google Cloud SQL instance using .pgpass

I'm trying to connect to a Google Cloud SQL instance using dblink, which works well when setting up my username and password in the connection string, but I would like to save my Client credentials in the SQL instance not to have the need to explicitly put my password in the connection.

Upvotes: 0

Views: 730

Answers (1)

jjanes
jjanes

Reputation: 44227

The .pgpass file which will used is the one that belongs to the OS user which is running the local database ('~/postgres/.pgpass', in most cases). And then for security reasons, it works only if you are locally a superuser. Can you meet those criteria?

but I would like to save my Client credentials in the SQL instance

What does "SQL instance" mean? I would not think that .pgpass would count as being inside the SQL instance.

An alternative solution is create a foreign server with "postgres_fdw". This doesn't seem to be documented (edit: it is documented here, but uses dblink_fdw not postgresql_fdw), but you can pass the name of a "postgres_fdw" foreign server (in single quotes) to dblink functions as the connection string. It will then pull the password to be used from the USER MAPPING for that server and user. I would think the USER MAPPING counts as inside the "SQL instance".

Upvotes: 2

Related Questions