thr3ads.net - CentOS - [CentOS] About postgresql tcpip connection [Feb 2008]

If this information is useful, please help other people find it:
Share via:

Roilan Cardoso Sánchez

2008-Feb-15 16:33 UTC

[CentOS] About postgresql tcpip connection

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>

Bill Campbell

2008-Feb-15 17:28 UTC

head link

[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  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

Roilan Cardoso Sánchez

2008-Feb-15 17:42 UTC

head link

[CentOS] About postgresql tcpip connection

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  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>

James A. Peltier

2008-Feb-15 18:01 UTC

head link

[CentOS] About postgresql tcpip connection

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

Bill Campbell

2008-Feb-15 18:24 UTC

head link

[CentOS] About postgresql tcpip connection

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 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

Possibly Parallel Threads

Search for more possibly parallel threads

CentOS - Feb 2008 - About postgresql tcpip connection

[CentOS] About postgresql tcpip connection

[CentOS] About postgresql tcpip connection

[CentOS] About postgresql tcpip connection

[CentOS] About postgresql tcpip connection

[CentOS] About postgresql tcpip connection

Possibly Parallel Threads