Two Plus Two Newer Archives  

Go Back   Two Plus Two Newer Archives > Other Topics > Computer Technical Help

Reply
 
Thread Tools Display Modes
  #1  
Old 11-20-2007, 06:41 PM
Pudge714 Pudge714 is offline
Senior Member
 
Join Date: May 2005
Location: The Black Kelly Holcomb
Posts: 13,713
Default Can\'t find postgresql password.

I downloaded postgresql a year ago and can't remember my password, I have tried uninstalling and reinstalling, but it has done nothing any tips?
Reply With Quote
  #2  
Old 11-21-2007, 12:57 AM
Josem Josem is offline
Senior Member
 
Join Date: Jan 2007
Location: Victoria, Australia
Posts: 4,780
Default Re: Can\'t find postgresql password.

it's probably something obvious.

like "postgrespass" or "abcde" or "12345" etc.
Reply With Quote
  #3  
Old 11-21-2007, 07:08 PM
Bremen Bremen is offline
Senior Member
 
Join Date: Aug 2004
Location: Please Sir, I want some fish.
Posts: 2,026
Default Re: Can\'t find postgresql password.

Well you can delete the hash for the postgres password by going to "Program Files\PostgreSQL\$VERSION\data\base\global" open the file pg_pwd with notepad and then delete the hash string. Unfortunately that just makes the whole thing unusable. I suspect that uninstalling isn't removing this file. Perhaps if you uninstall and then delete the file?

I think postgres maintains there own forums, you might try there.
Reply With Quote
  #4  
Old 11-21-2007, 09:55 PM
_dave_ _dave_ is offline
Senior Member
 
Join Date: Feb 2005
Location: UK
Posts: 2,628
Default Re: Can\'t find postgresql password.

You can find it in plaintext by searching "postgres" or "pg_pass" or something like that in th Windows Registry.

Take care if you don't know about the registry, tho.
Reply With Quote
  #5  
Old 11-21-2007, 10:19 PM
Bremen Bremen is offline
Senior Member
 
Join Date: Aug 2004
Location: Please Sir, I want some fish.
Posts: 2,026
Default Re: Can\'t find postgresql password.

PT stores the password in plaintext, postgres does not. Lets hope PT3 corrects this.
Reply With Quote
  #6  
Old 11-21-2007, 10:45 PM
Josem Josem is offline
Senior Member
 
Join Date: Jan 2007
Location: Victoria, Australia
Posts: 4,780
Default Re: Can\'t find postgresql password.

[ QUOTE ]
PT stores the password in plaintext, postgres does not. Lets hope PT3 corrects this.

[/ QUOTE ]

to stop all the thieves breaking into your home who then try to access your PT database?
Reply With Quote
  #7  
Old 11-22-2007, 12:31 AM
psionic storm psionic storm is offline
Senior Member
 
Join Date: Feb 2007
Location: Hamilton, ON, Canada
Posts: 279
Default Re: Can\'t find postgresql password.

haha that made my day.
Reply With Quote
  #8  
Old 11-22-2007, 01:04 AM
Bremen Bremen is offline
Senior Member
 
Join Date: Aug 2004
Location: Please Sir, I want some fish.
Posts: 2,026
Default Re: Can\'t find postgresql password.

[ QUOTE ]
[ QUOTE ]
PT stores the password in plaintext, postgres does not. Lets hope PT3 corrects this.

[/ QUOTE ]

to stop all the thieves breaking into your home who then try to access your PT database?

[/ QUOTE ]

Finally! Someone understands. Anyway, if security was really important PT would ask for the password each time it connects to the database. I don't see PT3 going this route so I doubt it will change.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.