Thread: New here: trouble getting postgres 9.3 running as service on windows 8.1

New here: trouble getting postgres 9.3 running as service on windows 8.1

From
Malik Rumi
Date:
Hello to you all. 

 I overcame the first errors I got about the TEMP environmental variable thanks to the info on the wiki. Then I got two warnings after install. 1) is that the adminpack did not install, and it asked if I was listening on the port. 2) was that I needed to check the conf.

A) I don’t know how I’ll fix this yet, - that's why I'm here - but once I do, how do I install the admin? Do I run the install again?

 B) I googled and found some posts insisting that I install on C:\postgres so as to avoid the spaces in the Windows path. But I used a windows installer with Program Files as the default. Surely the installer took the space issue into consideration, didn't it?

 C) “The postgres sql service started and then stopped. Some services stop automatically if they are not in use by other services or programs.”  How am I supposed to get it in use by another program if I can’t get it started?

 D) I found several posts that say postgres needs the secondary logon service to be running. Mine was not. I set it to automatic and then started postgres again but I got the same ‘started and stopped’ error message. What do I do now to get this going?

E) I have AVG Free, which the wiki says should not cause me any problems.

 F) The second error just says see the conf file, and then I found out there is no conf file yet. So am I safe in assuming that once I do create that (and the error log) that logging and conf issues will not be a problem? 

thanks!

 

 

Re: New here: trouble getting postgres 9.3 running as service on windows 8.1

From
Alvaro Herrera
Date:
Malik Rumi escribió:

Hello list,

>  I overcame the first errors I got about the TEMP environmental variable
> thanks to the info on the wiki. Then I got two warnings after install. 1)
> is that the adminpack did not install, and it asked if I was listening on
> the port. 2) was that I needed to check the conf.

Do we have any insight on what might be going on here?

Malik, I think you should be more specific: what was it that you
installed?  Where did you download it from?  Do you see diagnostic
messages in the event log and/or Postgres' log file?


> A) *I don't know how I'll fix this yet, - that's why I'm here - but once I
> do, how do I install the admin? Do I run the install again?*
>
> * B) I googled and found some posts insisting that I install on C:\postgres
> so as to avoid the spaces in the Windows path. But I used a windows
> installer with Program Files as the default. Surely the installer took the
> space issue into consideration, didn't it?*
>
> * C) **"The postgres sql service started and then stopped. Some services
> stop automatically if they are not in use by other services or programs."
>  How am I supposed to get it in use by another program if I can't get it
> started?*
>
> * D) **I found several posts that say postgres needs the secondary logon
> service to be running. Mine was not. I set it to automatic and then started
> postgres again but I got the same 'started and stopped' error message. What
> do I do now to get this going?*
>
> *E) I have AVG Free, which the wiki says should not cause me any problems.*
>
> * F) **The second error just says see the conf file, and then I found out
> there is no conf file yet. So am I safe in assuming that once I do create
> that (and the error log) that logging and conf issues will not be a
> problem? *
>
>  thanks!


--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services