Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 02A399FB85A for ; Thu, 7 Jun 2007 21:38:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 71483-04-2 for ; Thu, 7 Jun 2007 21:38:41 -0300 (ADT) X-Greylist: delayed 00:25:42.614208 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 1FDF59FC002 for ; Thu, 7 Jun 2007 21:38:52 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from alias10.ihug.co.nz (alias10.ihug.co.nz [203.96.222.20]) by svr4.postgresql.org (Postfix) with ESMTP id 220A15AF028 for ; Fri, 8 Jun 2007 00:13:08 +0000 (GMT) Received: from ironport3.ihug.co.nz [203.109.254.23] by alias10.ihug.co.nz with esmtp (Exim 3.36 #1 (Debian)) id 1HwNFo-0006tT-00; Fri, 08 Jun 2007 07:02:40 +1200 Received: from grunt5.ihug.co.nz (HELO ihug.co.nz) ([203.109.254.45]) by ironport3.ihug.co.nz with SMTP; 08 Jun 2007 12:12:59 +1200 X-Ironport-Seen: Yes From: jbar@es.co.nz Reply-To: jbar@es.co.nz To: Subject: problems installing postgresql 8.0 on Mac OS 10.3.9 X-Mailer: Quality Web Email v3.1m, http://netwinsite.com/refw.htm X-Originating-IP: 222.154.146.18 Date: Fri, 08 Jun 2007 12:12:58 +1200 Message-id: <46689f0a.321.39fd.435794905@ihug.co.nz> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.962 tagged_above=0 required=5 tests=BAYES_50=0.001, NO_REAL_NAME=0.961 X-Spam-Level: X-Archive-Number: 200706/74 X-Sequence-Number: 25742 Hello People, Mac OS 10.3.9 PostgreSQL 8.0 Background: I was reading a book titled Mac OS X Hacks, which has a brief section on installing PostgreSQL. It suggested one start by installing Fink, which I successfully did. Then I used FinkCommander to install PostgreSQL 8.0, which seemed to be successful (it reported no problems). Unfortunately, I'd forgotten to first create a Postgres user on my machine (i.e. admin/host), and when I tried to do that, I was told such a user (short) name already existed--although it does not appear in my list of users. When I open pgadmin3 (which I also used FinkCommander to install), it says I have zero servers. In Terminal, if I try: createdb mydb I get the response: createdb: could not connect to database template1: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? The help file for pgadmin3 says this means the server was not started, or not started where createdb expected it. Unfortunately, it merely says to consult one's administrator, which in my case is me. Can anyone please tell me where I can get some info. to figure out what I need to do to set up a) my server, b) my Postgres user, c) the PostgreSQL configurations? I have looked on the web and found a number of sources (e.g. apple) that show beginners like me what to do to install PostgreSQL, but they all seem to work with/from source code, compiled via Terminal. I had thought I was making things simpler by using FinkCommander to do the installation for me, especially given my lack of experience with Terminal. I imagine it would be a mistake to try to install PostgreSQL from source afresh, just so as to follow the steps described on the web, in the hope that I might thereby make a proper installation. Basically, my aim is to simply set up PostgreSQL to run, so that I can then begin the process of learning how to use it. My database experience is limited to FileMaker 6, but I am interested in learning how to use a true relational database. Cheers! Joe