configure postgres not to write to /tmp dir

From: "Priya G" <sreepriya(at)hotmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: configure postgres not to write to /tmp dir
Date: 2003-04-18 20:21:53
Message-ID: BAY2-F54EbgkJqzBScK0001c115@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

<html><div style='background-color:'><DIV>Hi all,<BR>&nbsp;<BR>&nbsp;<BR>&nbsp;I need some help.We are using postgresql 7.2.1.There are some files that is being written to /tmp directory by postgres<BR>&nbsp;<BR>/tmp:<BR>srwxrwxrwx&nbsp;&nbsp;&nbsp; 1 postgres postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 Apr&nbsp; 8 17:24 .s.PGSQL.5432<BR>-rw-------&nbsp;&nbsp;&nbsp; 1 postgres postgres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29 Apr&nbsp; 8 17:24 .s.PGSQL.5432.lock</DIV>
<DIV>How can we redirect this to some other dirctory.Which variable sets this up?<BR>Is it UNIX_SOCKET_DIRECTORY ?<BR>&nbsp;<BR>Thanks</DIV></div><br clear=all><hr>Tired of spam? Get <a href="http://g.msn.com/8HMMENUS/2734">advanced junk mail protection</a> with MSN 8.</html>

Attachment Content-Type Size
unknown_filename text/html 759 bytes

Browse pgsql-odbc by date

  From Date Subject
Next Message Ben Abdallah Abdel Karim 2003-04-21 14:37:59 ODBC prob
Previous Message Wayne Armstrong 2003-04-18 14:42:16 Re: An extra null row is returned if rowset size is a multiple