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 10

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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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 10

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Where to place postgres JDBC driver jar on tomcat 8 71
Understanding ping command in Ubuntu 5 66
sed replace command 12 30
Lenovo server installtion 1 29
Many people tend to confuse the function of a virus with the one of adware, this misunderstanding of the basic of what each software is and how it operates causes users and organizations to take the wrong security measures that would protect them ag…
Sometimes a user will call me frantically, explaining that something has gone wrong and they have tried everything (read - they have messed it up more and now need someone to clean up) and it still does no good, can I help them?!  Usually the standa…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

751 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