Can I connect to remote DB using psql?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mrflibble
    New Member
    • Oct 2007
    • 5

    Can I connect to remote DB using psql?

    I've got a postgres db running on a windows mc. I've set it up to accept remote connections. Can I use psql from another machine (*nix) to connect to it?

    I've tried this:
    Code:
    psql MYDB -U postgres -h 192.168.1.20
    but I get the error
    Code:
    missing or erroneous pg_hba.conf file
    which I don't understand.

    The pg_hba.conf file is a configuration file residing on the host, isn't it? Why is the client asking for it?
  • mrflibble
    New Member
    • Oct 2007
    • 5

    #2
    I've figured it out. The message was coming from the server (so successful connection made) but the server had a mis-configured conf file.

    Comment

    Working...