Re: [GENERAL] another can't connect--solved

2009-06-30 Thread BJ Freeman
added this to iptables ACCEPT all -- localhostlocalhost BJ Freeman sent the following on 6/28/2009 8:23 PM: > sorry about the post did not do a reply all and sent a personal replay > yes in the chain I have > ACCEPT all -- anywhere anywherestate > RE

Re: [GENERAL] another can't connect

2009-06-30 Thread BJ Freeman
Thanks for you help found that this not connect problem is server wide. not just Isolated to postgresql. so tracking down what i did to mess it up :D BJ Freeman sent the following on 6/28/2009 8:23 PM: > sorry about the post did not do a reply all and sent a personal replay > yes in the chain I h

Re: [GENERAL] another can't connect

2009-06-29 Thread Tom Lane
BJ Freeman writes: > sorry about the post did not do a reply all and sent a personal replay > yes in the chain I have > ACCEPT all -- anywhere anywherestate > RELATED,ESTABLISHED > it is the next to last rule. You sure that works? This notation for iptables isn't fa

Re: [GENERAL] another can't connect

2009-06-28 Thread BJ Freeman
sorry about the post did not do a reply all and sent a personal replay yes in the chain I have ACCEPT all -- anywhere anywherestate RELATED,ESTABLISHED it is the next to last rule. Andrej sent the following on 6/28/2009 8:14 PM: > 2009/6/29 BJ Freeman : ACCEPT

Re: [GENERAL] another can't connect

2009-06-28 Thread Andrej
2009/6/29 BJ Freeman : >>> ACCEPT tcp -- localhostlocalhost tcp >>> dpt:postgres state NEW >> >> What about established connections? > tcp0 0 127.0.0.1:5432 0.0.0.0:* >LISTEN > is the only line for that port I think Chris meant "What about i

Re: [GENERAL] another can't connect

2009-06-28 Thread Chris
Please don't top-post, it's so hard to follow discussions. Chris sent the following on 6/28/2009 7:33 PM: BJ Freeman wrote: PostgreSQL version 8.1.11 (With schemas) I have read the recent emails and believe I have covered all the bases from net stat tcp0 0 127.0.0.1:5432

Re: [GENERAL] another can't connect

2009-06-28 Thread BJ Freeman
tcp0 0 127.0.0.1:5432 0.0.0.0:* LISTEN is the only line for that port Chris sent the following on 6/28/2009 7:33 PM: > BJ Freeman wrote: >> PostgreSQL version 8.1.11 (With schemas) >> I have read the recent emails and believe I have covered all the bases >> from net s

Re: [GENERAL] another can't connect

2009-06-28 Thread Chris
BJ Freeman wrote: PostgreSQL version 8.1.11 (With schemas) I have read the recent emails and believe I have covered all the bases from net stat tcp0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 5091/postmaster I do a psql -h 127.0.0.1 -U ofbiz -d ofbiz from a terminal on

[GENERAL] another can't connect

2009-06-28 Thread BJ Freeman
PostgreSQL version 8.1.11 (With schemas) I have read the recent emails and believe I have covered all the bases from net stat tcp0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 5091/postmaster I do a psql -h 127.0.0.1 -U ofbiz -d ofbiz from a terminal on the server. and ge