Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3C4F164FD01 for ; Thu, 18 Sep 2008 09:35:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84837-04 for ; Thu, 18 Sep 2008 09:35:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web25803.mail.ukl.yahoo.com (web25803.mail.ukl.yahoo.com [217.12.10.188]) by postgresql.org (Postfix) with SMTP id D437564FCF9 for ; Thu, 18 Sep 2008 09:35:32 -0300 (ADT) Received: (qmail 45279 invoked by uid 60001); 18 Sep 2008 12:35:30 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=IErX1AfhOQEU1ucNO/yfewUQZmu16tmC62bheqKP98Z5ENUSn36OnzH+DxZuUzk4gyMxtjf/PYaUvwXpXhbQefh3xf8jC/7wuOC2vh6npwDd31L11qQOf/A6by7Qcp6Apr72oK6fP1GmX3ul31d51xASMtXwiBbAxn5F2sEWO0Q=; X-YMail-OSG: sI15VXgVM1lWE6xUYT05nNYyj1LDxJJTU2aNba0en_Nsm5gqQ_NMZswBvpVfgEWviW.UuMjKLqiy0CsvnC.Xel31oD.UfAS43SHzEW6CG2G3R5IuATS8.QfSVV94q5lVzx4MGTgTKuB2fIv3Zr6yYfM- Received: from [83.166.184.142] by web25803.mail.ukl.yahoo.com via HTTP; Thu, 18 Sep 2008 12:35:30 GMT X-Mailer: YahooMailWebService/0.7.218.2 Date: Thu, 18 Sep 2008 12:35:30 +0000 (GMT) From: Glyn Astill Reply-To: glynastill@yahoo.co.uk Subject: Re: Regaining superuser access To: pgsql-admin@postgresql.org, Bernt Drange In-Reply-To: <355ba921-203b-4380-bee4-67209316be62@x35g2000hsb.googlegroups.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Message-ID: <497334.45125.qm@web25803.mail.ukl.yahoo.com> 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: 200809/194 X-Sequence-Number: 30287 > The server only has one superuser, and for some reason he > decided to > remove the logon privilege on this user in PgAdmin III. So > now he has > lost superuser access to the database server. >=20 > Is there some way to override this setting? Or some way to > trick > PostgreSQL into creating a new superuser without superuser > access? Start it up in single user mode? http://www.postgresql.org/docs/8.3/static/app-postgres.html=0A=0A=0A