PostgreSQL 8.0.3 + FreeBSD + TCP/IP (Solved)
Joseph Koenig (jWeb)
joe at jwebmedia.com
Tue Jun 14 21:32:51 GMT 2005
> On Jun 14, 2005, at 4:46 PM, Joseph Koenig (jWeb) wrote:
>>
>> I'm guessing that opening the port is part of what placing
>> "postgresql_enable=YES" in the rc.conf file does, correct? If so,
>> that's
>> probably the problem as I have not rebooted since adding that. Is
>> there a
>> way to safely force that to run without rebooting? There is a hardware
>> firewall in front of the server that I have ensured is allowing
>> that port
>> through. Thanks,
>>
>> Joe Koenig
>> Production Manager
>> jWeb New Media Design
>> joe at jWebmedia.com
>> http://www.jwebmedia.com/
>> 636.928.3162
>>
>> _______________________________________________
>> freebsd-questions at freebsd.org mailing list
>> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>> To unsubscribe, send any mail to "freebsd-questions-
>> unsubscribe at freebsd.org"
>>
>> !DSPAM:42af4251253444259514897!
>>
>>
>
> Hi Joe,
>
> You can confirm whether or not port 5432 is opened by typing "netstat
> -na | grep 5432" on your database server.
>
> You should not have to reboot for the port to be opened. When
> PostgreSQL starts, (either by starting it manually, or then the
> machine boots) it will open the port.
>
> IIt definitely sounds like the firewall could be your problem. I'd
> try connecting to the database server's port 5432 via telnet from an
> outside location, so that your packets have to pass thru the firewall
> in question.
>
> Thanks,
>
> Ken Ebling
> Ideal Internet, Inc.
> 561-963-4501
>
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"
Thanks to Ken and everyone who sent in recommendations - looks like it was
an issue of a network admin who assured me the firewall was open when it
really wasn't...
Joe Koenig
Production Manager
jWeb New Media Design
joe at jWebmedia.com
http://www.jwebmedia.com/
636.928.3162
More information about the freebsd-questions
mailing list