Search Postgresql Archives

Re: connecting to pgsql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"mmaclennan" <mmaclennan@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux