pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (5+ messages)  latest in thread

Message-ID: <c2d9e70e0802212106u2023cef5yb04dceeae70d97a3@mail.gmail.com>
Permalink:  ../c2d9e70e0802212106u2023cef5yb04dceeae70d97a3@mail.gmail.com/
Also on:    postgresql.org/message-id/c2d9e70e0802212106u2023cef5yb04dceeae70d97a3@mail.gmail.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: 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