Re: Setting up PostgreSQL on Debian...
I really appreciate the time you've taken to explain these things to
me. I think I've got this figured out. I'll give it a whirl tonight
and let you know how things turn out.
On 6/14/05, Clive Menzies <firstname.lastname@example.org> wrote:
> On (14/06/05 06:47), Redefined Horizons wrote:
> > On 6/14/05, Clive Menzies <email@example.com> wrote:
> > > On (13/06/05 20:41), John Hasler wrote:
> > > > I get exactly the same error here. The user I am running pgAccess as is a
> > > > PostgreSQL user. When I run psql I can create the database and then open
> > > > it in pgAccess, but I can't create it in pgAccess.
> > > >
> > > > Looks like a but.
> > >
> > > but what? ;)
> > >
> > > It's not a bug. If you've created a user and you want that user to be
> > > able to create databases or users, you need to grant those privileges,
> > > initially, as user postgres:
> > >
> > > CREATE (ALTER) USER <username> PASSWORD <passwd> CREATEDB CREATEUSER;
> > >
> > How do you sign into pgAccess as the user with the creation
> > privileges? I didn't see a place to log on directly in pgAccess.
> That user needs to be created (by user 'postgres') with creation
> > Does it use the permissions of whatever current user is logged into
> > Debian?
> Yes. You're running pgaccess as the Debian user logged in which means that
> user needs the requisite permissions to create databases and other users
> (unless you want to restrict that to user postgres).
> > If I have a user created for Debian, do I simply log in as postgres
> > and grant that user the create privileges?
> Yes. Login to the server as postgres create your Debian user with
> create privileges and thereafter you don't need to login as postgres.
> > Are the "Debian System" users and the PostgreSQL users the same? (For
> > example, If I create a new Linux user JoeBlow, is he already a
> > PostgreSQL user by default? Or would I have to create a "Postgresql"
> > user called JoeBlow also?)
> No. Not unless you specifically create PostgreSQL user profiles for
> every system user.
> www.clivemenzies.co.uk ...
> ...strategies for business
> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact firstname.lastname@example.org