From: Jeffrey J. Early <jearly@alum.ups.edu>
To: pgsql-admin@postgresql.org
Subject: Embedded App and User Authentication
Date: Wed, 30 Aug 2006 15:56:32 -0700
Message-ID: <C11B65B0.10EFA%jearly@alum.ups.edu> (raw)
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 can launch postmaster pointing to that database cluster on any system I'm
logged into with the username user1. However, as soon as I move to a system
where I'm logged in as user2, postmaster will fail to launch with the error
message "FATAL: role "user2" does not exist" .
Does anybody know of a way around this?
I can't seem to find a way to turn this type of authentication off. I also
looked into creating a 'ROLE' that would give anybody access, but can't see
how to do that.
Thanks for your help,
Jeffrey
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
Subject: Re: Embedded App and User Authentication
In-Reply-To: <C11B65B0.10EFA%jearly@alum.ups.edu>
References: <C11B65B0.10EFA%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