PDA

View Full Version : postgres problem



Its1mc
02-04-2009, 05:06 PM
I already have postgresql installed on mt PC from PT.So installed HEM and when I open it up a window says,"The following error occured when trying to open the databases:FATAL:28000 password authenticaion failed for user "postgres".So I click "OK" and the client still opens up and the Database Control Panel opens up and has the server name port,etc and when I push connect a window pops up and says,The user name and/or password was incorrect.Would you like to have Holdem manger configure the databases to accept this login password?

So I click "YES" and another window pops up and says that Holdem Manager updated your PostgreSQL.Please try connection again.So I tried and it just keeps repeating those exact steps,over and over.


Ive read FAQ,and I dont see any info that can help me.Do you know how I can fix this?

Its1mc
02-05-2009, 11:09 AM
Hey how ya doin?

morny
02-05-2009, 03:08 PM
edit the C:\Program Files\PostgreSQL\8.x\data\pg_hba.conf file and change md5 to trust and resave and it should be ok with any username or password. you can edit the file with notepad and then choose save when your done

Its1mc
02-05-2009, 05:27 PM
Thanks morny,

Unfortuneatly I'm retarded and I really don't understand that.Could you please breifly explain exactly how to do that for a slow person.

Thanks

Just dowloaded newest version
running Vista

morny
02-05-2009, 06:37 PM
open that file i linked in notepad. Then scroll until you see this lines:

# 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

Then change it from MD5 to trust so it looks 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 trust

Its1mc
02-05-2009, 07:26 PM
Dude Im so sorry,but what file did you linkto my notepad,What is notepad?

Just give me 1 more shot,lol

Its1mc
02-05-2009, 07:29 PM
Bump

Its1mc
02-05-2009, 07:33 PM
Ok I found it,ty.But I do not see anything of what you said.
There is no #TYPE DATABASE USER CDI,nothing.I'm sorry for the confusion and hope to get this figured out so I don't have to bother you anymore.But i've looked several times and there isn't any of the stuff you posted above.


Thanks

morny
02-05-2009, 07:52 PM
email me your pg_hba.conf file that you opened to morny@holdemmanager.net and ill change it for you and email it back

Its1mc
02-05-2009, 08:04 PM
Ok,I sent the notepad to you.Is that what I'm supposed to do?

Thanks


I dont think I did the right thing.Do I copy and paste the notepad?I'm sorry I'm confused.

morny
02-05-2009, 08:19 PM
i dont want notepad, send me an email and instead of attaching a picture to the email attach the file called pg_hba.conf which youll find here: C:\Program Files\PostgreSQL\8.x\data\

Its1mc
02-05-2009, 08:28 PM
I put this in before your e-mail.Please check your mail, I responded there.Bump

Thanks