From: jbar@es.co.nz
To: pgsql-admin@postgresql.org
Subject: problems installing postgresql 8.0 on Mac OS 10.3.9
Date: Fri, 08 Jun 2007 12:12:58 +1200
Message-ID: <46689f0a.321.39fd.435794905@ihug.co.nz> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jbar@es.co.nz
Subject: Re: problems installing postgresql 8.0 on Mac OS 10.3.9
In-Reply-To: <46689f0a.321.39fd.435794905@ihug.co.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox