Seems to be a permissions problem, make sure your /Library/postgreSQL8/ directory is owned by the postgres user. If you installed using binaries as root you have to chown /Library/postgreSQL8/ -R (this is what you do in Linux). Hope that helps. S -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of James Herbers Sent: Tuesday, June 19, 2007 9:11 PM To: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] initdb problem No MAC expert but try this when changing to the postgres user: su - postgres the hyphen gives you an environment for the postgres user. J. Herbers Quoting Joe Barwell <jbar@xxxxxxxx>: > Hello people, > > Having installed the universal binary for pg 8.2.4 on my mac running > 10.3.9, I'm now trying to use the initdb command, but keep running > into problems. I can't seem to get the right syntax. Can anyone > suggest where I'm going wrong? > Here's what terminal shows: > > Acorn acorn 1 acorn$ login root > Password: > Last login: Thu Jun 14 13:43:54 on ttyp1 Welcome to Darwin! > Acorn:~ root# su postgres > shell-init: could not get current directory: getcwd: cannot access > parent directories: Permission denied > su: /dev/null/.bashrc: Not a directory Acorn:/var/root postgres$ > initdb -D /Library/PostgreSQL8/data > su: initdb: command not found > Acorn:/var/root postgres$ cd > chdir: could not get current directory: getcwd: cannot access parent > directories: Permission denied > su: cd: /dev/null: Not a directory > Acorn:/var/root postgres$ cwd > su: cwd: command not found > Acorn:/var/root postgres$ /Library/PostgreSQL8/initdb -D > /Library/PostgreSQL8/data > su: /Library/PostgreSQL8/initdb: No such file or directory > Acorn:/var/root postgres$ /Library/PostgreSQL8/bin/initdb -D > /Library/PostgreSQL8/data could not identify current directory: > Permission denied could not identify current directory: Permission > denied could not identify current directory: Permission denied The > program "postgres" is needed by initdb but was not found in the same > directory as "initdb". > Check your installation. > Acorn:/var/root postgres$ > > TIA, > > Joe > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
