Re: Stuck at the starting gate

Rich Shepard <rshepard(at)appl-ecosys(dot)com> writes:
> I wiped out the RH packages for -7.2.1 and built/installed -7.3.2 from
> source. Postmaster is running on the backend, but I cannot successfully add
> me as a user nor run initdb. I'm looking at the 7.2 tutorial pdf and don't
> see there where I went wrong. Here are some results:

> [postgres(at)salmo /home/rshepard]$ createuser rshepard
> Shall the new user be allowed to create databases? (y/n) y
> Shall the new user be allowed to create more new users? (y/n) y
> ERROR: 'autocommit' is not a valid option name
> createuser: creation of user "rshepard" failed

It looks to me like you have 7.3 createuser script talking to a 7.2 (or
even earlier) backend. Better double-check what you wiped out and what
you still have.

> [postgres(at)salmo /home/rshepard]$ initdb -D
> /home/rshepard/development/paisley/
> The files belonging to this database system will be owned by user
> "postgres".
> This user must also own the server process.

> The database cluster will be initialized with locale C.

> creating directory /home/rshepard/development/paisley/... mkdir: cannot
> create directory /home/rshepard/development/paisley': Permission denied

> initdb failed.

This seems clear enough: user postgres doesn't own user rshepard's
directories, hm?

regards, tom lane