On Fri, 30 Nov 2007, Madison Kelly wrote:
If there a ./configure switch (or config file/command line switch) to
tell postgresql to put the lock file '.s.PGSQL.port.lock' and socket
'.s.PGSQL.port' in a different directory?
There's no ./configure option, so you should change
DEFAULT_PGSOCKET_DIR in ./src/include/pg_config_manual.h
If every client is linked (preferably dynamically) with libpq, which
is compiled with changed DEFAULT_PGSOCKET_DIR, then this would work
with no special configuration.
Alternatively there's a command line switch -k or
unix_socket_directory config option for postgres server:
http://www.postgresql.org/docs/8.2/interactive/runtime-config-connection.html
And PGHOST environment variable for clients:
http://www.postgresql.org/docs/8.2/interactive/libpq-envars.html
Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
Winnie the Pooh
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match