X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B06B4DB55A for ; Mon, 31 Oct 2005 14:02:39 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32613-05 for ; Mon, 31 Oct 2005 18:02:36 +0000 (GMT) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.205]) by svr1.postgresql.org (Postfix) with ESMTP id B4ADEDB577 for ; Mon, 31 Oct 2005 14:02:34 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so904140wxc for ; Mon, 31 Oct 2005 10:02:34 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=V6a3vMLNLKHi4UBxTDaozo84t/ELwdId5H/efYWRUKhdSZrev60ibBOy9rpQ7coi0qGbC/JCAXc/dquh03CKOYxMqXs4NqndjxKazvXJOK9TjrvZ90SGAEIgHj+VAiKobozC2rfDL1kM+/3pCXAf3fA2h2Z6OCZJzk1j+XlJCbE= Received: by 10.65.95.5 with SMTP id x5mr388048qbl; Mon, 31 Oct 2005 10:02:34 -0800 (PST) Received: by 10.65.137.18 with HTTP; Mon, 31 Oct 2005 10:02:34 -0800 (PST) Message-ID: <3829471d0510311002u6c3a950axb744c95f97a11fc5@mail.gmail.com> Date: Tue, 1 Nov 2005 02:02:34 +0800 From: Ng Pheng Siong To: pgsql-admin@postgresql.org Subject: filesystem permissions and security MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9566_19583165.1130781754144" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.278 required=5 tests=[HTML_10_20=0.945, HTML_MESSAGE=0.001, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 2.278 X-Spam-Level: ** X-Archive-Number: 200511/31 X-Sequence-Number: 19404 ------=_Part_9566_19583165.1130781754144 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, According to the manual from 7.3 onwards, PostgreSQL should be installed thusly: $ ./configure $ gmake $ su # gmake install # adduser postgres # mkdir /usr/local/pgsql/data # chown postgres /usr/local/pgsql/data # su - postgres $ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data I found a number of web pages which suggest the following: # chown -R postgres /usr/local/pgsql Which is obviously less secure. Dunno how those people got the idea; perhap= s from older versions' documentation? Anyways, I'm trying to find out when the "new thinking" re filesystem permissions came in being, and mailing list discussions on same, if any. At my day job, I just came across Oracle installations which are "chown -R oracle /usr/local/oracle". I'm told the vendor says to do it this way. Veni= , vidi, I couldn't believe my eyes and all that. :-) In essence, I'm looking for "ammunition" to support my case to bring Oracle's filesystem permissions to the higher standard set by modern PostreSQL's. TIA. Cheers. ------=_Part_9566_19583165.1130781754144 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi,

According to the manual from 7.3 onwards, PostgreSQL should be installed th= usly:

  $ ./configure
  $ gmake
  $ su
  # gmake install
  # adduser postgres
  # mkdir /usr/local/pgsql/data
  # chown postgres /usr/local/pgsql/data
  # su - postgres
  $ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
  <etc.>

I found a number of web pages which suggest the following:

  # chown -R postgres /usr/local/pgsql

Which is obviously less secure. Dunno how those people got the idea; perhap= s from older versions' documentation?

Anyways, I'm trying to find out when the "new thinking" re filesy= stem permissions came in being, and mailing list discussions on same, if any.
At my day job, I just came across Oracle installations which are "chow= n -R oracle /usr/local/oracle". I'm told the vendor says to do it this way. Veni, vidi, I couldn't believe my eyes and all that. :-)

In essence, I'm looking for "ammunition" to support my case to br= ing Oracle's filesystem permissions to the higher standard set by modern PostreSQL's.

TIA. Cheers.



------=_Part_9566_19583165.1130781754144--