[CentOS] About postgresql tcpip connection

Fri Feb 15 18:01:02 UTC 2008
James A. Peltier <jpeltier at cs.sfu.ca>

Roilan Cardoso Sánchez wrote:
> I add in pg_hba.conf
> host    all    all    192.168.0.0/24    ident sameuser
>  
> I tryed to connect and it throw the same error
> 
> ----- Mensaje original ----
> De: Bill Campbell <centos at celestial.com>
> Para: centos at centos.org
> Enviado: viernes, 15 de febrero, 2008 12:28:44
> Asunto: Re: [CentOS] About postgresql tcpip connection
> 
> On Fri, Feb 15, 2008, Roilan Cardoso S?nchez wrote:
>  >
>  >  hello everybody
>  >
>  >  i´m trying to connect to my postgresql via tcpip and it thow an error
>  >  is not accepting tcp-ip connections
>  >  I ask to google but i dont find the solution, people said about the
>  >  prostgresql.conf enable tcpip, I try but when i start the service it
>  >  thow an error.
>  >  Other thing is add the option i to postmaster.opt but when i start the
>  >  service this file is redefined
>  >
>  >  anybody can helpme
> 
> You need to have the allowable networks specified in the
> postgresql pg_hba.conf file.
> 
> Bill
> --
> INTERNET:  bill at celestial.com <mailto:bill at celestial.com>  Bill 
> Campbell; Celestial Software LLC
> URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
> FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676
> 
> Cutting the space budget really restores my faith in humanity.  It
> eliminates dreams, goals, and ideals and lets us get straight to the
> business of hate, debauchery, and self-annihilation.  -- Johnny Hart
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org <mailto:CentOS at centos.org>
> http://lists.centos.org/mailman/listinfo/centos
> 
> 
> ------------------------------------------------------------------------
> 
> ¿Con Mascota por primera vez? - Sé un mejor Amigo
> Entra en Yahoo! Respuestas 
> <http://es.rd.yahoo.com/evt:51361/*http://es.answers.yahoo.com/dir/index;_ylc=X3oDMTE4ZWhyZjU0BF9TAzIxMTQ3MTQzMjIEc2VjA0Jhbm5lcgRzbGsDQWNxdWlzaXRpb24-?link=over&sid=XXXXXXXX>.
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
You must also enable the TCPIP options in postgresql.conf

-- 
James A. Peltier
Technical Director, RHCE
SCIRF | GrUVi @ Simon Fraser University - Burnaby Campus
Phone   : 778-782-3610
Fax     : 778-782-3045
Mobile  : 778-840-6434
E-Mail  : jpeltier at sfu.ca
Website : http://gruvi.cs.sfu.ca | http://scirf.cs.sfu.ca
MSN     : subatomic_spam at hotmail.com