Thread

1. Changing path to /tmp/.s.PGSQL.5432 file and the .lock file

   Arcady Genkin <a.genkin@utoronto.ca> — 2001-05-29T17:29:29Z

   Is it possible to have postgres create the Unix socket in a directory
   other than /tmp?  I'm having a problem with my /tmp cleaner cron job
   on Solaris 8.
   
   Also, what does the file .s.PGSQL.5432.lock mean?
   
   Many thanks,
   -- 
   Arcady Genkin
   
   

2. Re: Changing path to /tmp/.s.PGSQL.5432 file and the .lock file

   Martin Jacobs <100.179370@germanynet.de> — 2001-06-16T20:33:50Z

   On 29 May 2001, Arcady Genkin wrote:
   
   > Is it possible to have postgres create the Unix socket in a directory
   > other than /tmp?  I'm having a problem with my /tmp cleaner cron job
   > on Solaris 8.
   
   Hi Arcady,
   
   AFAIK, in PG 7.1 this can be changed. But I had a similar
   problem under SuSE Linux. To solve it I added a cron job which
   did a touch on this entry. My SuSE installation (based on 5.3)
   uses a special shell file for daily cron jobs. This is
   splitted in a SuSE specific and a local variant. In the latter
   (/root/bin/cron.daily.local) I added
   
   #
   # Prevent cron.daily from deleting postmasters socket files:
   #
   if [ "$START_POSTGRES" = yes ] ; then
      for TMP_DIR in $TMP_DIRS_TO_CLEAR ; do
          find $TMP_DIR/. -type s -name .\*PGSQL.\* -exec /usr/bin/touch {} \;
      done
   fi
   
   and everything is fine now.
   
   > ...
   
   Regards
   
   Martin
   
   -- 
   Dipl-Ing. Martin Jacobs * Windsbach * Germany
   Registered Linux User #87175, http://counter.li.org/