[GENERAL] Default directory for postgres user?
What should the default directory for the postgres user be? I'm using OSX 10.4. Right now, the default directory is set to /dev/null. ---(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
Re: [GENERAL] Default directory for postgres user?
The shell is probably /bin/false right? That indicates that the postgres user won't log in to an active session. If that's an issue, then you should change that to whatever you like (probably /usr/local/pgsql/). On Jul 2, 2006, at 12:29 PM, Victor Escobar wrote: What should the default directory for the postgres user be? I'm using OSX 10.4. Right now, the default directory is set to /dev/null. ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ AgentM [EMAIL PROTECTED] ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Default directory for postgres user?
On 2 jul 2006, at 18.29, Victor Escobar wrote: What should the default directory for the postgres user be? I'm using OSX 10.4. Right now, the default directory is set to /dev/null. I've set the home directory to /var/empty and the shell to /usr/bin/ false, like most of the other daemon users. /dev/null should be ok though. Sincerely, Niklas Johansson Phone: +46-322-108 18 Mobile: +46-708-55 86 90 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org