Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CC6A92E0059 for ; Fri, 29 Feb 2008 02:08:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 57414-03 for ; Fri, 29 Feb 2008 02:08:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from visolve.com (adsl-76-212-18-41.dsl.pltn13.sbcglobal.net [76.212.18.41]) by postgresql.org (Postfix) with ESMTP id A0FB12E0040 for ; Fri, 29 Feb 2008 02:08:26 -0400 (AST) Received: (qmail 23617 invoked from network); 29 Feb 2008 06:08:20 -0000 Received: from adsl-76-212-18-41.dsl.pltn13.sbcglobal.net (HELO devco) (devi@[76.212.18.41]) (envelope-sender ) by visolve.com (qmail-ldap-1.03) with SMTP for ; 29 Feb 2008 06:08:20 -0000 Received: from 203.193.157.12 ([203.193.157.12] helo=devco) by ViMailFilter; 28 Feb 2008 22:07:47 -0800 Message-ID: <005401c87a99$7dd64b00$3f0110ac@devco> From: "Devi" To: "Phillip Smith" , "'pgsql-admin'" References: <008d01c87a8e$46d15dd0$9b0014ac@wbaus090> Subject: Re: version:8.2.6 pg_hda.conf problem Date: Fri, 29 Feb 2008 11:37:50 +0530 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-ViMailFilter-Spam-Prob: 0.00000 X-ViMailFilter-Envelope-From: devi@visolve.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.747 tagged_above=0 required=5 tests=AWL=1.646, RDNS_DYNAMIC=0.1, STOX_REPLY_TYPE=0.001 X-Spam-Level: * X-Archive-Number: 200802/407 X-Sequence-Number: 28481 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= 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" To: "'pgsql-admin'" 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 > >