OSX: Allow connection from remote host (actually from windows running in parallels)

From: "Bill P(dot)" <maxarbos(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: OSX: Allow connection from remote host (actually from windows running in parallels)
Date: 2011-01-04 16:51:45
Message-ID: 393981.8815.qm@web65803.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am trying to connect to my OSX installed version of PG from Windows XP SP3
running in Parallels on my mac.

When I try to connect, i get an error about no entry in the pg_hba.conf for the
ip i am trying to connect to.
I used pgAdmin3 to try to edit the file. postgresql.conf first to enable to the
pg_hba.conf dir and then the pg_hba.conf file.

Neither allows me to edit and save these files due to permissions.

I also tried to edit them through the terminal, that didnt work and also added
my user to the people allowed to read/write those two files.
Then through a text editor, it seemed to work (as well as doing it again through
pgAdmin) and then when saved, PG would not start back up.

So what is the correct process to edit these files and allow pg to be connected
to by remote host.

Thanks.
Bill

(tried posting this on the forums and got the same errors not allowing me to do
so)

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2011-01-04 17:32:18 Re: OSX: Allow connection from remote host (actually from windows running in parallels)
Previous Message Jean-Yves F. Barbier 2011-01-04 15:44:13 Re: When to use postgreSQL