Skip site navigation (1) Skip section navigation (2)

Re: Postmaster.pid & Unix domain socket errors, OS X

From: Jens Eliasson <for17(at)mac(dot)com>
To: David Haines <dhaines1(at)attbi(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postmaster.pid & Unix domain socket errors, OS X
Date: 2003-03-29 08:32:05
Message-ID: EBFD89E0-61C0-11D7-829C-000A959E1F4A@mac.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi David,
Sorry for my slow response, I don't check in on the list messages every 
day. I'm surprised nobody have replied.

We also use pgSQL on Mac OS X, 10.2.4. I do hope you use the build made 
by Marc Liyanage, that is easiest found on versiontracker.com. Go to 
the developer's site referenced on versiontracker, there you will find 
splendid instructions.

With version 7.3 we have not experienced any problems that you 
describe, on any of three diffferent computer.

But with 7.3.2, which I run on one machine I did have a problem like 
the one you describe.

2003-03-17, 03.43 David Haines wrote:
> I've checked the archives at
> And Apple's documentation at
> http://developer.apple.com/internet/macosx/postgres.html
> And the article at www.macdevcenter.com, as well as the available info 
> at
> Techdocs.postgresql.org
>
> I have successfully installed PostgreSQL 7.3 for Mac OS X (10.2.4) and 
> can
> successfully start postgresql - it returns the message "postmaster
> successfully started."
The return message in the terminal is unsufficient, in Process Viewer 
you should three processes with the name "Postgres" when it is started 
alright, you may have to use some other tool or log in as Postgres if 
you run pg like that (postgres user). If not, look in the postgres 
logfile where the cause of the unsuccessful start probably is well 
explained. (Make sure that you initiate logging in your startup call.)

Since I only use pg for development purposes locally, I run it in my 
own user-session which I find more convenient, even though that may be 
unsafe.

In the case of 7.3.2 it was the "LC_TIME" option in the postgresql.conf 
that caused the failed startup for me. According to the documentation 
LC_TIME is not yet in effect, but should load its locale value. I 
fidgeted with it for a while, but I only got pg to run OK by 
"commenting" it (#).

I hope this gives you some help.

/ Jens Eliasson <jens(at)headlong(dot)se> @ Headlong Development AB, 
Stockholm, Sweden

>   However, when I try to create a database ("createdb mydb")
> I get the error:
> psql: 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"?
>
>  I am only trying to use a localhost connection (no TCP/IP), for
> learning/development purposes. I shut off my software firewall (though 
> I
> shouldn't have to, right ?), and that made no difference.
>  I checked & rechecked the pg_hba.conf and postgresql.conf files. 
> Another
> troubling thing, is that when I try to restart (thinking I probably 
> should,
> after config changes !), with the command: pg_ctl reload
> I get the error message, "pg_ctl: cannot find
> /usr/local/pgsql/data/postmaster.pid Is postmaster running?"
>
>     So, I don't know where to go from here. I have verified 
> permissions on
> the /usr/local/pgsql  directory (did a chown -R ), and made sure to 
> add the
> paths
> setenv PGDATA /usr/local/pgsql/data
> setenv PATH ${PATH}:/usr/local/pgsql/bin
> To my .tcshrc file, and some of the aliases  I've setup in there (for 
> other
> unrelated commands) do work fine.
>
>     I am of course admitting that I'm _completely_ new to this. Please 
> help
> (!)
>
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to 
> majordomo(at)postgresql(dot)org
>


In response to

pgsql-novice by date

Next:From: Dmitri TouretskyDate: 2003-03-30 12:11:13
Subject: Index behavior question
Previous:From: Jens EliassonDate: 2003-03-29 08:27:53
Subject: Re: Postmaster.pid & Unix domain socket errors, OS X

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group