Re: OS X Install - Mailing list pgsql-general

I recently installed PostGreSQL-7.4.5 on my OSX 10.3.5 system.  I did
not, however

have the problem you're encountering.  There was no "postgres" user
already

created on my system.


1.  It's not like postgres just rolls off the tongue.  It's hard to
imagine another user of

your system choosing that name for some reason ;)


2.  If the postgres user was created by/during your install, then
there should be some

recourse for setting its password.  I don't remember offhand, but I
think NetInfo uses

a klein star "*" to denote that the password is NOT set -- then
allowing you to set it

(hopefully ...)


3.  If your is a single user system, I'd say that MAYBE you could
remove the postgres

user and create it fresh to complete the install.


4.  I'm still very new to PostGreSQL, but I'd hazard to guess that
there's nothing so

explicitly intrinsic to the username "postgres" that you couldn't
create a new user,

"postgresfoo" and continue with the install instructions using that
username.


G'luck!

Scott




On Oct 15, 2004, at 5:09 PM, Nathan Mealey wrote:


<excerpt><color><param>05C9,05C9,05C9</param>I am trying to install
PostgreSQL on OS X 10.3, using the package from Entropy.ch.  The
installation instructions there, as well as anywhere else I have seen
them on the net, say to create a user (using the System Preferences
pane) with a shortname "postgres".  The problem is, this user already
exists in my netinfo database/domain, and so I cannot either create a
new user with the same short name, or use this user, because I do not
know the password (I assume it is a system default user).  Thus, I am
unable to complete the installation, because I cannot run the
following commands as user postgres.


<fontfamily><param>Courier</param>/usr/local/bin/initdb -D
/usr/local/pgsql/data</fontfamily><fontfamily><param>Georgia</param><x-tad-bigger>


</x-tad-bigger></fontfamily><fontfamily><param>Courier</param>/usr/local/bin/pg_ctl
-D /usr/local/pgsql/data -l postgres.log start</fontfamily>


Has anyone else encountered this before?  I'm so confused by
this...why does this user already exist, and why can't I make use of
it for this installation?  Should I create a different user?


NM

--

Nathan Mealey

Director of Operations

Cycle-Smart, Inc.

P.O. Box 1482

Northampton, MA

01061-1482

nathan@cycle-smart.com

(413) 587-3133

(413) 210-7984 Mobile

(512) 681-7043 Fax

</color></excerpt>

I recently installed PostGreSQL-7.4.5 on my OSX 10.3.5 system.  I did
not, however
have the problem you're encountering.  There was no "postgres" user
already
created on my system.

1.  It's not like postgres just rolls off the tongue.  It's hard to
imagine another user of
your system choosing that name for some reason ;)

2.  If the postgres user was created by/during your install, then there
should be some
recourse for setting its password.  I don't remember offhand, but I
think NetInfo uses
a klein star "*" to denote that the password is NOT set -- then
allowing you to set it
(hopefully ...)

3.  If your is a single user system, I'd say that MAYBE you could
remove the postgres
user and create it fresh to complete the install.

4.  I'm still very new to PostGreSQL, but I'd hazard to guess that
there's nothing so
explicitly intrinsic to the username "postgres" that you couldn't
create a new user,
"postgresfoo" and continue with the install instructions using that
username.

G'luck!
Scott



On Oct 15, 2004, at 5:09 PM, Nathan Mealey wrote:

> I am trying to install PostgreSQL on OS X 10.3, using the package from
> Entropy.ch.  The installation instructions there, as well as anywhere
> else I have seen them on the net, say to create a user (using the
> System Preferences pane) with a shortname "postgres".  The problem is,
> this user already exists in my netinfo database/domain, and so I
> cannot either create a new user with the same short name, or use this
> user, because I do not know the password (I assume it is a system
> default user).  Thus, I am unable to complete the installation,
> because I cannot run the following commands as user postgres.
>
> /usr/local/bin/initdb -D /usr/local/pgsql/data
>
> /usr/local/bin/pg_ctl -D /usr/local/pgsql/data -l postgres.log start
>
> Has anyone else encountered this before?  I'm so confused by
> this...why does this user already exist, and why can't I make use of
> it for this installation?  Should I create a different user?
>
> NM
> --
> Nathan Mealey
> Director of Operations
> Cycle-Smart, Inc.
> P.O. Box 1482
> Northampton, MA
> 01061-1482
> nathan@cycle-smart.com
> (413) 587-3133
> (413) 210-7984 Mobile
> (512) 681-7043 Fax