pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
problems installing postgresql 8.0 on Mac OS 10.3.9
9+ messages / 4 participants
[nested] [flat]

* problems installing postgresql 8.0 on Mac OS 10.3.9
@ 2007-06-08 00:12  jbar@es.co.nz
  0 siblings, 2 replies; 9+ messages in thread

From: jbar@es.co.nz @ 2007-06-08 00:12 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problems installing postgresql 8.0 on Mac OS 10.3.9
@ 2007-06-08 01:18  John DeSoi <desoi@pgedit.com>
  parent: jbar@es.co.nz
  1 sibling, 0 replies; 9+ messages in thread

From: John DeSoi @ 2007-06-08 01:18 UTC (permalink / raw)
  To: jbar@es.co.nz; +Cc: pgsql-admin


On Jun 7, 2007, at 8:12 PM, jbar@es.co.nz wrote:

> 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?


The easiest way to determine if PostgreSQL is running is to use  
Activity Monitor (in Applications/Utilities). Look for a process  
named postgres.

8.0 is fairly old, so if that is the latest on Fink you should look  
elsewhere. If you are new to PostgreSQL, there is no reason to start  
with an old version.

You can find a Mac PostgreSQL installer here with some admin tools:

http://sourceforge.net/projects/pgsqlformac/


It appears to have been updated recently with the latest version of  
PostgreSQL.


John






John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problems installing postgresql 8.0 on Mac OS 10.3.9
@ 2007-06-08 01:24  Tom Lane <tgl@sss.pgh.pa.us>
  parent: jbar@es.co.nz
  1 sibling, 0 replies; 9+ messages in thread

From: Tom Lane @ 2007-06-08 01:24 UTC (permalink / raw)
  To: jbar@es.co.nz; +Cc: pgsql-admin

jbar@es.co.nz writes:
> 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).

I recall hearing complaints that the Fink packaging of Postgres was
bizarrely nonstandard.  I don't recall any details, but it might be
worth your trouble to troll the PG list archives for mentions of Fink.

Anyway, it sounds like Fink installed the software but didn't actually
start the database server for you (which is a good thing, really).
Your next steps are probably "initdb" and then "pg_ctl start".
You might be able to use pgadmin3 to do those for you.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problems installing postgresql 8.0 on Mac OS
@ 2007-06-11 23:52  jbar@es.co.nz
  0 siblings, 1 reply; 9+ messages in thread

From: jbar@es.co.nz @ 2007-06-11 23:52 UTC (permalink / raw)
  To: pgsql-admin

Hello People,

My (belated) thanks to John DeSoi & Tom Lane for their
responses to my earlier
query.

I have uninstalled the old postgres 8.0 via FinkCommander,
and downloaded
the 8.2.4 binaries from the sourceforge website that John
suggested. The
installer seemed to run fine, but afterward I find that
there are no postgres
files in my /sw/ directory. It has installed files in
/Applications/ instead, but I
suspect they are just gui front-ends.

At this website <http://www.postgresql.org/docs/techdocs.4;
there are two
links describing how to install postgres on mac os x, but
unfortunately neither
seem to fit my circumstances. Both use source rather than
binaries. Both show
./configure commands that will only work if I first have
postgres installed
either at /usr/local/src/ (which I believe is not a valid
path) or /users/shared/,
but I don't see any way for ./configure to work even if I
pointed it at /
Applications/PostgreSQL\ Folder/.

1. What am I doing wrong?
2. Is this the right forum in which to ask?
3. Are there better sources of information/guides for
directions on how to
install postgres on mac os 10.3.9?
4. Should I also uninstall the postgres I got from
sourceforge, & try again with
source files rather than binaries? That way it at least
might begin to more
closely fit with the installation instructions at
<http://www.postgresql.org/
docs/techdocs.4>, although I doubt a perfect fit is possible
given the
variations & perhaps dated nature of those documents.

TIA,

Joe



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problems installing postgresql 8.0 on Mac OS
@ 2007-06-12 00:28  John DeSoi <desoi@pgedit.com>
  parent: jbar@es.co.nz
  0 siblings, 0 replies; 9+ messages in thread

From: John DeSoi @ 2007-06-12 00:28 UTC (permalink / raw)
  To: jbar@es.co.nz; +Cc: pgsql-admin


On Jun 11, 2007, at 7:52 PM, jbar@es.co.nz wrote:

> The
> installer seemed to run fine, but afterward I find that
> there are no postgres
> files in my /sw/ directory. It has installed files in
> /Applications/ instead, but I
> suspect they are just gui front-ends.


