pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedforgot password
4+ messages / 3 participants
[nested] [flat]
* forgot password
@ 2011-06-19 19:26 Rick Visser <rickvisser86@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Rick Visser @ 2011-06-19 19:26 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: forgot password
@ 2011-06-20 06:05 Tim <elatllat@gmail.com>
parent: Rick Visser <rickvisser86@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tim @ 2011-06-20 06:05 UTC (permalink / raw)
To: Rick Visser <rickvisser86@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: forgot password
@ 2011-06-20 06:28 Adarsh Sharma <adarsh.sharma@orkash.com>
parent: Tim <elatllat@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Adarsh Sharma @ 2011-06-20 06:28 UTC (permalink / raw)
To: Tim <elatllat@gmail.com>; +Cc: Rick Visser <rickvisser86@gmail.com>; pgsql-admin
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
> <mailto: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
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: forgot password
@ 2011-06-20 19:14 Rick Visser <rickvisser86@gmail.com>
parent: Adarsh Sharma <adarsh.sharma@orkash.com>
0 siblings, 0 replies; 4+ messages in thread
From: Rick Visser @ 2011-06-20 19:14 UTC (permalink / raw)
To: Adarsh Sharma <adarsh.sharma@orkash.com>; +Cc: Tim <elatllat@gmail.com>; 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
>>
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-06-20 19:14 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-06-19 19:26 forgot password Rick Visser <rickvisser86@gmail.com>
2011-06-20 06:05 ` Tim <elatllat@gmail.com>
2011-06-20 06:28 ` Adarsh Sharma <adarsh.sharma@orkash.com>
2011-06-20 19:14 ` Rick Visser <rickvisser86@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox