[ale] Postgresql start issues

[Lightner, Jeff]

Last night we did some hardware maintenance on a server running Postgresql 9.1.3.

On trying to restart the DB afterwards we got:

LOG:  peer authentication is only supported on local sockets
CONTEXT:  line 86 of configuration file "/database/postgresql/pgsql/data/pg_hba.conf"
LOG:  peer authentication is only supported on local sockets
CONTEXT:  line 88 of configuration file "/database/postgresql/pgsql/data/pg_hba.conf"
FATAL:  could not load pg_hba.conf

/database/postgresql/pgsql being where we have the database instead of the default /var…

As a test we attempted to restart postgresql setup similarly on a test server and saw exactly the same issue.  The DBA at first blush found suggestion to use md5 startup rather than peer and it did start the DB but this morning we’re seeing some batch processes failing.

Line 86 and 88 of the configuration file are the “localhost” IPs for IPV4 and IPV6 respectively.   This file hasn’t been changed recently but it has been some months since the DB was last started previously.

Has anyone seen the above messages and do you have any suggestions as to how to resolve so that we’re not changing the start method?









Athena®, Created for the Cause™

Making a Difference in the Fight Against Breast Cancer





How and Why I Should Support Bottled Water!
Do not relinquish your right to choose bottled water as a healthy alternative to beverages that contain sugar, calories, etc. Your support of bottled water will make a difference! Your signatures count! Go to http://www.bottledwatermatters.org/luv-bottledwater-iframe/dswaters and sign a petition to support your right to always choose bottled water. Help fight federal and state issues, such as bottle deposits (or taxes) and organizations that want to ban the sale of bottled water. Support community curbside recycling programs. Support bottled water as a healthy way to maintain proper hydration. Our goal is 50,000 signatures. Share this petition with your friends and family today!



---------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.
----------------------------------


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.ale.org/pipermail/ale/attachments/20121005/555c7f70/attachment.html