Problem to login

Posted on 2014-07-20
Last Modified: 2014-07-23
I now login as "postgres" user to the Cent OS 6.5 server but I've got the attached problem

Question by:HuaMinChen
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
LVL 35

Expert Comment

by:Gary Patterson
ID: 40207378
Nothing attached.
LVL 11

Author Comment

ID: 40207388
Please see this
LVL 35

Expert Comment

by:Gary Patterson
ID: 40207400
Looks like a common problem.  

Several troubleshooting options for this popped up with a quick search.  Did you try just doing a Google search on the error message?  

That's often a great first troubleshooting step.

The issue seems to be related to security, but there seem to be a variety of different fixes.  These threads have a lot of narrative on the problem and possible resolutions - too much to reproduce here.  I suggest you review them, try the most common, and let us know what you've tried.  I combed through the top search responses and selected these, which seem to contain the most valuable troubleshooting information.  I hope you find it useful.

- Gary
Are You Using the Best Web Development Editor?

The worlds of web hosting and web development are constantly evolving. Every year we see design trends change, coding standards adapt and new frameworks/CMS created. With such a quick pace of change it’s easy to get lost trying to keep up.

See if your editor made the list.

LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40207405
Try deleting that file as root or move it as root to something else:

#mv /var/lib/pgsql/.ICEauthority /var/tmp

The relogin as postgres
LVL 11

Expert Comment

by:Joseph O'Loughlin
ID: 40207746
You should not normally be logging into a service account
LVL 11

Author Comment

ID: 40208083
Thanks all.
does it mean it is of no meaning to login as user "postgres"?
LVL 11

Accepted Solution

Joseph O'Loughlin earned 190 total points
ID: 40208103
You will have administrative/root rights to the postgres database

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows 7 does not have the best desktop search built in. This is something Windows 7 users have struggled with. You type something in, and your search results don’t always match what you are looking for, or it doesn’t actually work at all. There ar…
In this article we will discuss all things related to StageFright bug, the most vulnerable bug of android devices.
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question