tags:

views:

40

answers:

1
Q: 

Unable to uninstall postgreSQL from Add/Remove Programs

Running Windows XP Pro. Have been successfully using and deploying postgres for 2 years.

When I try to Uninstall PostgreSQL 8.3 using Windows Add/Remove Programs I get this message:

Service "PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start. Verify that you have sufficient privileges to start system services.

I have tried the following:

Created and logged on as various users as members of Administrators group. Deleted the 'postgres' user (is this a problem?) Removed all references to postgres in the registry. Rebooted Removed the PostgreSQL Service from the service list. (sc delete pgsql-8.3) Deleted the whole Postgres 8.3 directory in Program Files.

I have worked on this for 6 hours today to no avail. GRRRR.

Desperate for some suggestions??

A: 

Install PostgreSQL again in the same directory with all options. It will repair your installation. Then you'll be able to uninstall it using "Add/Remove Programs" cleanly.

Tometzky  2010-04-08 13:28:19
No it wont reinstall (says "Can't Start the Service")Ended up solving this by manually reinstalling and registering the pgsql service again from the command prompt THEN I was able to uninstall and reinstall as normal.Thanks for bothering to reply.
becsystems  2010-04-09 01:22:34

related questions

How do I (or can I) SELECT DISTINCT on multiple columns (postgresql)?
Is it possible to make a recursive SQL query ?
What does it mean when a PostgreSQL process is "idle in transaction"?
C# .NET + PostgreSQL
Possible to perform cross-database queries with postgres?
Cascading deletes in PostgreSQL
How to concatenate strings of a string field in a PostgreSQL 'group by' query?
Languages other than SQL in postgres
How to prevent Write Ahead Logging on just one table in PostgreSQL?
Using MS Access & ODBC to connect to a remote PostgreSQL
Reasons for SQL differences
PostgreSQL perfomance monitoring tool
How do you use script variables in PostgreSQL?
MySQL vs PostgreSQL for Web Applications
joining latest of various usermetadata tags to user rows
Good strategy for leaving an audit trail/change history for DB applications?
PostgreSQL: GIN or GiST indexes?
Migrating from MySQL to PostgreSQL
What's the preferred way to connect to a postgresql database from PHP?
Use for the phppgadmin Reports Database?
Recommendation for a PostgreSQL Programming Tutorial?
SQL Case Statement Syntax?
What language do you use for Postgresql triggers and stored procedures?
String literals and escape characters in postgresql
Python and MySQL