Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import psycopg2
- from sshtunnel import SSHTunnelForwarder
- try:
- with SSHTunnelForwarder(
- ('<server ip address>', 22),
- #ssh_private_key="</path/to/private/ssh/key>",
- ### in my case, I used a password instead of a private key
- ssh_username="<server username>",
- ssh_password="<mypasswd>,
- remote_bind_address=('localhost', 5432)) as server:
- server.start()
- print "server connected"
- params = {
- 'database': '<dbname>',
- 'user': '<dbusername>',
- 'password': '<dbuserpass>',
- 'host': 'localhost',
- 'port': local_bind_port
- }
- conn = psycopg2.connect(**params)
- curs = conn.cursor()
- print "database connected"
- except:
- print "Connection Failed"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement