Re: OS X Install - Mailing list pgsql-general

From Arcane_Rhino
Subject Re: OS X Install
Date
Msg-id 20041016005641.10262.qmail@web50401.mail.yahoo.com
Whole thread Raw
In response to OS X Install  (Nathan Mealey <nathan@cycle-smart.com>)
List pgsql-general
Nathan:
 
Yes and no.  My guess is that either postgres is now a default user included with the Pather version, you inadvertantly created the user once before (or during installation), or Marc Liyanage (bless his soul) created it for you during installation.  Of the three, I doubt it is the latter because, though not infallable, Marc usually puts out pretty good, bug free stuff.
 
As for myself, I installed PG once under 10.2, then removed it and later, under 10.3  installed it again.  I ran into this same problem.  I thought at the time it was my fault.  Now I am not so sure...
 
At any rate, the thing to do is to delete the user account both in User Accounts (if it exists) and in NetInfo.  I cannot remember if this needs to be done as the root user.  I don't think so but it might.  Next reboot.  This may not be technically necessary but a reboot covers a multitude of sins.  The next thing to do is create an account named PostgreSQL Administrator with the postgres short name.  Since you now know the password, no problem.
 
This worked for me.  Good luck.
 
Jeff 

Nathan Mealey <nathan@cycle-smart.com> 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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-general by date:

Previous
From: "Eric D. Nielsen"
Date:
Subject: Re: Has anyone tried Date/Darwen/Lorentzos's model for temporal data?
Next
From: George Essig
Date:
Subject: Re: Has anyone tried Date/Darwen/Lorentzos's model for temporal data?