Hi all,
When I try to run "initdb" id get the messing "creating template1 database in c:/postgres/data/base/1 ... Execution of PostgreS
QL by a user 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."
OS I am using : "Windows 2000 Professional"
I understand this message. Actually I created a new user "postgres" with password as different than "postgres", also gave permission to the "c:\postgres" (installation folder) with "postgres" user permission. When I specify "runas /noprofile /user:postgres cmd" and then when I specify "initdb" I am getting the above error message, this is with Postgres 8.1, in the past with postgres 7.x I am not facing this problem.
One surprising observation what I see is that => when I run "initdb" the cmd shell is showing "The files belonging to this database system will be owned by user "pk00xxxx".
This user must also own the server process." where "pk00xxxx" is the machine what I logged in.
Question:
How to configure "initdb" to use "postgres" instead of "pk00xxxx" user. Anyone kindly help in this regard.
Thank You.
With warm regards,
Premnath.k.n
Siemens Communication Software,
2nd floor, Shankara Narayana Building-1,
25/1 Mahatma Gandhi Road,
Bangalore - 560 001,
India.
Phone: Off : 91-80-2506 2400, 2559 4067 - 73
Extn : 6369
Fax : 91-80-2506 2406
Resi : 91-80-28436106
Mobile: 91-98445 19798
Email: [EMAIL PROTECTED]