Uninstalling PostgreSQL

[schreech26]

Anyone know how to do it?

[ptrack pat]

You can use the Start menu > Programs > Control Panel > Add or Remove Programs window to uninstall PostgreSQL
Then manually delete the remnants of the c:\program files\postgresql folder afterwards.

Before you do this, if you want to save any data or anything DO NOT do what I've told you to do above, let me know if you want to save anything. If you just want to get rid of PostgreSQL completely then you can do this.

[schreech26]

I actually tried transferring my postgreSQL data folder to an external HD as per the following wiki article:

http://wiki.postgresql.org/wiki/Change_ ... on_Windows

I couldn't get it to work, and when I try to reverse it by directing the imagepath back to my C drive, I get an error upon opening PT2 stating that a connection to my database cannot be made. I'm just going to delete it and start over unless you have any suggestions.

Thanks Pat.

[ptrack pat]

Here is what I usually tell people to try...
==

1. Create a new folder on your external drive called PostgreSQL_Data.
2. Go to the c:\program files\postgresql\8.2 folder. Right-click on the "data" folder and select "Copy" from the popup menu.
3. Go to the newly created folder on the external drive and right-click and select "Paste" from the popup menu.
4. Now, go to the Start menu and select Settings > Control Panel > Add or Remove Programs and then remove PostgreSQL 8.2 from the list.
5. From the Start menu again select Run. On the window that opens type "COMMAND" and hit OK. This will open a DOS window. Type the following next to the prompt...

net user postgres /delete

and hit ENTER to run it. Then type EXIT to close the DOS window.

6. Now, download and reinstall PostgreSQL as directed here:
http://www.pokertracker.com/products/PT ... nstallSQL2

WITH THE EXCEPTION THAT on the second window where it asks you where you want to install PostgreSQL click on the "Data Directory" button and navigate to the PostgreSQL_Data\data folder on the external drive and select that. This will force it to try to reuse your old data.

CONTINUE until you get to the window that has the "Initialize Database Cluster" box at the top left corner. UNCHECK THIS BOX and click the Next button and then just continue installing from there.

7. Once the install is done, RESTART YOUR COMPUTER and then try to open PT again.

[schreech26]

I'll give that a try. Thanks!

[schreech26]

Pat,

when I try installing postgreSQL after following the uninstall directions you gave me, I get an error at the last step saying "user 'postgres' already exists". Do you know how to delete that username?

[ptrack pat]

This was detailed in step #5 above.

[schreech26]

I carried out step 5 and I still get the error message. Maybe I'm typing in the command prompt incorrectly. Where should I be putting the spaces?

Edit: I get the following lines after I carry out step 5:

C:\DOCUE~1\HP_ADM~1>net user postgres/delete
The syntax of this command is:

NET USER
[username [password ! *] [options]] [/DOMAIN]
username {password | *} /ADD [options] [/DOMAIN]
username [/DELETE] [/DOMAIN]

[ptrack pat]

there needs to be a space between the / and postgres

postgres[space]/delete

[schreech26]

there needs to be a space between the / and postgres

postgres[space]/delete

I still get "User 'postgres' could not be created: The user account already exists.!"