pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adarsh Sharma <adarsh.sharma@orkash.com>
To: Tim <elatllat@gmail.com>
Cc: Rick Visser <rickvisser86@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: forgot password
Date: Mon, 20 Jun 2011 11:58:13 +0530
Message-ID: <4DFEE87D.6040705@orkash.com> (raw)
In-Reply-To: <BANLkTi=dJvAzY=MqatJZGFBp9279wNaj=w@mail.gmail.com>
References: <BANLkTimBzMxCNHPUngKZE9CkLmBommcBOQ@mail.gmail.com>
	<BANLkTi=dJvAzY=MqatJZGFBp9279wNaj=w@mail.gmail.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 
> <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
>
>

view thread (4+ messages)  latest in thread

Message-ID: <4DFEE87D.6040705@orkash.com>
Permalink:  ../4DFEE87D.6040705@orkash.com/
Also on:    postgresql.org/message-id/4DFEE87D.6040705@orkash.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: adarsh.sharma@orkash.com, elatllat@gmail.com, rickvisser86@gmail.com
  Subject: Re: forgot password
  In-Reply-To: <4DFEE87D.6040705@orkash.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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