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
>>
>
>
>
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 |