[udig-devel] postgis link to a unix soket rather than a port?

Andrea Aime aaime at openplans.org
Fri Apr 6 02:48:58 PDT 2007


Adrian Custer ha scritto:
> hey all,
> 
> exploring the connection of uDig <-> R via postgis. I've learned to make
> a local database server tied to a socket:
> 
> pg_ctl -w -l $LOCAL_DB/log/server.log start -o "-c listen_addresses= -c
> unix_socket_directory=$LOCAL_DB"
> 
> but how do I tie up uDig to that? All I see in uDig is the address:port
> combination. 

I don't have an answer for you, but maybe a research lead.
The postgis data store does not have the options now, but we could add 
them provided that the jdbc driver can connect to a unix socket, so 
that's what you need to check.

Other than that, couldn't you use a standard TCP port instead? Mere 
mortals can usually open high numbered ports, I just don't remember
where the limit between root and user is, but for sure you can open a 
tcp port like 65000 something.

Cheers
Andrea


More information about the udig-devel mailing list