Re: BUG #8682: sqlstate = 28000

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: arjsia(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8682: sqlstate = 28000
Date: 2013-12-15 02:24:44
Message-ID: CAB7nPqThPMCY3CVb2V=KuG5kLcXGWzJKfTj3iPVKn-e5gVmu2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, Dec 14, 2013 at 3:59 PM, <arjsia(at)gmail(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8682
> Logged by: abhay jadhav
> Email address: arjsia(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2013-12-15 07:20:08 Re: BUG #8682: sqlstate = 28000
Previous Message arjsia 2013-12-14 06:59:28 BUG #8682: sqlstate = 28000