Re: forgot password - Mailing list pgsql-admin

From Rick Visser
Subject Re: forgot password
Date
Msg-id BANLkTikSdh0Ds_9ZE_=PVDDnDJOdfH7c6A@mail.gmail.com
Whole thread Raw
In response to Re: forgot password  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-admin
Thanks a lot for your help and quick respond. There is a but... I truly don't know anything about computers. (as you might have noticed)
So the two question who rise are
- where to i find the pg_hba.conf-file and how do I adjust it to 'trust'? (ive searched my windows for it but i couldn;t find it)
- how do i start postgres with skip-grant-tables option (i believe ive erased the complete postgresql from my comp)?

Thanks alot again guys. Hopefully it will work this time.

Rick

2011/6/20 Adarsh Sharma <adarsh.sharma@orkash.com>
U can also start Postgres with skip-grant-tables option and thenafter change the password

fore.g;

bin/psql -Upostgres --skip-grant-tables


Tim wrote:
Hi Rick,

Firstly there are likely to be an OS postgres user and a DB postgres user.
How you reset the OS user depends on if you are using windows or linux, and should be learned elsewhere.
Removing PostgreSQL was not the correct thing to do but If you reset or remove the postgres user from your OS you will be able to reinstall PostgresQL. You will need to install the same version you had before if you want to keep your data.

To reset the DB postgres user change your pg_hba.conf to trust, restart PostgreSQL, connect and change the password:
ALTER USER postgres WITH PASSWORD 'postgres';

You should ask elsewhere for problems related to "Hold'em Manager".

"127001" should be "127.0.0.1"

You might consider learning some basics instead of gambling on other peoples advise.

On Sun, Jun 19, 2011 at 3:26 PM, Rick Visser <rickvisser86@gmail.com> wrote:
Hi,
 127001
today I wanted to login on Holdem Manager when the message popped up that my computer "failed to connect server 127001". I looked the net for sollutions, tried a few, including deleting postregql wich i tried and all didn;t work. While I tried to reinstall postregql it asked for my password. And now I forgot AND i believe all my postregql-files are deleted from my computer. What should I do?
Hopefully you can help me,

Thanks in forward and kind regards,

Rick



pgsql-admin by date:

Previous
From: CaT
Date:
Subject: Re: dump from 9.0 to 8.3
Next
From: Achilleas Mantzios
Date:
Subject: Re: dump from 9.0 to 8.3