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@celestial.com Para: centos@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@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@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
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@celestial.com Para: centos@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@celestial.com mailto:bill@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@centos.org mailto:CentOS@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@centos.org http://lists.centos.org/mailman/listinfo/centos
You must also enable the TCPIP options in postgresql.conf
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 sameuser
I'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@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