How to start the PostgreSQL database service in the "Local system" section?

Question

I use PostgreSQL DB in my application, I used to create a special Windows user account to start the database service.

Now I need to start the PostgreSQL service under the Local System account! Is there a configuration in PostgreSQL to specify the user account that the service is running?

Thanks,

Answer 1

Computer Management → Services → select the Postgres server service → right-click → Properties → check the “Login” tab, like any other Windows service.

( , , Windows, , .)

Answer 2

zip- PostgreSQL. . , "", db .. Windows Advanced System Configuration → Environment Variables.

PGDATA , "C:\PostgreSQL\data" ( ).

Path bin, - 'C:\PostgreSQL\bin;....'.

...

• ( Vista Win 7). : 'initdb' Enter. .
• : 'pg_ctl register -N PostgreSQL -U LocalSystem' enter. run services.msc , PostgreSQL .

Answer 3

, - , . PostgreSQL, . , .