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.
Thank you.