Skip site navigation (1) Skip section navigation (2)

Re: Embedded App and User Authentication

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jearly(at)alum(dot)ups(dot)edu
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Embedded App and User Authentication
Date: 2006-08-31 14:26:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
"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

In response to


pgsql-admin by date

Next:From: Josef J. MickaDate: 2006-08-31 15:05:01
Subject: problem with initlocation
Previous:From: Aaron BonoDate: 2006-08-31 14:22:41
Subject: Re: Help about types please

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group