Videos / Other Resources

No attachments were found.

Secondary Logon Service Error

When installing PostgreSQL, the following error occurs:

 postgresql-error.jpg

 

 


Solution:

Turn on Secondary Logon Service.

  1. Click the Windows Start button
  2. Type in "Services" and run the Services program
  3. Scroll down to "Secondary Logon" (See Screen Below)
  4. Right click Secondary Logon and select Start
  5. Install PostgreSQL again

 postgresql-error-01.jpg

 

 

Secondary logon service should be set to start Automatically

After unsucsesful install do this:
1) Open My Computer - disk C 
2) Find a folder C:\PostgreSQL (if not exists - create it), 
3) Right-click on it > select Properties > security > you will see form like this


4) Press EDIT  - this opens another form



5) Press ADD in it - new form opens 




6) in the bottom part of it type 
postgres
7) Press Check names > then OK and you will be returned to the second window 



8) select user "postgres" there > click "Allow - Full control" flag in the bottom

9) click OK to close all these windows
10) Istall postgres again. 

**If you do installation using HM2 installer - just wait till process finishes**

**If you are installing Postgres using a standalone setup - set C:\PostgreSQL as install folder (when asked)**

 

| More

Related Articles


User Opinions (5 votes)

80% thumbs up 20% thumbs down

How would you rate this answer?



Thank you for rating this answer.

Continue