Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 5E7C3633155 for ; Thu, 12 Mar 2009 16:39:38 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 17272-08 for ; Thu, 12 Mar 2009 16:39:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail02.svc.cra.dublin.eircom.net (mail02.svc.cra.dublin.eircom.net [159.134.118.18]) by mail.postgresql.org (Postfix) with SMTP id 6C34A632DFD for ; Thu, 12 Mar 2009 16:39:33 -0300 (ADT) Received: (qmail 68839 messnum 8362665 invoked from network[86.46.46.55/86-46-46-55-dynamic.b-ras3.mvw.galway.eircom.net]); 12 Mar 2009 19:39:30 -0000 Received: from 86-46-46-55-dynamic.b-ras3.mvw.galway.eircom.net (HELO ?127.0.0.1?) (86.46.46.55) by mail02.svc.cra.dublin.eircom.net (qp 68839) with SMTP; 12 Mar 2009 19:39:30 -0000 Message-ID: <49B964F4.1000104@iol.ie> Date: Thu, 12 Mar 2009 19:39:32 +0000 From: Raymond O'Donnell Reply-To: rod@iol.ie User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: =?ISO-8859-1?Q?Andr=E9_Silva?= CC: pgsql-general@postgresql.org Subject: Re: Postgresql References: In-Reply-To: X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Antivirus: avast! (VPS 090311-1, 11/03/2009), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/475 X-Sequence-Number: 145061 On 12/03/2009 16:51, André Silva wrote: > I've installed the postgresql in my computer but i've forgotten my > password. Do you mean the password for the super-user account in PostgreSQL itself (usually "postgres")? - or the password for the user account on the machine under which PostgreSQL runs? If it's the password for the PG superuser, and assuming that you've only just installed PG and have no databases yet that you want to keep, you could just scrub the installation and start again; do an initdb, or if you're on Windows, uninstall and reinstall. If you need to keep your installation, you could try what was suggested in this post: http://archives.postgresql.org/pgsql-general/2008-12/msg00700.php If it's the user account password, a privileged user can reset it...what OS are you on? > i've tried everything, i've been in your page that requires a e-mail > to send information to reset the password but i never get the e-mail > so far.(http://www.postgresql.org/community/lostpwd) That's not what you need - that's for community accounts which let you do stuff on the the PostgreSQL website, wiki, etc. > i've tried to > make a new username but the ones that i've tried already exist. What > can i do? format my pc? Ouch! Definitely not that! :-) Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------