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 AE38C9FB30A for ; Thu, 31 Aug 2006 16:56:13 -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 76742-03-4 for ; Thu, 31 Aug 2006 16:56:04 -0300 (ADT) 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 CA1FF9FB3F6 for ; Thu, 31 Aug 2006 16:55:02 -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 k7VJrdZj023226; Thu, 31 Aug 2006 15:53:39 -0400 (EDT) To: jearly@alum.ups.edu cc: John DeSoi , "pgsql-admin@postgresql.org Admin" Subject: Re: Embedded App and User Authentication In-reply-to: References: Comments: In-reply-to "Jeffrey J. Early" message dated "Thu, 31 Aug 2006 11:49:08 -0700" Date: Thu, 31 Aug 2006 15:53:39 -0400 Message-ID: <23225.1157054019@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.131 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/362 X-Sequence-Number: 22905 "Jeffrey J. Early" writes: > 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 :-) The postmaster may start fine, but are you able to log in? The initial superuser account is still going to have the old username, so you might have some issues around obtaining superuser privileges. regards, tom lane