Re: connecting to pgsql - Mailing list pgsql-general

From Douglas McNaught
Subject Re: connecting to pgsql
Date
Msg-id 87slqgv1jg.fsf@suzuka.mcnaught.org
Whole thread Raw
In response to Re: connecting to pgsql  ("mmaclennan" <mmaclennan@gmail.com>)
Responses Re: connecting to pgsql  (Douglas McNaught <doug@mcnaught.org>)
List pgsql-general
"mmaclennan" <mmaclennan@gmail.com> writes:

> Hi yeah I was doing some reading today and realized that I had to
> change the pg_hba.conf file from local host to something else but I
> don't wuite understand what I am suppose to be entering for the
> CIDR-Address setting. This database will only be accessed from the
> network and surrounding computers. The general Ip addresses for the
> computers here are 192.168.1.X. Does this mean that the CIDR-Address
> should be 192.168.1.0/24? This is what I did but it still wouldn't
> connect.

Did you send a SIGHUP to the postmaster after editing the file?

> I also noticed that I needed to change the listening_addresses under
> the connection setting in the postgresql.config file. DO I have to do
> this? I didn't find the information really clear and there weren't any
> examples for me to understand what they mean by 'listen_address' (do
> they mean the IP address or the port number???). I tried all '*' but
> that didn't work either.

'listen_address' should be an IP address.  What is it currently set
to?

-Doug

pgsql-general by date:

Previous
From: "Peter Account"
Date:
Subject: Installing on NT4 machine
Next
From: Douglas McNaught
Date:
Subject: Re: connecting to pgsql