/sw is just for Fink, so I would expect nothing to go there unless  
you are using Fink.

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".

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'


>  Both use source rather than
> binaries. Both show
> ./configure commands that will only work if I first have
> postgres installed
> either at /usr/local/src/ (which I believe is not a valid
> path) or /users/shared/,
> but I don't see any way for ./configure to work even if I
> pointed it at /
> Applications/PostgreSQL\ Folder/.

It does not matter where you put the source to compile it. Just  
change to the directory where the source is. And you can have it put  
the binaries wherever you want if you provide the --prefix option to  
make.

If you don't have Apple's developer tools installed (required to  
build from source), I suggest you ask sourceforge project admins for  
help on their list or forum. They just put out a new version, so I'm  
sure they would be interested to know if there are problems.

John




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problems installing postgresql 8.0 on Mac OS
@ 2007-06-12 01:00  jbar@es.co.nz
  0 siblings, 1 reply; 9+ messages in thread

From: jbar@es.co.nz @ 2007-06-12 01:00 UTC (permalink / raw)
  To: pgsql-admin

John DeSoi <desoi@pgedit.com> 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



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problems installing postgresql 8.0 on Mac OS
@ 2007-06-12 01:23  John DeSoi <desoi@pgedit.com>
  parent: jbar@es.co.nz
  0 siblings, 0 replies; 9+ messages in thread

From: John DeSoi @ 2007-06-12 01:23 UTC (permalink / raw)
  To: jbar@es.co.nz; +Cc: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problems installing postgresql 8.0 on Mac OS
@ 2007-06-12 03:41  Joe Barwell <jbar@es.co.nz>
  0 siblings, 1 reply; 9+ messages in thread

From: Joe Barwell @ 2007-06-12 03:41 UTC (permalink / raw)
  To: pgsql-admin

John DeSoi <desoi@pgedit.com> wrote:

> 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

Hello John,

OK, it installed fine, restarted fine, but postgres does not
appear in Activity
Monitor. I can't use Creat User in the Client tools (or any
other tool). It says:

Database connection failed:
could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

pgAdmin III likewise can't connect to the postgres server.

Cheers!

Joe



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problems installing postgresql 8.0 on Mac OS
@ 2007-06-12 04:22  John DeSoi <desoi@pgedit.com>
  parent: Joe Barwell <jbar@es.co.nz>
  0 siblings, 0 replies; 9+ messages in thread

From: John DeSoi @ 2007-06-12 04:22 UTC (permalink / raw)
  To: Joe Barwell <jbar@es.co.nz>; +Cc: pgsql-admin


On Jun 11, 2007, at 11:41 PM, Joe Barwell wrote:

> OK, it installed fine, restarted fine, but postgres does not
> appear in Activity
> Monitor. I can't use Creat User in the Client tools (or any
> other tool). It says:
>
> Database connection failed:
> could not connect to server: Connection refused
> Is the server running on host "localhost" and accepting
> TCP/IP connections on port 5432?

See if there is an error message in the console log (/Applications/ 
Utilities/Console). The startup command was:

su -m postgres -c '/Library/PostgreSQL8/bin/pg_ctl start -D /Library/ 
PostgreSQL8/data -l /Library/PostgreSQL8/log/PostgreSQL8.log -o -i'

Is there a valid cluster created in /Library/PostgreSQL8/data? You  
should also be able find what went wrong by looking in the PostgreSQL  
log file which is the path specified by -l above.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL




^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2007-06-12 04:22 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-08 00:12 problems installing postgresql 8.0 on Mac OS 10.3.9 jbar@es.co.nz
2007-06-08 01:18 ` John DeSoi <desoi@pgedit.com>
2007-06-08 01:24 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-06-11 23:52 Re: problems installing postgresql 8.0 on Mac OS jbar@es.co.nz
2007-06-12 00:28 ` Re: problems installing postgresql 8.0 on Mac OS John DeSoi <desoi@pgedit.com>
2007-06-12 01:00 Re: problems installing postgresql 8.0 on Mac OS jbar@es.co.nz
2007-06-12 01:23 ` Re: problems installing postgresql 8.0 on Mac OS John DeSoi <desoi@pgedit.com>
2007-06-12 03:41 Re: problems installing postgresql 8.0 on Mac OS Joe Barwell <jbar@es.co.nz>
2007-06-12 04:22 ` Re: problems installing postgresql 8.0 on Mac OS John DeSoi <desoi@pgedit.com>

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