Re: Admin user issue: unable to login after changing password

2014-02-05 sharon <sharon(at)erabyte(dot)it>:

>
> Hi,
> I'm sorry, there was a typing error. I fixed pg_hba.conf with " host
> all postgres localhost trust ". I'm
> still unable to run pgadmin or psql.
>
> Any suggestions would be greatly appreciated.
>
> Thank you
>
> Sharon
>
> Il 05/02/2014 5.00, Payal Singh ha scritto:
>
> looks like you missed the 'type' value in pg_hba? the sequence is type,
> database, user, address, method
>
> See http://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html
>
> Payal Singh,
> Junior Database Administrator,
> OmniTI Computer Consulting Inc.
> Phone: 240.646.0770 x 253
>
>
> On Tue, Feb 4, 2014 at 6:24 PM, <sharon(at)erabyte(dot)it> wrote:
>
>> Hi,
>> after fixing pg_hba.conf with host "all postgres
>> localhost trust" i started psql or pgadmin and i tryed to
>> log in but i still had to type a password.
>> After fixing the file .conf i restarted the service with no luck.
>> Any hint?
>>
>> Thank you
>>
>> Sharon
>>
>>
>> ----- Messaggio Originale -----
>> Da:
>> "Jerry Sievers" <gsievers19(at)comcast(dot)net>
>>
>> A:
>> "sharon" <sharon(at)erabyte(dot)it>
>> Cc:
>> <pgsql-admin(at)postgresql(dot)org>
>> Inviato:
>> Mon, 03 Feb 2014 13:21:34 -0600
>> Oggetto:
>> Re: [ADMIN] Admin user issue: unable to login after changing password
>>
>>
>>
>> sharon <sharon(at)erabyte(dot)it> writes:
>>
>> > Hi,
>> >
>> > I'm using postgres 9.2 on windows 7. I've changed the password of
>> > postgres user with pgadmin but now i'm unable to log in.
>> > There are two users accounts but only one is the admin. The problem is
>> > that the postgres' user expire date is set in 1970, I can see this
>> > from the other account.
>> > Is possible to replace users with a configuration hack? Or is possible
>> > to install everything again without loosing database's data?
>> > Is there a way to solve this issue?
>>
>> Fix your pg_hba.conf file to not require a password from the affected
>> user, reload it and then login and do a good pw reset and set
>> valid-until to infinity..
>>
>>
>> alter role postgres password 'good-pw' valid until 'infinity';
>>
>> HTH
>>
>> >
>> > Thank you
>> >
>> > Sharon
>>
>> --
>> Jerry Sievers
>> Postgres DBA/Development Consulting
>> e: postgres(dot)consulting(at)comcast(dot)net
>> p: 312.241.7800
>>
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>>
> Nessun virus nel messaggio.
> Controllato da AVG - www.avg.com
> Versione: 2014.0.4259 / Database dei virus: 3684/7061 - Data di rilascio:
> 04/02/2014
>
>
>
Hello sharon,
first : please use bottom
posting<http://en.wikipedia.org/wiki/Posting_style#Bottom-posting>, so
it's more easy to read the mail history / thread from up to down.
Second: could you attach the pg_hba.conf ?
Third: how you connect to postgresql ?
Four: after modify the pg_hba.conf, did you reload or restart postgresql?

I explain: if you connect to "localhost" the rule

host all postgres localhost trust

make you enter in the database trough the 127.0.0.1 on 5432 ( I imagine you
have the default settings and the firewall with the open port or firewall
down ) without password

psql -U postgres -h localhost

will connect to database

if you not specified "locahost" the probably rule you will meet will be
about "local" connection :

local all all peer

that will make you enter without password, only if your OS account exists
in the database.

Bye

Mat