tunneling postgress over SSH in Ruby

tunnel-ssh

#tunnel pg through ssh

#pg test
require 'pg'
require 'net/ssh/gateway'

gate = Net::SSH::Gateway.new(
  'BASTION_HOST_ADDR',
  'BASTION_USER',
  {port: 22, key_data: ['PRIVATE_KEY( as string)'], keys_only: true}
 )

conn_details = {
	:dbname => 'DATABASE_NAME',
	:user => 'DB_USER',
	:password => 'DB_PASS',
	:host => '127.0.0.1',  #localhost on bastion
	:port => gate.open('DB_HOST', 5439) #accessible from bastion host
}

conn =  PG.connect(conn_details)

puts conn.exec('SELECT * FROM public.test').values.to_s;