In pgAdmin 3, there are choices under the file menu to edit (open) the .pgpass,
pg_hba.conf and postgresql.conf files. That is one of the utilities I tried to
edit these files.
As far as the : "edit the file. postgresql.conf first to enable to the
pg_hba.conf dir" comment.
I was referring to the fact that the error I was getting when trying to connect
from Windows to OSX, that stated that I didn't have a record in the pg_hda.conf
file. In order for this file to be read and used, there is a path and attribute
that needs to be enabled in the 'postgresql.conf' file to use the pg_hba.conf
dir/file. I wasnt sure if there was a certain order that this all needs to be
done in or using which method to edit these files.
The pg_hba.conf file I am editing is on the 'server', the OSX installed version
From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
Sent: Tue, January 4, 2011 12:32:18 PM
Subject: Re: [NOVICE] OSX: Allow connection from remote host (actually from
windows running in parallels)
Bill P. <maxarbos(at)yahoo(dot)com> 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
> ip i am trying to connect to.
> I used pgAdmin3 to try to edit the file. postgresql.conf first to enable to
> pg_hba.conf dir and then the pg_hba.conf file.
You have to edit the pg_hba.conf file on the server. I don't know if it
is possible with pgadmin, but i doubt ...
And i don't know what you mean with "edit the file. postgresql.conf
first to enable to the pg_hba.conf dir".
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
In response to
pgsql-novice by date
|Next:||From: Jasmin Dizdarevic||Date: 2011-01-05 01:16:54|
|Subject: decimal seperator|
|Previous:||From: Jan Eden||Date: 2011-01-04 17:59:24|
|Subject: Re: When to use postgreSQL|