Re: Embedded App and User Authentication

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Jeffrey J. Early" <jearly(at)alum(dot)ups(dot)edu> writes:
> I have an embedded application on MacOS X that bundles the postgresql apps
> and a database cluster with the OSX application, but am running into
> troubles when trying to launch the application under different usernames.

> In particular, if I create a database with 'initdb' under a username user1,
> I can launch postmaster pointing to that database cluster on any system I'm
> logged into with the username user1. However, as soon as I move to a system
> where I'm logged in as user2, postmaster will fail to launch with the error
> message "FATAL:  role "user2" does not exist" .

You really need to redo the initdb on each installed system anyway,
so my advice is "don't do it that way".

PG isn't designed to be used as an embedded database.  Perhaps you'd be
better off with SQLite?

			regards, tom lane