PDA

View Full Version : PostgreSQL help



Guyra
03-09-2011, 10:33 PM
I'm running out of space on my C drive on my laptop so I'm trying to clean up and delete some files.

I went to the postgreSQL directory and noticed that I have 2 sub folders under the main postgreSQL folder:

postgre 8.2 (38GB) date modified 1/23/10
postgre 8.3 (11GB) date modified 2/3/10

my questions are:

1. how do I know which postgre i need?
2. How do I know which postgre I'm using?
3. I'm assuming i don't need both. If thats correct, what happens if I delete one of these files?
4. Do I lose my HEM database if I delete one?
5. What should i do with both of these if i upgrade to 8.7?

thanks for the help

netsrak
03-10-2011, 04:42 AM
1. check your windows services: which Postgresql service is up and running? It should be only one of them (8.2 or 8.3). You can uninstall the other version completely and delete the remaining files after the uninstallation.

3.+4. if you delete the not used version you will not loose anything.

5. There is no 8.7 version. Newer versions are 8.4 and 9.0. But for Postgresql its a simple rule: never touch a running postgresql installation - so don't upgrade if its working flawlessly