X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8AFF09FB364 for ; Wed, 30 Aug 2006 20:57:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 89888-02 for ; Wed, 30 Aug 2006 20:57:03 -0300 (ADT) X-Greylist: delayed 01:00:11.64552 by SQLgrey- Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by postgresql.org (Postfix) with ESMTP id 1B4969FB361 for ; Wed, 30 Aug 2006 20:57:03 -0300 (ADT) Received: from [10.0.1.5] ([67.168.251.109]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0J4U00IWD2E82FVA@vms048.mailsrvcs.net> for pgsql-admin@postgresql.org; Wed, 30 Aug 2006 17:56:33 -0500 (CDT) Date: Wed, 30 Aug 2006 15:56:32 -0700 From: "Jeffrey J. Early" Subject: Embedded App and User Authentication To: Reply-to: jearly@alum.ups.edu Message-id: MIME-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7bit Thread-topic: Embedded App and User Authentication Thread-index: AcbMh4kix8Mosjh6EdujOAANk1iQ3g== User-Agent: Microsoft-Entourage/11.2.5.060620 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/340 X-Sequence-Number: 22883 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" . Does anybody know of a way around this? I can't seem to find a way to turn this type of authentication off. I also looked into creating a 'ROLE' that would give anybody access, but can't see how to do that. Thanks for your help, Jeffrey