Re: forgot password

From: Rick Visser <rickvisser86(at)gmail(dot)com>
To: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
Cc: Tim <elatllat(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: forgot password
Date: 2011-06-20 19:14:36
Message-ID: BANLkTikSdh0Ds_9ZE_=PVDDnDJOdfH7c6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)sharma(at)orkash(dot)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(at)gmail(dot)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
>>
>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-06-20 20:39:28 Re: ERROR: type "pg_catalog.int4" does not exist
Previous Message Marcelo Leite 2011-06-20 17:34:13 Re: dump from 9.0 to 8.3