Re: version:8.2.6 pg_hda.conf problem - Mailing list pgsql-admin

From Devi
Subject Re: version:8.2.6 pg_hda.conf problem
Date
Msg-id 005401c87a99$7dd64b00$3f0110ac@devco
Whole thread Raw
In response to Re: version:8.2.6 pg_hda.conf problem  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
List pgsql-admin
Hi,

I suppose the CIDR-ADDRESS mask length needs more attention.  You have
specified it as 254 and you IP says it as a single host.  Why cant you try
with 32 as the mask length.

Try replacing listen_address=* with listen_addresses=<hostname> in
postgresql.conf

FYI:
http://www.postgresql.org/docs/8.0/interactive/client-authentication.html

Try starting the server process   ./postmaster -i -D datadir path &

For instance, i have set it as
host    test       test       192.16.1.1/32        trust


Thanks,
ViSolve DB Team

----- Original Message -----
From: "Phillip Smith" <phillip.smith@weatherbeeta.com.au>
To: "'pgsql-admin'" <pgsql-admin@postgresql.org>
Sent: Friday, February 29, 2008 10:18 AM
Subject: Re: [ADMIN] version:8.2.6 pg_hda.conf problem


>> I had these in my pd_hda.conf :
>>
>> host  all  all  192.168.2.1/254 trust
>>
>> and  listen_address=*   in postgresql.conf, but it still not work .
>>
>> ps: I can not find tcpip_  ...in  postgresql.conf.
>>
>> how can i do now ?
>
> Have you started the Postmaster in 'interactive' mode? You need to pass
> the
> -i option to it.
>
> If you are using pg_ctl:
> pg_ctl -D /path/to/data/dir -o "-i" start
>
>
> THINK BEFORE YOU PRINT - Save paper if you don't really need to print this
>
> *******************Confidentiality and Privilege Notice*******************
>
> The material contained in this message is privileged and confidential to
> the addressee.  If you are not the addressee indicated in this message or
> responsible for delivery of the message to such person, you may not copy
> or deliver this message to anyone, and you should destroy it and kindly
> notify the sender by reply email.
>
> Information in this message that does not relate to the official business
> of Weatherbeeta must be treated as neither given nor endorsed by
> Weatherbeeta.
> Weatherbeeta, its employees, contractors or associates shall not be liable
> for direct, indirect or consequential loss arising from transmission of
> this
> message or any attachments
> e-mail.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.21.1/1302 - Release Date: 2/27/2008
> 4:34 PM
>
>


pgsql-admin by date:

Previous
From: "Phillip Smith"
Date:
Subject: Re: version:8.2.6 pg_hda.conf problem
Next
From: "Mehlape, Makgati"
Date:
Subject: Re: version:8.2.6 pg_hda.conf problem