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@sss.pgh.pa.us>
To: "Peter Eisentraut" <peter_e@gmx.net>
Cc: "Tim Barnard" <tbarnard@povn.com>; <pgsql-general@postgresql.org>
Sent: Sunday, February 04, 2001 7:54 PM
Subject: Re: [GENERAL] 7.1beta4 initdb problem
> Peter Eisentraut <peter_e@gmx.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
>
