December 16th, 2012, 12:42 PM
How to change unix_socket_directory
I am trying to change the unix socket directory to other than /tmp and it does not work, what I have done is to change it in postgresql.conf file
- unix_socket_directory = '/usr/local/pgsql/data/tmp'
I also added the following in the init script
- export unix_socket_directory=/usr/local/pgsql/data/tmp
But it continues to use the /tmp directory.
I am running PostreSQL-9.2 on Redhat 6 (64bit).
Please let me know how I can do that.