From: | "Jeffrey J(dot) Early" <jearly(at)alum(dot)ups(dot)edu> |
---|---|
To: | John DeSoi <desoi(at)pgedit(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Embedded App and User Authentication |
Date: | 2006-08-31 18:49:08 |
Message-ID: | C11C7D34.10F80%jearly@alum.ups.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)pgedit(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Sriram Dandapani | 2006-08-31 19:12:20 | archive logs recovery |
Previous Message | Tom Lane | 2006-08-31 18:38:24 | Re: Postgresql 8.1.4 on FreeBSD6.1 core dump when pg_dump |