Re: 7.1beta4 initdb problem

Thanks Tom, the problem wasn't that, though, since I was logged in as
postgres at the time. However, as I was trying to create the database under
/progs and it's permissions were set to r-x, changing them to rwx fixed it.
It took awhile to figure it out as the error message threw me off :-)

Regards,

Tim

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: "Tim Barnard" <tbarnard(at)povn(dot)com>; <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, February 04, 2001 7:54 PM
Subject: Re: [GENERAL] 7.1beta4 initdb problem

> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > Tim Barnard writes:
> >> The program '/usr/local/pgsql/bin/postgres' needed by initdb does not
> >> belong to PostgreSQL version 7.1beta4. Check your installation.
>
> > Can you run 'sh -x initdb ...' and show me the output? Some platform
> > information would be useful as well.
>
> Ah, I see the problem:
>
> $ bin/postgres -V
> postgres (PostgreSQL) 7.1beta4
> $ su
> Password:
> # bin/postgres -V
>
> "root" execution of the PostgreSQL server is not permitted.
>
> The server must be started under an unprivileged userid to prevent
> a possible system security compromise. See the INSTALL file for
> more information on how to properly start the server.
>
>
> Probably initdb should have its own check for being run as root;
> this seems cleaner than reorganizing the checks in the postgres
> executable.
>
> regards, tom lane
>