From owner-freebsd-database@FreeBSD.ORG  Mon Dec 12 20:22:20 2005
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 750A816A41F
	for <freebsd-database@freebsd.org>;
	Mon, 12 Dec 2005 20:22:20 +0000 (GMT)
	(envelope-from mmulligan@intrusic.com)
Received: from mail.intrusic.com (mail.intrusic.com [63.251.138.101])
	by mx1.FreeBSD.org (Postfix) with ESMTP id F359143D5E
	for <freebsd-database@freebsd.org>;
	Mon, 12 Dec 2005 20:22:14 +0000 (GMT)
	(envelope-from mmulligan@intrusic.com)
Received: from cha1-mail1.intrusic.com (ipn36372-a58290.cidr.lightship.net
	[216.204.40.50]) by mail.intrusic.com (Postfix) with ESMTP
	id 19C5FF93; Mon, 12 Dec 2005 15:52:08 -0500 (EST)
Received: from [192.168.100.155] (unicron.cybertron.intrusic.com
	[192.168.100.155]) by cha1-mail1.intrusic.com (Postfix) with ESMTP
	id CA592C5630; Mon, 12 Dec 2005 15:22:49 -0500 (EST)
Message-ID: <439DDC82.6090402@intrusic.com>
Date: Mon, 12 Dec 2005 15:24:34 -0500
From: Michael Mulligan <mmulligan@intrusic.com>
Organization: Intrusic, Inc
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051020)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Theodore Campbell <theodore.campbell@comscape.net>
References: <200512121709.jBCH9F5K000099@nemo.comscape.net>
In-Reply-To: <200512121709.jBCH9F5K000099@nemo.comscape.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-database@freebsd.org
Subject: Re: postgresql_user in 010.pgsql.sh
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 12 Dec 2005 20:22:20 -0000

Theodore Campbell wrote:

>I assume you're trying to set the postgres super user to something other than
>pgsql. It's good to know that the system user and the database super user
>are not related in any way. ...
>

My post was terse, not explaining why I was asking for this.  Perhaps
I have a weak reason: it is just for convenience with some legacy
operational conventions where both the UNIX username and the
Postgresql super user were named "postgres".  My workaround has been
to make the edit locally as indicated in my first email.  I thought other
folks might find this useful.

Thanks for your reply.