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

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°

In response to

Browse pgsql-novice by date

  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