Обсуждение: Admin user issue: unable to login after changing password

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?

Thank you

Sharon

sharon <sharon@erabyte.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.consulting@comcast.net
p: 312.241.7800

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@erabyte.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@comcast.net>

A:

"sharon" <sharon@erabyte.it>

Cc:

<pgsql-admin@postgresql.org>

Inviato:

Mon, 03 Feb 2014 13:21:34 -0600

Oggetto:

Re: [ADMIN] Admin user issue: unable to login after changing password

sharon <sharon@erabyte.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.consulting@comcast.net
p: 312.241.7800


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.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