From: | "Bill P(dot)" <maxarbos(at)yahoo(dot)com> |
---|---|
To: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: OSX: Allow connection from remote host (actually from windows running in parallels) |
Date: | 2011-01-04 19:30:17 |
Message-ID: | 182955.64525.qm@web65820.mail.ac4.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
of PG.
________________________________
From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-novice(at)postgresql(dot)org
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
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.
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".
Andreas
--
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°
From | Date | Subject | |
---|---|---|---|
Next Message | Jasmin Dizdarevic | 2011-01-05 01:16:54 | decimal seperator |
Previous Message | Jan Eden | 2011-01-04 17:59:24 | Re: When to use postgreSQL |