Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 18D129FB6A7 for ; Wed, 18 Jul 2007 06:56:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12403-07 for ; Wed, 18 Jul 2007 06:56:45 -0300 (ADT) X-Greylist: delayed 01:22:22.317028 by SQLgrey-1.7.5 Received: from mulga.csse.unimelb.edu.au (mulga.csse.unimelb.edu.au [128.250.1.22]) by postgresql.org (Postfix) with ESMTP id DA9429FB232 for ; Wed, 18 Jul 2007 06:56:42 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mulga.csse.unimelb.edu.au with ESMTP id l6I8YG9V016692 for ; Wed, 18 Jul 2007 18:34:17 +1000 (EST) Received: from mulga.csse.unimelb.edu.au ([127.0.0.1]) by localhost (mulga.csse.unimelb.edu.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 16402-03; Wed, 18 Jul 2007 18:34:15 +1000 (EST) Received: from [128.250.1.83] (mugga.csse.unimelb.edu.au [128.250.1.83]) by mulga.csse.unimelb.edu.au with ESMTP id l6I8Y9Sm016649; Wed, 18 Jul 2007 18:34:14 +1000 (EST) Message-ID: <469DD084.9060707@csse.unimelb.edu.au> Date: Wed, 18 Jul 2007 18:34:12 +1000 From: John Horvath User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Setting usesuper bit for user postgres. Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at csse.unimelb.edu.au X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200707/202 X-Sequence-Number: 26183 Greetings. I have trawled the Web for answers but have found none to my problem. The 'usesuper' bit for user "postgres" was set to 'f' by default in the pg_shadow table in my PostgreSQL 7.4.2 installation when I installed it on my OS X host. My database is working fine (has been for a couple of years) but I want to add some more users. Any pointers on how to fix the usesuper bit issue for user postgres when this is the only DB "superuser"? Trying to modify this user's attributes from the commandline or via phpPgAdmin does not seem to work for me. Many thanks. John