pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeffrey J. Early <jearly@alum.ups.edu>
To: John DeSoi <desoi@pgedit.com>
Cc: pgsql-admin@postgresql.org Admin <pgsql-admin@postgresql.org>
Subject: Re: Embedded App and User Authentication
Date: Thu, 31 Aug 2006 11:49:08 -0700
Message-ID: <C11C7D34.10F80%jearly@alum.ups.edu> (raw)
In-Reply-To: <369026C0-086C-48A8-8896-7A8064F8888D@pgedit.com>

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





view thread (7+ messages)  latest in thread

Message-ID: <C11C7D34.10F80%jearly@alum.ups.edu>
Permalink:  ../C11C7D34.10F80%25jearly@alum.ups.edu/
Also on:    postgresql.org/message-id/C11C7D34.10F80%jearly@alum.ups.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jearly@alum.ups.edu, desoi@pgedit.com
  Subject: Re: Embedded App and User Authentication
  In-Reply-To: <C11C7D34.10F80%jearly@alum.ups.edu>
  References: <369026C0-086C-48A8-8896-7A8064F8888D@pgedit.com> <C11C7D34.10F80%jearly@alum.ups.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox