Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A30FD9FA25B for ; Mon, 11 Jun 2007 22:00:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 36775-04 for ; Mon, 11 Jun 2007 22:00:04 -0300 (ADT) X-Greylist: delayed 01:07:59.559999 by SQLgrey-1.7.5 Received: from alias7.ihug.co.nz (alias7.ihug.co.nz [203.96.222.17]) by postgresql.org (Postfix) with ESMTP id 7D94A9FB61A for ; Mon, 11 Jun 2007 22:00:11 -0300 (ADT) Received: from ironport2.ihug.co.nz [203.109.254.20] by alias7.ihug.co.nz with esmtp (Exim 3.36 #1 (Debian)) id 1Hxujw-0006Mw-00; Tue, 12 Jun 2007 13:00:08 +1200 Received: from grunt5.ihug.co.nz (HELO ihug.co.nz) ([203.109.254.45]) by ironport2.ihug.co.nz with SMTP; 12 Jun 2007 13:00:09 +1200 X-Ironport-Seen: Yes From: jbar@es.co.nz Reply-to: jbar@es.co.nz To: Subject: Re: problems installing postgresql 8.0 on Mac OS X-Mailer: Quality Web Email v3.1m, http://netwinsite.com/refw.htm X-Originating-IP: 222.154.146.18 Date: Tue, 12 Jun 2007 13:00:08 +1200 Message-id: <466df018.318.23f1.1467889480@ihug.co.nz> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.062 tagged_above=0 required=5 tests=AWL=-0.100, BAYES_50=0.001, DNS_FROM_RFC_ABUSE=0.2, NO_REAL_NAME=0.961 X-Spam-Level: * X-Archive-Number: 200706/94 X-Sequence-Number: 25762 John DeSoi wrote: >/sw is just for Fink, so I would expect nothing to go there unless you are using Fink. Ah! Thanks, John. >Which package did you download from sourceforge? I notice there are several variations and some might only have the client tools. It looks like you want the "PostgreSQL Unified Installer". That's the one. >I downloaded the startup item package. It appears to install the server in /Library folder. Here is the startup line: >su -m postgres -c '/Library/PostgreSQL8/bin/pg_ctl start -D /Library/ PostgreSQL8/data -l /Library/PostgreSQL8/log/PostgreSQL8.log -o -i' Thanks again! You're quite right, I didn't think to look in /Library, but there it is! However, when I try that command of yours, I get a password query, but it doesn't accept my password. How do I find out the correct password for super-user? My account is admin, & I earlier created a postgres administrator account (because I was told that a postgres user already existed, even though it doesn't show up in the accounts. I tried running your command but preceded by sudo instead, but terminal said I had illegal option -m. Sorry that my questions are so basic, and thanks for any further help you may offer. Cheers! Joe