Re: Connecting to PostgreSQL on Linux with windows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Connecting to PostgreSQL on Linux with windows
Дата
Msg-id 24241.1147444300@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Connecting to PostgreSQL on Linux with windows  ("mmaclennan" <mmaclennan@gmail.com>)
Список pgsql-general
"mmaclennan" <mmaclennan@gmail.com> writes:
> Hi, I have a linux box (Fedora 3) running the latest version of
> PostgreSQL and PostGIS. I am trying connect to the database through a
> windows computer but can't seem to make the connection work. I've
> configured the pb_hba.config file in the usr directory to as "host
> all         all         192.168.1.0/24        md5" but it doesn't seem
> to work.

As already noted, providing no more detail than "doesn't seem to work"
is a good way to guarantee you won't get any useful responses.  I'll
suggest two likely possibilities though:

* you forgot to start the postmaster with the option to make it listen
for TCP connections (tcpip_socket or listen_addresses depending on PG
vintage)

* you've got the kernel firewall configured in a way that doesn't let
through any packets to port 5432.  (I believe this is default on most
RHEL/Fedora versions :-()

            regards, tom lane

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

Предыдущее
От: Markus Schiltknecht
Дата:
Сообщение: Re: rules: evaluate inputs in advance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: trigger TOASTing quicker?