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

Поиск
Список
Период
Сортировка
От Bill P.
Тема Re: OSX: Allow connection from remote host (actually from windows running in parallels)
Дата
Msg-id 182955.64525.qm@web65820.mail.ac4.yahoo.com
обсуждение исходный текст
Ответ на Re: OSX: Allow connection from remote host (actually from windows running in parallels)  (Andreas Kretschmer <akretschmer@spamfence.net>)
Список 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@spamfence.net>
To: pgsql-novice@postgresql.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@yahoo.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°

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

В списке pgsql-novice по дате отправления:

Предыдущее
От: Jan Eden
Дата:
Сообщение: Re: When to use postgreSQL
Следующее
От: Jasmin Dizdarevic
Дата:
Сообщение: decimal seperator