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
