Had to uninstall postgresql

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Re: Had to uninstall postgresql

Postby bugsbunny » Sat Jun 21, 2008 9:57 am

Peligroso wrote:It sounds weird. If it doesn't feel like too much hassles, I'd like you to try to uninstall and reinstall once again.

Go to Control Panel -> Add/Remove Programs and uninstall PostgreSQL.

Now, to completely remove the traces of PostgreSQL; go Start -> Run and write "cmd" to start the command prompt. In the command prompt, write "net user postgres /delete" (without the quotation marks). Also, go to C:\Program Files and make sure that your PostgreSQL folder is deleted.

Now, download PostgreSQL 8.3.3 from here:
ftp://ftp.postgresql.org/pub/binary/v8. ... .3.3-1.zip
Or if you're using Windows Vista, download PostgreSQL 8.2.7 here:
ftp://ftp.postgresql.org/pub/binary/v8. ... .2.7-1.zip

Run the installation file and install PostgreSQL.


This should work. The net user command is the key. Note that you will lose your existing DB assuming a complete uninstall. There is a way around this, but it would lead to further difficulties down the road (which can be worked around with some finagling) If you want to know how (and you haven't yet deleted the existing data files) let me know. It's simpler to just delete everything, re-install, and then reload the hand histories - but if you already have a large DB you're probably better off trying to keep it.

Hmm - install of latest 8.3 should work under Vista from what I've seen on the Postgres lists. If it doesn't somebody should post to there and see what the developers say.

Edit: One possible work around that I've seen mentioned for Vista is to go start > accessories > command prompt > right click on it > run as administrator , then run the msi installer from there (CD to the location of the msi file, then just run it by typing in the name and hitting enter)
Last edited by bugsbunny on Sat Jun 21, 2008 10:03 am, edited 1 time in total.
bugsbunny
 
Posts: 65
Joined: Sun Feb 10, 2008 9:29 am

Re: Had to uninstall postgresql

Postby snoopy » Sat Jun 21, 2008 9:58 am

Susan here is a screenshot where I put it:

http://img59.imageshack.us/img59/9084/sqlbr8.jpg

Is that right?

Peligroso wrote:It sounds weird. If it doesn't feel like too much hassles, I'd like you to try to uninstall and reinstall once again.

Go to Control Panel -> Add/Remove Programs and uninstall PostgreSQL.

Now, to completely remove the traces of PostgreSQL; go Start -> Run and write "cmd" to start the command prompt. In the command prompt, write "net user postgres /delete" (without the quotation marks). Also, go to C:\Program Files and make sure that your PostgreSQL folder is deleted.

Now, download PostgreSQL 8.3.3 from here:
ftp://ftp.postgresql.org/pub/binary/v8. ... .3.3-1.zip
Or if you're using Windows Vista, download PostgreSQL 8.2.7 here:
ftp://ftp.postgresql.org/pub/binary/v8. ... .2.7-1.zip

Run the installation file and install PostgreSQL.

Ok I will try this now.
snoopy
 
Posts: 38
Joined: Sat May 31, 2008 8:57 am

Re: Had to uninstall postgresql

Postby Peligroso » Sat Jun 21, 2008 9:59 am

bugsbunny wrote:
Hmm - install of latest 8.3 should work under Vista from what I've seen on the Postgres lists. If it doesn't somebody should post to there and see what the developers say.
I'm not sure on this one myself, but we've had some issues with 8.3 on Vista (thread), not sure about the latest versions though, would be nice if it's been fixed :)
Peligroso
 
Posts: 1483
Joined: Mon Dec 10, 2007 6:51 pm
Location: Sweden

Re: Had to uninstall postgresql

Postby snoopy » Sat Jun 21, 2008 10:01 am

Sorry that image isn't big enough.

This one should be http://img59.imageshack.us/img59/6471/sqlka8.jpg
snoopy
 
Posts: 38
Joined: Sat May 31, 2008 8:57 am

Re: Had to uninstall postgresql

Postby Peligroso » Sat Jun 21, 2008 10:03 am

snoopy wrote:Sorry that image isn't big enough.

This one should be http://img59.imageshack.us/img59/6471/sqlka8.jpg
No, that's not the right folder. You should browse to C:\Program Files\PostgreSQL\8.x\bin and place it there instead :)
Peligroso
 
Posts: 1483
Joined: Mon Dec 10, 2007 6:51 pm
Location: Sweden

Re: Had to uninstall postgresql

Postby snoopy » Sat Jun 21, 2008 10:04 am

Ah! That could be it. I haven't uninstalled yet, so I will try that first.
snoopy
 
Posts: 38
Joined: Sat May 31, 2008 8:57 am

Re: Had to uninstall postgresql

Postby bugsbunny » Sat Jun 21, 2008 10:06 am

Peligroso wrote:
bugsbunny wrote:
Hmm - install of latest 8.3 should work under Vista from what I've seen on the Postgres lists. If it doesn't somebody should post to there and see what the developers say.
I'm not sure on this one myself, but we've had some issues with 8.3 on Vista (thread), not sure about the latest versions though, would be nice if it's been fixed :)


I just added an edit to my post.
Edit: One possible work around that I've seen mentioned for Vista is to go start > accessories > command prompt > right click on it > run as administrator , then run the msi installer from there (CD to the location of the msi file, then just run it by typing in the name and hitting enter)

Since I don't have Vista I can't check any of this. If someone can, and it works (and normal methods don't), they may want to update the other thread.
bugsbunny
 
Posts: 65
Joined: Sun Feb 10, 2008 9:29 am

Re: Had to uninstall postgresql

Postby snoopy » Sat Jun 21, 2008 10:08 am

Ok I put it in the right place and when I reload the configuration a new error message appears saying ssleay32-0.9.8e.dll was not found.

Maybe I have a series of files missing for some reason? In that bin file I noticed there were no application extension files in there apart from the one I put in there just now. Don't know if that is relevant?
snoopy
 
Posts: 38
Joined: Sat May 31, 2008 8:57 am

Re: Had to uninstall postgresql

Postby Peligroso » Sat Jun 21, 2008 10:11 am

snoopy wrote:Ok I put it in the right place and when I reload the configuration a new error message appears saying ssleay32-0.9.8e.dll was not found.

Maybe I have a series of files missing for some reason? In that bin file I noticed there were no application extension files in there apart from the one I put in there just now. Don't know if that is relevant?
That is relevant, there should be quite a few. Please try uninstalling and reinstalling again instead following the directions above, I hope that will work better :)
Peligroso
 
Posts: 1483
Joined: Mon Dec 10, 2007 6:51 pm
Location: Sweden

Re: Had to uninstall postgresql

Postby snoopy » Sat Jun 21, 2008 10:12 am

Ok thanks, will do. I will follow the uninstall/reinstallation instructions in your earlier post.
snoopy
 
Posts: 38
Joined: Sat May 31, 2008 8:57 am

PreviousNext

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 35 guests

cron
highfalutin