On 04.01.2011, at 17:51, Bill P. wrote:
> 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.conffile.
>
> 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/writethose two files.
> Then through a text editor, it seemed to work (as well as doing it again through pgAdmin) and then when saved, PG
wouldnot start back up.
You could check the most recent log file in /Library/PostgreSQL/9.0/data/pg_log – it will tell you why the server
restartfailed.
> So what is the correct process to edit these files and allow pg to be connected to by remote host.
AFAIK, Parallels creates some virtual network adapter, so the virtualized Windows environment would have to go through
thisadapter to the "physical" localhost (127.0.0.1). I have not tried to do this before, so I cannot help you here.
Kind regards,
Jan