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

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,

+3
source share
3 answers

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

( , , Windows, , .)

+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 .
+2

, - , . PostgreSQL, . , .

0

Source: https://habr.com/ru/post/1706186/


All Articles