Link to home
Create AccountLog in
Avatar of thready
thready

asked on

Can't start Postgres service after new install (Windows)

Hi Experts,
I installed postgres - under a non-admin account through the installer for Postgres 8.3.  The installer itself tries to start the service and cannot after the cluster is initialized...

If I go to the command prompt under the bin directory and type 'net.exe  start pgsql-8.3' (as is the call to start the service through the menu), I get the following error:

System error 1068 has occurred.  The dependency service or group failed to start.

Any ideas why this may be happening?  I have all anti-virus and firewalls turned off.....  I have no clue what is going on here....

Many thanks!
Mike
Avatar of Adrian Pop
Adrian Pop
Flag of Sweden image


Have you tried to start postgres from the command line?
It might give you more info on what is the problem.
Login as the non-admin user
Start->run->cmd
> cd \path\to\postgresql\bin
.\postgres -D "C:\path\to\postgresql\data"

Cheers,
za-k/
Avatar of thready
thready

ASKER

Hello gentlemen,

Thank you very much for your help!  Adrpo, I did try the command line - that's where I saw the text "System error 1068...."

Best,
Mike

Hi,

Have you looked into the Event Viewer?
It might contain more information on
why the service cannot be started.

Start->Control Panel->Administrative Tools->Event Viewer
Look into Application for errors happening at about the time
you tried to start the service. You can also try to start the
service and then refresh the Event Viewer and look on what
events appeared in the meantime.

Cheers,
za-k/
Avatar of thready

ASKER

Hi Adrpo,
Good idea - I have the following errors which showed up in event viewer -->
First Error:
This computer is configured as a member of a workgroup, not as a member of a domain. The Netlogon service does not need to run in this configuration.
2nd error:
The PostgreSQL Database Server 8.3 service depends on the Net Logon service which failed to start because of the following error:
%%0

So I guess that explains it - but I still don't know what to do here...  I know my computer is not part of a domain... Does it need to be?  It wasn't before and I had Postgres working....

Thanks!
Mike

Hi,

Just force Netlogon service to run on startup even if you're not member
of a domain. Put the service into Automatic startup type. Also you could
do this (I don't know if it will work):
- start the Netlogon service (right click on it in Services and say start)
- start the PostgresSQL service (right click on it in Services and say start)
You might also reboot the computer and see if is working if you haven't done that already.

Well, this is weird as on my computer the NetLogon does not appear
in the PostgreSQL service dependencies. (See the images).

It might be that you wrongly installed PostgreSQL.
I suggest you uninstall PostgreSQL and try to install it again and then pay
close attention to the options.

Cheers,
za-k/

PostgreSQL-Service-LogOnTab.JPG
PostgreSQL-Service-DependenciesT.JPG
Avatar of thready

ASKER

No luck starting the Net Logon service manually - it starts and stops immediately.  The message I get when I start it is:  'The Net Logon service on Local Computer started and then stopped.  Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.'

Hmm... I'm really stuck....
ASKER CERTIFIED SOLUTION
Avatar of Adrian Pop
Adrian Pop
Flag of Sweden image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of thready

ASKER

I thank you very much for your persistence in helping me - very nice of you and extremely appreciated.  Cheers to you!
-Mike