PDA

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.