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
regards roilan
______________________________________________
?Con Mascota por primera vez? S? un mejor Amigo. Entra en Yahoo! Respuestas
http://es.answers.yahoo.com/info/welcome
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.centos.org/pipermail/centos/attachments/20080215/750c1fe3/attachment.html>
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 helpmeYou need to have the allowable networks specified in the postgresql pg_hba.conf file. Bill -- INTERNET: 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
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 helpmeYou need to have the allowable networks specified in the postgresql pg_hba.conf file. Bill -- INTERNET: 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 http://lists.centos.org/mailman/listinfo/centos ______________________________________________ ?Con Mascota por primera vez? S? un mejor Amigo. Entra en Yahoo! Respuestas http://es.answers.yahoo.com/info/welcome -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20080215/c0e0da4d/attachment.html>
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/centosYou 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
On Fri, Feb 15, 2008, Roilan Cardoso S?nchez wrote:> > I add in pg_hba.conf > host all all 192.168.0.0/24 ident sameuserI'm not using the CIDR notation, but have network netmask for our internal LAN 192.168.253.0/24: host all all 192.168.253.0 255.255.255.0 md5 I suspect one has to restart postgresql to have it see changes, but wouldn't bet on it. Bill -- INTERNET: 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 There are three kinds of men. The ones that learn by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves. -- Will Rogers