Skip to content

Instantly share code, notes, and snippets.

@ptesny
Forked from abtris/client.js
Created May 24, 2022 11:25
Show Gist options
  • Save ptesny/b0a54964a29d3635d788b912249a3bb3 to your computer and use it in GitHub Desktop.
Save ptesny/b0a54964a29d3635d788b912249a3bb3 to your computer and use it in GitHub Desktop.
Connect to Postgres/Redshift over Socks proxy.
var pg = require('pg'),
url = require('url'),
SocksConnection = require('socksjs');
var db = url.parse(process.env.REDSHIFT_CONN_STRING),
dbAuth = db.auth,
dbUsername = dbAuth.split(':')[0],
dbPassword = dbAuth.split(':')[1],
dbName = db.pathname.replace('/', '');
var proxy = url.parse(process.env.QUOTAGUARDSTATIC_URL),
auth = proxy.auth,
username = auth.split(':')[0],
pass = auth.split(':')[1];
var sock_options = {
host: proxy.hostname,
port: 1080,
user: username,
pass: pass
};
var remote_options = {
host: db.hostname,
port: db.port
};
var sockConn = new SocksConnection(remote_options, sock_options);
var config = {
user: dbUsername,
database: dbName,
password: dbPassword,
stream: sockConn
};
var client = new pg.Client(config);
// connect to our database
client.connect(function (err) {
if (err) throw err;
// execute a query on our database
client.query('SELECT $1::text as name', ['john doe'], function (err, result) {
if (err) throw err;
// just print the result to the console
console.log(result.rows[0]); // outputs: { name: 'apiary' }
// disconnect the client
client.end(function (err) {
if (err) throw err;
});
});
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment