Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I recently was tricked into running one of those registry cleaner programs (RegistryBooster).

It seemed to work fine until I tried to start my postgres service.

For some reason, the 'path to executable' was no longer set on the service properties page, and obviously would not start without a path.

How can I either fix the existing service or uninstall/ re-install just the service without re-installing postgres altogether?

postgres 8.4 windows xp sp3

EDIT: in trying to fix this, i've accidentally removed the service altogether. so the question becomes: how do i re-install the service without re-installing the whole of postgres?

thanks again...

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Try add/change key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgsql-8.4\ImagePath" in registry(change version and data dir):

"C:\Program Files\PostgreSQL\8.4\bin\pg_ctl.exe" runservice -w -N "pgsql-8.4" -D "C:\Program Files\PostgreSQL\8.4\data\"

or run command: "C:\Program Files\PostgreSQL\8.4\bin\pg_ctl.exe" runservice -w -N "pgsql-8.4" -D "C:\Program Files\PostgreSQL\8.4\data\"

If not help, you will need to reinstall PostgreSQL.

share|improve this answer
    
sorry, please see edit: i've actually deleted the service trying to resolve the issue... –  pstanton Feb 7 '11 at 7:59
    
ah, i sorted it.. having deleted the service, i changed your command from runservice to register .. the service is created and works fine :) thx. –  pstanton Feb 7 '11 at 8:02
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.