Re: BUG #8682: sqlstate = 28000 - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #8682: sqlstate = 28000
Date
Msg-id CAB7nPqThPMCY3CVb2V=KuG5kLcXGWzJKfTj3iPVKn-e5gVmu2A@mail.gmail.com
Whole thread Raw
In response to BUG #8682: sqlstate = 28000  (arjsia@gmail.com)
Responses Re: BUG #8682: sqlstate = 28000
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: arjsia@gmail.com
Date:
Subject: BUG #8682: sqlstate = 28000
Next
From: John R Pierce
Date:
Subject: Re: BUG #8682: sqlstate = 28000