Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A55BA9FB530 for ; Mon, 11 Jun 2007 22:23:37 -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 48388-06 for ; Mon, 11 Jun 2007 22:23:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from a2s5.a2hosting.com (a2s5.a2hosting.com [209.124.50.10]) by postgresql.org (Postfix) with ESMTP id ADC809FB3FA for ; Mon, 11 Jun 2007 22:23:34 -0300 (ADT) Received: from adsl-153-125-165.tys.bellsouth.net ([70.153.125.165] helo=[192.168.1.12]) by a2s5.a2hosting.com with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.63) (envelope-from ) id 1Hxv6a-0002Yx-R2; Mon, 11 Jun 2007 21:23:33 -0400 In-Reply-To: <466df018.318.23f1.1467889480@ihug.co.nz> References: <466df018.318.23f1.1467889480@ihug.co.nz> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: Content-Transfer-Encoding: 7bit From: John DeSoi Subject: Re: problems installing postgresql 8.0 on Mac OS Date: Mon, 11 Jun 2007 21:23:29 -0400 To: jbar@es.co.nz X-Mailer: Apple Mail (2.752.3) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s5.a2hosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/95 X-Sequence-Number: 25763 On Jun 11, 2007, at 9:00 PM, jbar@es.co.nz wrote: > 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. I think the easiest approach to get you started is to download and install the startup item. Then reboot your computer. You won't need to know the postgres user password to start the server and it will be started automatically when your computer starts. http://sourceforge.net/project/showfiles.php? group_id=133151&package_id=147282 John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL