Re: [ADMIN] Embedded App and User Authentication

2006-08-31 Thread Jeffrey J. Early
on 8/31/06 12:53 PM, Tom Lane at [EMAIL PROTECTED] wrote: > "Jeffrey J. Early" <[EMAIL PROTECTED]> 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 pos

Re: [ADMIN] Embedded App and User Authentication

2006-08-31 Thread Tom Lane
"Jeffrey J. Early" <[EMAIL PROTECTED]> 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

Re: [ADMIN] Embedded App and User Authentication

2006-08-31 Thread Jeffrey J. Early
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

Re: [ADMIN] Embedded App and User Authentication

2006-08-31 Thread John DeSoi
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.

Re: [ADMIN] Embedded App and User Authentication

2006-08-31 Thread Jeffrey J. Early
on 8/31/06 7:26 AM, Tom Lane at [EMAIL PROTECTED] wrote: > "Jeffrey J. Early" <[EMAIL PROTECTED]> writes: >> 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 appl

Re: [ADMIN] Embedded App and User Authentication

2006-08-31 Thread Tom Lane
"Jeffrey J. Early" <[EMAIL PROTECTED]> writes: > 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 creat

[ADMIN] Embedded App and User Authentication

2006-08-30 Thread Jeffrey J. Early
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 ca