pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: johnkn63 <john.knightley@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: non-superuser login phpPgAdmin PostgreSQL 9.1
Date: Thu, 13 Sep 2012 03:05:37 -0700 (PDT)
Message-ID: <1347530737005-5723854.post@n5.nabble.com> (raw)
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>


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-tp5723838p5723...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




view thread (14+ messages)  latest in thread

Message-ID: <1347530737005-5723854.post@n5.nabble.com>
Permalink:  ../1347530737005-5723854.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1347530737005-5723854.post@n5.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: john.knightley@gmail.com
  Subject: Re: non-superuser login phpPgAdmin PostgreSQL 9.1
  In-Reply-To: <1347530737005-5723854.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox