pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (7+ messages)  latest in thread

Message-ID: <C11B65B0.10EFA%jearly@alum.ups.edu>
Permalink:  ../C11B65B0.10EFA%25jearly@alum.ups.edu/
Also on:    postgresql.org/message-id/C11B65B0.10EFA%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
  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