View Full Version : Big problem with database
Arizona Willie
08-25-2009, 01:16 PM
I wanted to backup my database so I went to the FAQ someone pointed me to and all was well until it wanted my password.
I don't remember giving it a password when I set it up. I think I just bypassed it.
I've tried leaving it blank .. putting a space ... my usual passwords NADA.
Can't get past that point.
Any suggestions?
fozzy71
08-25-2009, 03:54 PM
PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass
If that password isn't right, you can try using svcpass.
If neither of those work, you can remove the need for a password by editing the pg_hba.conf file.
Start > Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf
The file should open with Notepad
Scroll to the bottom where you will see this code
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5
You need to change the first 'md5' to 'trust', like this
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 md5
Save, and close the file.
Click: Start > Programs > PostgreSQL 8.3 > Reload configuration
Arizona Willie
08-25-2009, 04:05 PM
Thank you very very much ... will give that a try real soon. Lunch time.
Arizona Willie
08-25-2009, 05:48 PM
Got it!! Worked like a charm with the first password.
Thanks again.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.