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 4BD559FB2A3 for ; Thu, 31 Aug 2006 15:49:55 -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 64465-03-5 for ; Thu, 31 Aug 2006 15:49:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vms042pub.verizon.net (vms042pub.verizon.net [206.46.252.42]) by postgresql.org (Postfix) with ESMTP id 7B8569FB31B for ; Thu, 31 Aug 2006 15:49:16 -0300 (ADT) Received: from [10.0.1.5] ([67.168.251.109]) by vms042.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0J4V00BTPLM26NW1@vms042.mailsrvcs.net> for pgsql-admin@postgresql.org; Thu, 31 Aug 2006 13:49:15 -0500 (CDT) Date: Thu, 31 Aug 2006 11:49:08 -0700 From: "Jeffrey J. Early" Subject: Re: Embedded App and User Authentication In-reply-to: <369026C0-086C-48A8-8896-7A8064F8888D@pgedit.com> To: John DeSoi Cc: "pgsql-admin@postgresql.org Admin" 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: [ADMIN] Embedded App and User Authentication Thread-index: AcbNLiPVYpg05DkhEdul/gANk1iQ3g== 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/360 X-Sequence-Number: 22903 John, Hey thanks! I figured out the answer while responding to your suggestion. I had started to write: Yes, I gave that a shot too, but it didn't work. The problem isn't connecting to the database, but just launching postmaster (with pg_ctl) pointing to that database cluster. Launching fails if the "user launching postmaster" != "the user specified in initdb". It turns out the problem is with launching postmaster via pg_ctl -- in fact, pg_ctl seems to do this user authentication test, but postmaster doesn't. So I found that if I launch postmaster directly, no problem. Nice security :-) Thanks for your suggestions, Jeffrey PS - I still have to do a full blown test where I actually move it to a different machine, but initial tests look solid. on 8/31/06 10:33 AM, John DeSoi at desoi@pgedit.com wrote: > I'm assuming you are running initdb without specifying a user name > (and thus it defaults to the current user). Have you tried running > initdb (and connecting with) a single user name, e.g. postgres? > > I'm not sure if it will work, but maybe worth a shot. > > On Aug 31, 2006, at 12:38 PM, Jeffrey J. Early wrote: > >> Picking up a database cluster and moving it from system to system >> *does* >> seem to work without a hitch as long as the username is the same on >> each >> system. So it seems to me there has to be a fairly simple solution >> to make >> this work. > > > > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly