Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B13482E002F for ; Mon, 25 Feb 2008 08:59:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 60535-02 for ; Mon, 25 Feb 2008 08:59:46 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.240]) by postgresql.org (Postfix) with ESMTP id 90E772E002E for ; Mon, 25 Feb 2008 08:59:53 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c36so325318ana.33 for ; Mon, 25 Feb 2008 04:59:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=1+Aj+O0BKyTAzRFnIHGq4W6ITHvQ20y+bDJEzqgFiRc=; b=GO7yxDGb8mdJHpemZsxVBh5E6qJ9d/poTbE+HMqrhuv/jqxd1A0pgBaKsjDYyEehfPv1o21qKnpfsnyuMXe7idE0y+1ACTsMrM/tWf9c/EPsb8VExq8yKtXU3wwXWjPbksR4faZ9lOwJILgyCXOBAOznrY6HS4zCiB7HhKiEA9Q= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=vvVa0NAyP29qUxE2gZVlXUn9cls4ft8mXqB9+TOWvKh5XAEkbgnwFAstn2A2LH+DByw9uWUEsyIQQE3oN8j2gLs3BQnmBbjCM5EpWrclXkAPCX31rxUaunTwXn11HT71kR2GlP0yaMyM6p153w/zHY1jjnfb9m0WauikoMJWizM= Received: by 10.100.105.15 with SMTP id d15mr6831016anc.100.1203944392606; Mon, 25 Feb 2008 04:59:52 -0800 (PST) Received: by 10.100.151.20 with HTTP; Mon, 25 Feb 2008 04:59:52 -0800 (PST) Message-ID: Date: Mon, 25 Feb 2008 18:29:52 +0530 From: "nabakumar salam" To: pgsql-admin@postgresql.org Subject: postgre suoer MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11831_25459197.1203944392597" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/313 X-Sequence-Number: 28387 ------=_Part_11831_25459197.1203944392597 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I have a single user role configured for my postgre database 8.2 The user is a super user. I opened the property window of this user and deselect the super user check box. It gave me a warning. I select OK. I was expecting that it would not allow removing that super user rights as it is the only super user in my DB. now my database is without any user with super user rights. How do I create one now or get back the previous super user? Can anybody give me some pointers?? Thanks in advance, Naba ------=_Part_11831_25459197.1203944392597 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I have a single user role configured for my postgre database 8.2
The user is a super user.
I opened the property window of this user and deselect the super user check box.
It gave me a warning. I select OK.
I was expecting that it would not allow removing that super user rights as it is the only super user in my DB.

now my database is without any user  with super user rights.
How do I create one now or get back the previous super user?
Can anybody give me some pointers??

Thanks in advance,
Naba

------=_Part_11831_25459197.1203944392597--