PostgreSQL on Mac unable to login to database

[kraada]

Please type the following at a Terminal and paste the results here:

ps aux | grep -i postgres

[clartann]

1546 0.1 0.0 2435120 544 s000 S+ 11:50pm 0:00.00 grep -i postgres

[kraada]

PostgreSQL is not installed successfully. Please try reinstalling it manually using this link.

[benegizer]

I just encountered the same problem with the same error message. (Also on a mac running Mountain Lion)

Two things may have caused it. one, I I accidentally deleted the PostgreSQL user, and another thing that might have caused it was I had to reset my spotlight index (having problems with Time Machine)

I re-downloaded PostgreSQL, and installed it (now the PostgreSQL user is present at the login screen when I restart) but I still get the same error message. When I try to create a new one i get

Unable to create PostgreSQL database: PT3_2013_10_22_002537
Reason: Unable to login to database (template1). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

When I try to browse I get

Unable to login to database (template1) Reason: could not connect to server: No such file or directory Is the server running locally and excepting connections on UNIX domain socket "/tmp/.s.PGSQL.5432"?

any ideas?


thanks in advance.

[kraada]

Open Applications -> Utilities -> Console; do you see errors listed for PostgreSQL there? If so, what do they say?

[benegizer]

com.apple.launchd.peruser.501 (0x0-0xe80e].com.pokertracker.pokertracker3[1800]) Job appears to have crashed: Bus error: 10

Then next is the report crash

[kraada]

But you don't see anything for PostgreSQL?

[benegizer]

nope. But let me open it up and try again

[benegizer]

10/22/13 10:53:47.370 PM com.apple.launchd[1]: (com.edb.launchd.postgresql-9.0[18999]) Exited with code: 2
10/22/13 10:53:47.370 PM com.apple.launchd[1]: (com.edb.launchd.postgresql-9.0) Throttling respawn: Will start in 10 seconds
10/22/13 10:53:57.381 PM com.apple.launchd[1]: (com.edb.launchd.postgresql-9.0[19000]) Exited with code: 2
10/22/13 10:53:57.381 PM com.apple.launchd[1]: (com.edb.launchd.postgresql-9.0) Throttling respawn: Will start in 10 seconds
10/22/13 10:54:07.392 PM com.apple.launchd[1]: (com.edb.launchd.postgresql-9.0[19002]) Exited with code: 2
10/22/13 10:54:07.392 PM com.apple.launchd[1]: (com.edb.launchd.postgresql-9.0) Throttling respawn: Will start in 10 seconds

[kraada]

Ok, that means that something is keeping it from starting up. Open up the last file in /Library/PostgreSQL/9.0/data/pg_log and paste the contents here please.