Ask a Question related to Coldfusion Database Access, Design and Development.
-
cynthiav #1
PostGres ports used?
Hello
We have a PostGres database and are trying to figure out the datasource
connection to CFMX 7. I have used the technote found here:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=view&id=KC.tn_18[/url]
338&extid=tn_18338&dialogID=23385242&iterationID=1 &sessionID=4830d1e89f196a2b767
7&stateID=0+0+23387956&mode=simple
The datasource connects perfectly. The question our UNIX admin has is what
ports / firewall requirements are required to be open on the PostGres server
end? As of right now, we have had to open all ports on the PostGres server to
our CF server to allow the connection to happen. The PostGres server has a SW
firewall and is normally closed to everything but what is absolutely necessary.
We've played around with the different ports listed on MM's site for firewalls,
but it doesn't appear to be enough.
Thanks in advance.
cynthiav Guest
-
php + postgres
I've got this connection script for my database: <?php $password = md5("xxxxx"); $user = "user"; $host = "localhost"; $database = "base"; $link... -
postgres
I'm trying to access a PostgreSQL database on my machine, however, I get the following error: irb(main):003:0> conn = PGconn.connect("localhost",... -
[OT] postgres
> I can connect through DBI, but not using the postgres module. Very Hm. Does your postgres startup command have a "-i" in it somewhere? Tom -
[OT] postgres
> It doesn't appear to. ps aux | grep postgresql doesn't show anything You might try adding a "-i" to the "postmaster start" command. That'll... -
TCP/IP ports in use
Is there any command to list the TCP/IP ports are alreday in use? Thanks -
Kronin555 #2 Re: PostGres ports used?
The port Postgres listens on by default is 5432, unless that was changed.
It is also specified in the $PGDATA/postgresql.conf file.
Kronin555 Guest
-
cynthiav #3 Re: PostGres ports used?
Yes - we have opened port 5432 on the postgres end. Yet, some other ports or port range need to be opened and we are unable to identify.
cynthiav Guest
-
Kronin555 #4 Re: PostGres ports used?
A quick google search turned up this:
[url]http://archives.postgresql.org/pgsql-general/2003-01/msg01395.php[/url]
Are you using Ident authentication? Turn on verbose connection logging in
Postgres. Is the initial request making it through the firewall?
You could do some network monitoring on both boxes to see what traffic is
being sent back and forth.
Opening 5432 for TCP has always worked for me.
Kronin555 Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
