BUG #8682: sqlstate = 28000

On Sat, Dec 14, 2013 at 3:59 PM, <arjsia@gmail.com> wrote:

The following bug has been logged on the website:

Bug reference: 8682
Logged by: abhay jadhav
Email address: arjsia@gmail.com
PostgreSQL version: 8.4.0

8.4.0 is outdated, you have 4 years of bug fixes waiting for you if
you update to the latest minor release of 8.4 which is 8.4.19.

Operating system: win7 and xp
Description:

sql state = 28000 error. when the application starts. please reply with
solution

Just by having a look at the docs referencing error code =>
http://www.postgresql.org/docs/devel/static/errcodes-appendix.html:
Class 28 - Invalid Authorization Specification
28000 E ERRCODE_INVALID_AUTHORIZATION_SPECIFICATION
invalid_authorization_specification
This means that the access to server failed because of authorization
restrictions (like an undefined role, an attempt to access to a
database whose access is not possible for a given user, etc.).

Without more details it is hard to tell what is happening though, but
first you should check your server access credentials.
Regards,
--
Michael

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

On 12/14/2013 6:24 PM, Michael Paquier wrote:

Without more details it is hard to tell what is happening though, but
first you should check your server access credentials.
Regards,

which, in this case, are likely the credentials configured in the
Services (in Computer Management, under Administration Tools in the
Windows Control Panel)... find the postgresql service, note what user
its being run as (likely 'postgres'), then go into Local Users and
Groups, locate that user, and set an arbitrary password, then set that
same password in the Services properties on the Log On tab... after you
set these both the same, it should start unless there's other
problems. And DO follow what Michael said, you really need to update
to 8.4.19 if not 9.3.latest.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs