Since for a private instance the connection would happen over TCP within the VPC, the authentication details would only be the username and password of the database. You would connect directly to the host’s IP and port. Here is a snippet of the code to establish a private connection from a Nodejs App Engine app:
const createTcpPool = async config => {
const dbConfig = {
client: 'pg',
connection: {
host: process.env.INSTANCE_HOST, // e.g. '127.0.0.1'
port: process.env.DB_PORT, // e.g. '5432'
user: process.env.DB_USER, // e.g. 'my-user'
password: process.env.DB_PASS, // e.g. 'my-user-password'
database: process.env.DB_NAME, // e.g. 'my-database'
},
// ... Specify additional properties here.
...config,
};
// Establish a connection to the database.
return Knex(dbConfig);
};
The complete code can be found in this guide.
LinkedIn
Twitter
