Re: problems installing postgresql 8.0 on Mac OS

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