Open Side Menu Go to the Top

09-18-2009 , 09:08 PM
Every 'solution' I have found I cant understand what it wants me to do.
For example
Quote:
> > Login as yourself, 'su' to root, then 'su' to
> postgres (there will be
> > no password prompt), then change the password.
>
> better: use sudo(8).
> for example: sudo -u postgres psql foobar
>
> no need to enter root password.
no clue what that means...

Only one clearly said to replace all the md5's w/trust in the pg_hba.conf file, which I did but that didnt help.

If anyone knows how to reset the password I would really appreciate it, thanks.
Forgot Postgres Password, Please help Quote
Forgot Postgres Password, Please help
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Forgot Postgres Password, Please help
09-18-2009 , 09:46 PM
PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

svcpass is another possibility


Go to your command function (for Vista users, type cmd in search) and type net user. This will show you which user groups are on your pc.

Net user will tell you what the user is on your machine.

If you still can't get connected thru HM you can either try to remove the password requirement entirely.


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

[PHP]

# 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
[/PHP]

You need to change the first 'md5' to 'trust', like this

[PHP]

# 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
[/PHP]


Save, and close the file.

Click: Start > Programs > PostgreSQL 8.3 > Reload configuration
Forgot Postgres Password, Please help Quote
09-18-2009 , 10:18 PM
Quote:
Originally Posted by fozzy71
PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

svcpass is another possibility


Go to your command function (for Vista users, type cmd in search) and type net user. This will show you which user groups are on your pc.

Net user will tell you what the user is on your machine.

If you still can't get connected thru HM you can either try to remove the password requirement entirely.


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

[PHP]

# 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
[/PHP]

You need to change the first 'md5' to 'trust', like this

[PHP]

# 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
[/PHP]


Save, and close the file.

Click: Start > Programs > PostgreSQL 8.3 > Reload configuration
thank you for trying, unfortunately it didnt work.

I have the name of the database, but the passwords do not work. I went into pg_hba.conf and made the changes then ran 'reload configuration' then tried all the passwords again but they did not work.
Forgot Postgres Password, Please help Quote
09-18-2009 , 11:58 PM
Maybe you need to start the service after what Fozzy suggested - Control Panel/Administrative Tools/Services and find postgres and start it - set startup type to automatically also.
Forgot Postgres Password, Please help Quote
09-19-2009 , 09:58 AM
Forgot Postgres Password, Please help Quote
09-19-2009 , 08:19 PM
friendly bump
Forgot Postgres Password, Please help Quote
09-19-2009 , 08:41 PM
What was this originally installed for? PT3? I am guessing you made a unique username and/or password.

See if this helps:

http://forumserver.twoplustwo.com/sh...ostcount=14138


Otherwise I would suggest a reinstall of sql 8.3 and try to reuse your \data folder, although this may actually require 2 installations. Once to get a copy of the default pg_hba.conf and other files (except postmaster.pid) and then another installation to reinstall your old database with those new default config files.

These faqs refer to what I was just discussing:

http://www.holdemmanager.net/faq/afm...aspx?faqid=177

http://www.holdemmanager.net/forum/s...ead.php?t=8261


or else go with a new 8.4 installation and import your archives.
Forgot Postgres Password, Please help Quote
09-19-2009 , 08:48 PM
it was originally installed for the pt3 trial, for the last ~6 months HEM.

Thanks for the links I'll go through them now.

Thanks for the help again
Forgot Postgres Password, Please help Quote
09-19-2009 , 09:24 PM
Quote:
Originally Posted by Jtringer
......, for the last ~6 months HEM.
........
If you need help with any of it:

Please email me at [email protected] so we can schedule a Teamviewer session. Download the www.Teamviewer.com Quick Support Module. It does not need to be installed, as it can run directly from your Desktop/Directory. Please let me know what time zone you are in and what time/days are convenient for you.
Forgot Postgres Password, Please help Quote
09-20-2009 , 06:55 PM
I've tried all of those things and it still wont work. The only difference is now i have like 4 empty new databases that hem wont connect to.

I dont know if this could be the problem:


I have clearly turned off User access control (and rebooted several times since), yet hem still brings up that warning as it tries to connect, im not sure if thats standard or not.
Forgot Postgres Password, Please help Quote
09-20-2009 , 07:19 PM
I am not sure what is going on, but I would be glad to take a look at it for you and try to help.

Please email me at [email protected] so we can schedule a Teamviewer session.
Forgot Postgres Password, Please help Quote
Forgot Postgres Password, Please help
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Forgot Postgres Password, Please help

      
m