Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E534AB5DBC2 for ; Mon, 20 Jun 2011 03:27:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 75556-05 for ; Mon, 20 Jun 2011 06:27:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp162.dfw.emailsrvr.com (smtp162.dfw.emailsrvr.com [67.192.241.162]) by mail.postgresql.org (Postfix) with ESMTP id 8C63BB5DBC0 for ; Mon, 20 Jun 2011 03:27:42 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp6.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id ED9612702DF; Mon, 20 Jun 2011 02:27:38 -0400 (EDT) X-Virus-Scanned: OK Received: by smtp6.relay.dfw1a.emailsrvr.com (Authenticated sender: adarsh.sharma-AT-orkash.com) with ESMTPSA id 2DC8427071B; Mon, 20 Jun 2011 02:27:36 -0400 (EDT) Message-ID: <4DFEE87D.6040705@orkash.com> Date: Mon, 20 Jun 2011 11:58:13 +0530 From: Adarsh Sharma User-Agent: Thunderbird 2.0.0.22 (X11/20090625) MIME-Version: 1.0 To: Tim CC: Rick Visser , pgsql-admin@postgresql.org Subject: Re: forgot password References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------080904070508050707010303" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201106/118 X-Sequence-Number: 37744 This is a multi-part message in MIME format. --------------080904070508050707010303 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 > 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 > > --------------080904070508050707010303 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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


--------------080904070508050707010303--