Re: Embedding postgresql in my application

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