X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6A3DB9DCBBF for ; Tue, 29 Nov 2005 12:37:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04136-09 for ; Tue, 29 Nov 2005 12:37:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 57C0D9DCBA9 for ; Tue, 29 Nov 2005 12:37:51 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jATGZEPL007876; Tue, 29 Nov 2005 11:35:14 -0500 (EST) To: "Dan The Man" cc: pgsql-admin@postgresql.org Subject: Re: command line options to pass to the postmaster - controlling UNIX socket permiss In-reply-to: References: Comments: In-reply-to "Dan The Man" message dated "Tue, 29 Nov 2005 10:36:01 -0500" Date: Tue, 29 Nov 2005 11:35:14 -0500 Message-ID: <7875.1133282114@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.142 required=5 tests=[AWL=-0.134, MAILTO_TO_SPAM_ADDR=0.276] X-Spam-Score: 0.142 X-Spam-Level: X-Archive-Number: 200511/326 X-Sequence-Number: 19699 "Dan The Man" writes: > I'm running postgres on a Linux server SuSE SLES. When I run postgresql > 8.0.3, I get /tmp/.s.PGSQLl.5432 socket open with group and owner > permissions. The group permissions are the default group of the postgres > account and the owner is postgres. If I want to start postgres with a > non-default group called db-admins or something is that an option? See http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-CONNECTION particularly unix_socket_group and unix_socket_permissions. regards, tom lane