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

Re: initdb problem

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Joe Barwell <jbar(at)es(dot)co(dot)nz>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: initdb problem
Date: 2007-06-22 04:37:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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:

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.
Power Tools for PostgreSQL

In response to

pgsql-admin by date

Next:From: Jayakumar_MukundarajuDate: 2007-06-22 05:14:50
Subject: Re: back up maintenance schedule
Previous:From: Vishal AroraDate: 2007-06-22 04:29:57
Subject: Re: back up maintenance schedule

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