Unable to start postgres service

This document (7007242) is provided subject to the disclaimer at the end of this document.

Environment

Novell Data Synchronizer
SUSE Linux Enterprise Server 11

Situation

Unable to start postgres service
ERROR: "Starting PostgreSQLcould not start server " while starting postgres
"rcpostgresql status " output shows as unused
ps -aux | grep sql | grep -v grep does not show postgres running

Resolution

Troubleshooting Steps / Resolution:
  1. Edit /var/lib/pgsql/data/postgresql.conf .
  2. Change "silent_mode = on " to "silent_mode = off ". This would provide more information as to why is it failing
  3. Start postgresql by typing "rcpostgresql start " and press Enter
  4. Check if the following error is received. If yes, please follow the steps listed below the error
    2010-11-22 19:15:45 MST   WARNING:  could not create listen socket for "localhost"
    2010-11-22 19:15:45 MST   FATAL:  could not create any TCP/IP sockets
    • Edit /etc/hosts
    • Make sure the following line exists at the very top. If not add it before other statements.
      127.0.0.1           localhost
    • Edit /var/lib/pgsql/data/pg_hba.conf
    • Make sure the following lines exist in the file. The following lines are from a DataSync server. Some lines may differ if this is not a DataSync server.
      local all postgres ident sameuser
      host all postgres 127.0.0.1/32 ident sameuser
      host all postgres ::1/128 ident sameuser
      local   datasync         all                       md5
      host    datasync         all       127.0.0.1/32    md5
      host    datasync         all       ::1/128         md5
      local   postgres         datasync_user                    md5
      host    postgres         datasync_user    127.0.0.1/32    md5
      host    postgres         datasync_user    ::1/128         md5
      local   mobility    all                               md5
      host    mobility    all         127.0.0.1/32          md5
      host    mobility    all         ::1/128               md5
    • Restart the server.

Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7007242
  • Creation Date: 22-Nov-2010
  • Modified Date:03-Mar-2020
    • SUSE Linux Enterprise Server

< Back to Support Search

For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback@suse.com

SUSE Support Forums

Get your questions answered by experienced Sys Ops or interact with other SUSE community experts.

Join Our Community

Support Resources

Learn how to get the most from the technical support you receive with your SUSE Subscription, Premium Support, Academic Program, or Partner Program.


SUSE Customer Support Quick Reference Guide SUSE Technical Support Handbook Update Advisories
Support FAQ

Open an Incident

Open an incident with SUSE Technical Support, manage your subscriptions, download patches, or manage user access.

Go to Customer Center