Thread: intializing problem with postgresql-8.0.4-binaries-no-installer.zip

Hi,


I want to run the postgresql-8.0.4-binaries-no-installer.zip version
of the postgresql in windows 2000 environment. When I run initdb
command I got the following error message.

D:\softwares\postgresql-8.0.4-binaries-no-installer\pgsql\bin>initdb -D ../data
The files belonging to this database system will be owned by user "shma001".
This user must also own the server process.

The database cluster will be initialized with locale English_United Kingdom.125
.

fixing permissions on existing directory ../data ... ok
creating directory ../data/global ... ok
creating directory ../data/pg_xlog ... ok
creating directory ../data/pg_xlog/archive_status ... ok
creating directory ../data/pg_clog ... ok
creating directory ../data/pg_subtrans ... ok
creating directory ../data/base ... ok
creating directory ../data/base/1 ... ok
creating directory ../data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in ../data/base/1 ... Execution of PostgreSQL by a
ser with administrative permissions is not
permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromises.  See the documentation for
more information on how to properly start the server.
child process was terminated by signal 1
initdb: removing contents of data directory "../data"

Can I any body tell me how to run this version of postgresql server.

regards,

--
Shahid Manzoor

Shahid Manzoor wrote:
> The server must be started under an unprivileged user ID to prevent
> possible system security compromises.  See the documentation for
> more information on how to properly start the server.
> child process was terminated by signal 1
> initdb: removing contents of data directory "../data"
>
> Can I any body tell me how to run this version of postgresql server.

Please read the advice printed by initdb.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

> Hi,
>
>
> I want to run the postgresql-8.0.4-binaries-no-installer.zip version
> of the postgresql in windows 2000 environment. When I run initdb
> command I got the following error message.

> The server must be started under an unprivileged user ID to prevent

You cannot init or run the server from an admin account.  The easiest
thing to do is create a user and add to 'backup operator' group.  Then
do a runas to open command under that user context and do initdb.

Merlin

> > I want to run the
> postgresql-8.0.4-binaries-no-installer.zip version
> > of the postgresql in windows 2000 environment. When I run initdb
> > command I got the following error message.
>
> > The server must be started under an unprivileged user ID to prevent
>
> You cannot init or run the server from an admin account.  The
> easiest thing to do is create a user and add to 'backup
> operator' group.  Then do a runas to open command under that
> user context and do initdb.

I would strongly advise you *not* to use the Backup Operators group -
that's a potential security problem.

Instead, grant he account the "log on locally" user right, if you want
to run it with runas.

//Magnus

> You cannot init or run the server from an admin account.  The easiest
> thing to do is create a user and add to 'backup operator' group.  Then
> do a runas to open command under that user context and do initdb.

I am going to have to retract this.  While it is easiest to get pg
running manually from within backup operator group, this is not secure.


Merlin