X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D6A729FB3CF for ; Thu, 31 Aug 2006 11:28:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 36973-06-4 for ; Thu, 31 Aug 2006 14:28:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id A920A9FB3D0 for ; Thu, 31 Aug 2006 11:27:03 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k7VEQweC007245; Thu, 31 Aug 2006 10:26:58 -0400 (EDT) To: jearly@alum.ups.edu cc: pgsql-admin@postgresql.org Subject: Re: Embedded App and User Authentication In-reply-to: References: Comments: In-reply-to "Jeffrey J. Early" message dated "Wed, 30 Aug 2006 15:56:32 -0700" Date: Thu, 31 Aug 2006 10:26:58 -0400 Message-ID: <7244.1157034418@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/347 X-Sequence-Number: 22890 "Jeffrey J. Early" 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