From: Jaime Casanova <systemguards@gmail.com>
To: Wolfgang Rodriguez <mayckmarck@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Clave usuario postgres
Date: Fri, 22 Feb 2008 00:06:35 -0500
Message-ID: <c2d9e70e0802212106u2023cef5yb04dceeae70d97a3@mail.gmail.com> (raw)
In-Reply-To: <BAY144-W313BD0000A20AE2C570417C41D0@phx.gbl>
References: <238696420802192330g69e3c447jeadd1d3d31506eda@mail.gmail.com>
<47BBDF78.7070801@Sheeky.Biz>
<238696420802200115m522cfd11h2f37d87845c2d6e0@mail.gmail.com>
<BLU110-W177EE0CB22E47BDF4AEFA3A9230@phx.gbl>
<238696420802200219y7bfd4269u498dd1fe0b80c2cc@mail.gmail.com>
<BLU110-W38F89600CC13EE6E9F279EA9230@phx.gbl>
<238696420802200311y40a93a38jbd601e280d2fb860@mail.gmail.com>
<BAY144-W313BD0000A20AE2C570417C41D0@phx.gbl>
this is an english list, you can write in spanish at
pgsql-es-ayuda@postgresql.org
2008/2/21 Wolfgang Rodriguez <mayckmarck@hotmail.com>:
>
>
> Saludos a todos.
>
> Se me presenta el siguiente problema: olvidé y extravié la clave o password
> del usuario postgres y no puedo accesar las distintas bases de datos.
>
> Por favor, alguien sabe cómo podría recuperar esta clave o password?
> Me han dicho que si vuelvo a instalar la aplicación, es decir, el manejador
> de postgres, puedo perder toda la información de las bases de datos.
>
is this the password for the OS user "postgres" or the DB role "postgres"?
if the former you tell that to your sysadmin in order to him to reset it...
then change the pg_hba.conf file and put trust as the method
authorization for local access or maybe sameuser then reset it with
ALTER ROLE
of course, you need access to the machine...
--
Atentamente,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook
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: systemguards@gmail.com, mayckmarck@hotmail.com
Subject: Re: Clave usuario postgres
In-Reply-To: <c2d9e70e0802212106u2023cef5yb04dceeae70d97a3@mail.gmail.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