Hello -

I am running PostgreSQL 9.1 on an Oracle VirtualBox 4.2.
Host/Guest: Ubuntu 13.04 / 64

>From HOST port 15432 is forwarded to port GUEST port 5432 to connect into 
PG on the GUEST.

I have PG running on HOST as well on default port 5432.

So while this connection works on HOST from HOST:
engine = create_engine('postgresql://USER:PASSWORD@localhost:5432/DATABASE')

This connection does not works on GUEST from HOST:
engine = 
create_engine('postgresql://USER:PASSWORD@localhost:15432/DATABASE')

Pls note ONLY port number has changed from 5432 to 15432.

...
Netstat shows the port 15432 is active as well as 10022 which is used to 
pass SSH from HOST to GUEST:22.

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State   
    PID/Program name
tcp        0      0 *:10022                 *:*                     LISTEN 
     17676/VirtualBox
tcp        0      0 *:15432                 *:*                     LISTEN 
     17676/VirtualBox
tcp        0      0 *:rsync                 *:*                     LISTEN 
     1124/xinetd     

Please let me know if I am missing something very obvious.

Also - what is the best way to not have the password as part of Python 
file? Send the password as a password input?
Just wondering if sqlalchemy has something built in already - else can use 
the Python getpass.

Thanks for your help.



-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to