On Jun 11, 2007, at 11:41 PM, Joe Barwell wrote:
OK, it installed fine, restarted fine, but postgres does not appear in Activity Monitor. I can't use Creat User in the Client tools (or any other tool). It says: Database connection failed: could not connect to server: Connection refused Is the server running on host "localhost" and accepting TCP/IP connections on port 5432?
See if there is an error message in the console log (/Applications/ Utilities/Console). The startup command was:
su -m postgres -c '/Library/PostgreSQL8/bin/pg_ctl start -D /Library/ PostgreSQL8/data -l /Library/PostgreSQL8/log/PostgreSQL8.log -o -i'
Is there a valid cluster created in /Library/PostgreSQL8/data? You should also be able find what went wrong by looking in the PostgreSQL log file which is the path specified by -l above.
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
