Skip navigation

postgresql connection other than "trust"?

622 Views 2 Replies Latest reply: Jun 11, 2013 7:03 AM by deivy RSS
Todd Heberlein1 Level 1 Level 1 (30 points)
Currently Being Moderated
Feb 22, 2013 2:50 PM

I am having troubles setting PostgreSQL to accept more secure network connections.


On my Mountain Lion system with Server.app I am trying to start my own copy of PostgreSQL running. Running the command


$ sudo serveradmin start postgres


gets things up and running, I can connect locally with psql.


But...  if I go into the file


/Library/Server/PostgreSQL/Data/pg_hba.conf


and change the line


host    all             all             127.0.0.1/32            trust


to


host    all             all             127.0.0.1/32            md5


or anything other than "trust", I get the error message


$ sudo serveradmin start postgres

postgres:error = "CANNOT_START_SERVICE_TIMEOUT_ERR"


I initially got this error message when trying to change the file org.postgresql.postgres.plist and pg_hba.conf to accept network connection from other hosts. I could get this, but only if the METHOD is set to "trust", which doesn't seem like a good idea.


Any idea how to configure org.postgresql.postgres.plist and pg_hba.conf on OS X 10.8 with Server.app such that I can have a more secure connections?


Thanks,

Mac Pro, OS X Mountain Lion (10.8.2)
  • deivy Level 4 Level 4 (2,365 points)
    Currently Being Moderated
    Jun 11, 2013 7:03 AM (in response to Todd Heberlein1)

    Todd, when you get messages:

     

    `postgres:error = "CANNOT_START_SERVICE_TIMEOUT_ERR" '

     

    and

     

    ` postgres:postgresIsResponding = no '

     

    are your wiki and webpages working?

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.