Thread: BUG #8682: sqlstate = 28000
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 Operating system: win7 and xp Description: sql state = 28000 error. when the application starts. please reply with solution
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
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