Re: OS X Install

From: Jim Crate <jcrate(at)deepskytech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: OS X Install
Date: 2004-11-04 15:11:18
Message-ID: r02010300-1035-C9DC1BEF2E7311D9A9910003939CD378@[63.175.177.209]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm a little late to the party, but figured I could at least offer some info for
the archives.

If you don't know the user's password, and you have admin access, then it really
doesn't matter. In fact, I set any special users (pgsql, mailman, etc.) up so
that they *cannot* be logged into normally. Instead, do this:

sudo su - pgsql

and then all you need to know is your own password.

You can use niutil to create and delete users and groups. Reading the man page
and exploring a bit using the -list and -read options will be very informative.

Here is a script I use to create a user. Execute it with sudo.

niutil -create . /groups/pgsql
niutil -createprop . /groups/pgsql gid 5001

niutil -create . /users/pgsql
niutil -createprop . /users/pgsql uid 5001
niutil -createprop . /users/pgsql gid 5001
niutil -createprop . /users/pgsql passwd \*
niutil -createprop . /users/pgsql home /Users/pgsql
niutil -createprop . /users/pgsql shell /bin/tcsh

gid and uid can be set to some non-conflicting number of your choice. I believe
that numbers over 5000 do not show up in System Preferences or the login window.

--
Jim Crate
Deep Sky Technologies, Inc.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-04 15:25:10 Re: Selecting a random row
Previous Message Leo Martin Orfei 2004-11-04 15:03:12 create a text file from postgres (like Oracle UTL_FILE package)