Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

postgres- start process under administrator account

Is it possible to start postgres process with a user account that has "administrative" privileges? I am on windows XP.

--Error shown is --- (Not really error, it is a security feature)

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.

Current work around is to create normal user and run process under that. What I am looking at is quick way to start database, do some operations and shut it down as part of build process.

like image 354
Jayan Avatar asked Oct 25 '10 12:10

Jayan


1 Answers

(years later)

Postgres ships with a control program. See details in official documentation

Short answer:

pg_ctl start "args" 
like image 178
Jayan Avatar answered Sep 29 '22 00:09

Jayan