Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <john.knightley@gmail.com>) id 1TC6Ik-0003ZO-Ro
	for pgsql-admin@postgresql.org; Thu, 13 Sep 2012 10:05:39 +0000
Received: from sam.nabble.com ([216.139.236.26])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <john.knightley@gmail.com>) id 1TC6Ij-0002Um-RZ
	for pgsql-admin@postgresql.org; Thu, 13 Sep 2012 10:05:38 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <john.knightley@gmail.com>) id 1TC6Ij-0004hI-0z
	for pgsql-admin@postgresql.org; Thu, 13 Sep 2012 03:05:37 -0700
Date: Thu, 13 Sep 2012 03:05:37 -0700 (PDT)
From: johnkn63 <john.knightley@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1347530737005-5723854.post@n5.nabble.com>
In-Reply-To: 
 <D960CB61B694CF459DCFB4B0128514C2086C1224@exadv11.host.magwien.gv.at>
References: <1347523484328-5723838.post@n5.nabble.com>
	<D960CB61B694CF459DCFB4B0128514C208625B5F@exadv11.host.magwien.gv.at>
	<1347525027096-5723841.post@n5.nabble.com>
	<1347525330.11259.44.camel@lenovo01-laptop03.gunduz.org>
	<1347525940889-5723843.post@n5.nabble.com>
	<D960CB61B694CF459DCFB4B0128514C2086C1224@exadv11.host.magwien.gv.at>
Subject: Re: non-superuser login phpPgAdmin PostgreSQL 9.1
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: 0.0 (/)
X-Archive-Number: 201209/67
X-Sequence-Number: 40008


Thank you for your patience. Whilst this is the error one gets for a wrong
password, this is not the case here simply changing the status of the user
to superuser without touching the password allows the user to login,
removing superuser status the reverse. 

This login error might be caused by the following, or something similar:-

"pg_upgrade already starts the postmaster with a -b option that disables
non-super-user logins:

    /*
     * Binary upgrades only allowed super-user connections
     */
    if (IsBinaryUpgrade && !am_superuser)
    {
        ereport(FATAL,
                (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
             errmsg("must be superuser to connect in binary upgrade
mode")));
    } "  

taken from 
http://postgresql.1045698.n5.nabble.com/new-maintenance-db-options-td5714000.html
http://postgresql.1045698.n5.nabble.com/new-maintenance-db-options-td5714000.html 
. This seems to be new in 9.1 .

pg_hba.conf  is the standard

   local   all    postgres   		 peer 
  local   all             all       	 peer 
  host    all             all        127.0.0.1/32            md5
  host    all             all        ::1/128                 md5

Regards





--
View this message in context: http://postgresql.1045698.n5.nabble.com/non-superuser-login-phpPgAdmin-PostgreSQL-9-1-tp5723838p5723854.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.