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

Search Discussions

  • Peter Eisentraut at Nov 4, 2005 at 10:02 am

    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.
  • Merlin Moncure at Nov 4, 2005 at 6:49 pm

    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
  • Magnus Hagander at Nov 4, 2005 at 7:02 pm

    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
  • Merlin Moncure at Nov 4, 2005 at 7:06 pm

    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedNov 1, '05 at 12:46p
activeNov 4, '05 at 7:06p
posts5
users4
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase