postgresql service corrupt, how can i re-create service?

Question

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

Answer 1

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.