title: How to have a remote connection with postgres?
body: <p>I have a postgres database on a Linux  computer and I want to access it from two other computer, a mac and a windows,I search through stackoverflow and some tutorials around the web but all of them(of what I found) show <a href="https://bosnadev.com/2015/12/15/allow-remote-connections-postgresql-database-server/" rel="nofollow noreferrer">how to allow a remote connection to database.</a></p>
  
  <p>I done what allow a remote connection but I don't know how should I connect to my database, assume I want to connect from a python script using sqlalchemy. 
  I appreciate your help if you tell me how can I access the database using terminal and cmd in addition to the way I have access from sqlalchemy.</p>
  
  <p>I set <code>listen_addresses='*'</code> in <code>postgresql.conf</code> and add <code>host all all 0.0.0.0/0 md5</code> to the last line of <code>pg_hba.conf</code>.</p>