Date: Tue, 19 Dec 2006 12:46:54 -0300
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Murray Cumming <murrayc@murrayc.com>
Cc: "Jeroen T. Vermeulen" <jtv@xs4all.nl>,
	pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: Embedding postgresql in my application
Message-ID: <20061219154654.GA3036@alvh.no-ip.org>
Mail-Followup-To: Murray Cumming <murrayc@murrayc.com>,
	"Jeroen T. Vermeulen" <jtv@xs4all.nl>,
	pgsql-interfaces <pgsql-interfaces@postgresql.org>
References: <1166225144.12609.2.camel@localhost.localdomain>
	<20058.125.24.243.222.1166249768.squirrel@webmail.xs4all.nl>
	<1166542613.20613.19.camel@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1166542613.20613.19.camel@localhost.localdomain>
User-Agent: Mutt/1.5.13 (2006-08-11)

Murray Cumming wrote:

> On Sat, 2006-12-16 at 13:16 +0700, Jeroen T. Vermeulen wrote:
> > f your application
> > can run under many different user identities and each should have its
> > own
> > database user, use "ident sameuser"
> 
> I believe that ident authentication requires an additional service such
> as gidentd. Well, I think that's been my experience in the past.

Sure.

> >  and create a database user for every
> > system user when that user first runs the application:
> > 
> >   createuser -h "$DBDIR/data" \
> >     --no-superuser \
> >     --no-createrole \
> >     --no-createdb \
> >     $USERNAME 
> 
> createuser asks for a password on stdin. Do you know of any way to
> specifify an initial superuser and password for a new database cluster
> without doing it via stdin? That doesn't seem like a stable API that I
> should rely on.

Sure, initdb accepts the -U parameter to specify the user and you can
put the password in a temp file and give it to initdb with --pwfile.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support