Re: initdb problem

"Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au> wrote:

> My bad - is has the shell, but as you say, the home
> directory is /dev/null
>
> niutil -destroyval -u admin . /users/postgres home
> /dev/null niutil -appendprop -u admin . /users/postgres
> home /Library/postgreSQL8
>
> Once again, use at your own risk! Do let us know if it
> worked or not.

Hi Phillip,

I just used NetInfo Manager itself to make the change.
Question is, though: how will I know if it's worked?

In my earlier email I said I had been unable to login as
postgres until I'd added a shell for that user. In fact I
still cannot login as postgres, being refused each time
after I try to enter a password--and yes, I did use NetInfo
Manager to give postgres a password I knew, seeing as I
didn't know the default one. Giving postgres a shell,
however, has allowed me to use the form sudo su postgres...

When I do this:

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

terminal seems to say the server has begun, but there is
still no sign of the server either in Activity Monitor or in
being able to use the pg gui client tools to create a user
or a database--both say the server is not active, or not
accepting tcp/ip on port 5432.

The following, however, makes me suspect it's still a
problem with initdb:

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?

Cheers!

Joe