Re: initdb problem

Hi Joe,

This has got to be the longest thread ever to get PostgreSQL running  
on the Mac -- but I'm glad you have not given up :).

On Jun 21, 2007, at 12:49 AM, Joe Barwell wrote:

> acorn$ sudo su postgres -c 'pg_ctl start -l logfile -D
> /Library/PostgreSQL8/data'
> Password:
> sh: line 1: logfile: Permission denied
> server starting


Since you did not specify the full path for the log file, I assume it  
is created in the current directory. Check your permissions there.


> acorn$ postgres
> postgres cannot access the server configuration file
> "/Library/PostgreSQL8/data:/postgresql.conf": No such file
> or directory
>
> Surely initdb should have created the configure file?


Change to the data directory and see what is there. If you don't see  
lots of folders along with pg_hba.conf and postgresql.conf, then  
initdb did not work.

At the risk of sending you down another path when you are close, you  
might want to look at this distribution and instructions:

http://www.entropy.ch/software/macosx/postgresql/

If you still don't have initdb working, you might want to rename your  
postgres user and create a new one as described in these instructions.




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