Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WApM2-0005Eq-QK for pgsql-admin@arkaria.postgresql.org; Tue, 04 Feb 2014 23:24:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WApM2-0001Jn-0x for pgsql-admin@arkaria.postgresql.org; Tue, 04 Feb 2014 23:24:34 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WApM0-0001Jg-Tv for pgsql-admin@postgresql.org; Tue, 04 Feb 2014 23:24:33 +0000 Received: from mrq-1.mgm.tiscali.com ([213.205.37.41]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WApLx-00038L-13 for pgsql-admin@postgresql.org; Tue, 04 Feb 2014 23:24:32 +0000 Received: from [10.39.80.14] by mrq-1 with esmtp (Exim) id 1WApLs-0000JA-Ds; Tue, 04 Feb 2014 23:24:25 +0000 Message-Id: <3f61263db4cb6dc04f6d3f6677dc02a563e31934@webmail.erabyte.it> From: sharon@erabyte.it To: pgsql-admin@postgresql.org X-Mailer: Atmail 6.6.1.11564 X-Originating-IP: 93.58.170.203 in-reply-to: <86ob2o3su9.fsf@jerry.enova.com> Subject: Re: Admin user issue: unable to login after changing password Date: Wed, 05 Feb 2014 00:24:22 +0100 Content-Type: multipart/alternative; boundary="=_aa4662fd3af10d1860958d92d5cfa303" MIME-Version: 1.0 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --=_aa4662fd3af10d1860958d92d5cfa303 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =C2=A0Hi,after fixing pg_hba.conf with host =C2=A0 =C2=A0"all =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=0Apostgres =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 localhost =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 trust" i=0Astarted psql or pgadmin and i tryed to log in but i still= had to type=0Aa password.=0AAfter fixing the file .conf i restarted the= service with no luck.=0AAny hint?=0A=0AThank you=0A=0ASharon=0A=0A-----= Messaggio Originale -----=0ADa: "Jerry Sievers" =0AA:"sharon" =0ACc:=0A= Inviato:Mon, 03 Feb 2014 13:21:34 -0600=0AOggetto:Re: [ADMIN] Admin user= issue: unable to login after changing=0Apassword=0A=0A sharon writes:= =0A=0A > Hi,=0A >=0A > I'm using postgres 9.2 on windows 7. I've changed= the password of=0A > postgres user with pgadmin but now i'm unable to l= og in.=0A > There are two users accounts but only one is the admin. The= problem=0Ais=0A > that the postgres' user expire date is set in 1970, I= can see this=0A > from the other account.=0A > Is possible to replace u= sers with a configuration hack? Or is=0Apossible=0A > to install everyth= ing again without loosing database's data?=0A > Is there a way to solve= this issue?=0A=0A Fix your pg_hba.conf file to not require a password f= rom the affected=0A user, reload it and then login and do a good pw rese= t and set=0A valid-until to infinity..=0A=0A alter role postgres passwor= d 'good-pw' valid until 'infinity';=0A=0A HTH=0A=0A >=0A > Thank you=0A= >=0A > Sharon=0A=0A -- =0A Jerry Sievers=0A Postgres DBA/Development Co= nsulting=0A e: postgres.consulting@comcast.net=0A p: 312.241.7800=0A=0A= -- =0A Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)= =0A To make changes to your subscription:=0A http://www.postgresql.org/m= ailpref/pgsql-admin=0A --=_aa4662fd3af10d1860958d92d5cfa303 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =C2=A0Hi,
after fixing pg_hba.conf with hos= t =C2=A0 =C2=A0"all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 postgres= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 localhost =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 trust" i started psql or pgadmin and i t= ryed 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 O= riginale -----
Da:
"Jerry Sievers" <gsieve= rs19@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: unab= le to login after changing password


=0Asharon <sharo= n@erabyte.it> writes:

=0A> Hi,
=0A>
=0A>= ; I'm using postgres 9.2 on windows 7. I've changed the password of
=0A> postgres user with pgadmin but now i'm unable to log in.
= =0A> There are two users accounts but only one is the admin. The prob= lem is
=0A> that the postgres' user expire date is set in 1970,= I can see this
=0A> from the other account.
=0A> Is pos= sible to replace users with a configuration hack? Or is possible
= =0A> to install everything again without loosing database's data?=0A> Is there a way to solve this issue?

=0AFix your pg= _hba.conf file to not require a password from the affected
=0Auser,= reload it and then login and do a good pw reset and set
=0Avalid-u= ntil to infinity..


=0Aalter role postgres password 'goo= d-pw' valid until 'infinity';

=0AHTH

=0A>
= =0A> Thank you
=0A>
=0A> Sharon

=0A-- =0AJerry Sievers
=0APostgres DBA/Development Consulting
=0A= e: postgres.consulting@comcast.net
=0Ap: 312.241.7800

=0A--
=0ASent via pgsql-admin mailing list (pgsql-admin@postgr= esql.org)
=0ATo make changes to your subscription:
=0Ahttp://w= ww.postgresql.org/mailpref/pgsql-admin
--=_aa4662fd3af10d1860958d92d5cfa303--