Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F29979FB4F0 for ; Thu, 21 Jun 2007 01:50:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15838-09 for ; Thu, 21 Jun 2007 01:50:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from alias3.ihug.co.nz (alias3.ihug.co.nz [203.96.222.13]) by postgresql.org (Postfix) with ESMTP id 090109FB4D5 for ; Thu, 21 Jun 2007 01:49:59 -0300 (ADT) Received: from ironport3.ihug.co.nz [203.109.254.23] by alias3.ihug.co.nz with esmtp (Exim 3.36 #1 (Debian)) id 1I1EcI-0008P2-00; Thu, 21 Jun 2007 16:49:58 +1200 Received: from grunt14.ihug.co.nz (HELO ihug.co.nz) ([203.109.254.61]) by ironport3.ihug.co.nz with SMTP; 21 Jun 2007 16:49:58 +1200 X-Ironport-Seen: Yes From: Joe Barwell Reply-to: Joe Barwell To: Subject: Re: initdb problem X-Mailer: Quality Web Email v3.1m, http://netwinsite.com/refw.htm X-Originating-IP: 222.154.165.88 Date: Thu, 21 Jun 2007 16:49:58 +1200 Message-id: <467a0376.b4.49b9.1068201001@ihug.co.nz> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.375 tagged_above=0 required=5 tests=AWL=0.174, BAYES_50=0.001, DNS_FROM_RFC_ABUSE=0.2 X-Spam-Level: X-Archive-Number: 200706/214 X-Sequence-Number: 25882 "Phillip Smith" wrote: > My bad - is has the shell, but as you say, the home > directory is /dev/null > > niutil -destroyval -u admin . /users/postgres home > /dev/null niutil -appendprop -u admin . /users/postgres > home /Library/postgreSQL8 > > Once again, use at your own risk! Do let us know if it > worked or not. Hi Phillip, I just used NetInfo Manager itself to make the change. Question is, though: how will I know if it's worked? In my earlier email I said I had been unable to login as postgres until I'd added a shell for that user. In fact I still cannot login as postgres, being refused each time after I try to enter a password--and yes, I did use NetInfo Manager to give postgres a password I knew, seeing as I didn't know the default one. Giving postgres a shell, however, has allowed me to use the form sudo su postgres... When I do this: acorn$ sudo su postgres -c 'pg_ctl start -l logfile -D /Library/PostgreSQL8/data' Password: sh: line 1: logfile: Permission denied server starting terminal seems to say the server has begun, but there is still no sign of the server either in Activity Monitor or in being able to use the pg gui client tools to create a user or a database--both say the server is not active, or not accepting tcp/ip on port 5432. The following, however, makes me suspect it's still a problem with initdb: acorn$ postgres postgres cannot access the server configuration file "/Library/PostgreSQL8/data:/postgresql.conf": No such file or directory Surely initdb should have created the configure file? Cheers! Joe