Re: forgot password - Mailing list pgsql-admin

From Adarsh Sharma
Subject Re: forgot password
Date
Msg-id 4DFEE87D.6040705@orkash.com
Whole thread Raw
In response to Re: forgot password  (Tim <elatllat@gmail.com>)
Responses Re: forgot password  (Rick Visser <rickvisser86@gmail.com>)
List 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> 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: Tim
Date:
Subject: Re: forgot password
Next
From: Nils Gösche
Date:
Subject: How to pg_upgrade an 8.4.3 Installation