X-Original-To: pgsql-docs@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 83D0F474E5C for ; Tue, 11 Feb 2003 23:05:25 -0500 (EST) Received: from cfcl.com (cpe-24-221-172-174.ca.sprintbbd.net [24.221.172.174]) by postgresql.org (Postfix) with ESMTP id 8148A474E44 for ; Tue, 11 Feb 2003 23:05:24 -0500 (EST) Received: from [192.168.254.206] ([192.168.254.206]) by cfcl.com (8.12.6/8.11.1) with ESMTP id h1C46eBe074434 for ; Tue, 11 Feb 2003 20:06:41 -0800 (PST) (envelope-from vlb@cfcl.com) Mime-Version: 1.0 Message-Id: X-Mailer: Eudora for Macintosh! Date: Tue, 11 Feb 2003 20:01:24 -0800 To: pgsql-docs@postgresql.org From: Vicki Brown Subject: Suggested improvements to INSTALL file "Short Version" Content-Type: text/plain; charset="us-ascii" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/13 X-Sequence-Number: 1647 Installing PostgreSQL 7.3.2 on FreeSD 4.7, I found these discrepancies between the "Short Version" instructions in the INSTALL file and "reality". Short Version ./configure gmake 1) The "Longer Version" makes note of a "gmake check" option for testing. This SHOULD be mentioned in the short version as well! su gmake install adduser postgres 2) It should be noted here to set the shell as /bin/sh or something similar (e.g. bash) or else the postmaster command below will fail. Specifically, do not use a Csh equivalent or /sbin/nologin. mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data 3) It should be noted here that the directory /usr/local/pgsql should also be chown'd to postgresql, or the logfile created below with the postmaster command will not be able to be written. 4) I can't help but wonder why the make install didn't do the adduser, create the data directory, and set ownership correctly. The (FreeBSD ports collection version of) PostgreSQL 7.2.2 did the adduser for me... 5) Subdirs of my /usr/local/bin/pgsql directory have ownership root:wheel (due to having been created before the postgres user existed). drwxr-xr-x 2 root wheel 512 Feb 11 19:30 bin drwxr-xr-x 3 root wheel 512 Feb 11 19:30 doc drwxr-xr-x 4 root wheel 512 Feb 11 19:30 include drwxr-xr-x 2 root wheel 1024 Feb 11 19:30 lib drwxr-xr-x 4 root wheel 512 Feb 11 19:30 man drwxr-xr-x 2 root wheel 512 Feb 11 19:30 share I see nothing in the INSTALL doc to cover these permissions and do not know, therefore, if they are "correct", if it is "OK" to change the ownership to postgres, or... what? I find this disturbing. Please update the docs (and the install process) to handle the ownership of this directory. -- - Vicki Vicki Brown ZZZ Journeyman Sourceror: P.O. Box 1269 zz |\ _,,,---,,_ Scripts & Philtres San Bruno, CA zz /,`.-'`' -. ;-;;,_ Perl, Unix, MacOS 94066 USA |,4- ) )-,_. ,\ ( `'-' mailto:vlb@cfcl.com '---''(_/--' `-'\_) http://www.cfcl.com/~vlb