I wonder if there could be a potential problem with using this approach - checking on $USER == root.
Although it is a common practice, I think a superuser does not have to be root. If I'm right here, a better technique could be executing `id`. Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Eisentraut Sent: Wednesday, March 01, 2006 6:49 AM To: pgsql-hackers@postgresql.org Cc: Christopher Kings-Lynne Subject: Re: [HACKERS] ipcclean in 8.1 broken? Am Dienstag, 28. Februar 2006 07:42 schrieb Christopher Kings-Lynne: > I just tried using ipcclean in 8.1.3. It doesn't work when I su to the > pgsql user. This part of the script: > > if [ "$USER" = 'root' -o "$LOGNAME" = 'root' ] > > Always fails because even tho $USER is set to 'pgsql' when su'ed, > $LOGNAME is still root. > > This is on FreeBSD 4.9 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster