Postgres 8.3.15 will not start

[evil gensis]

Getting this message in PT3 when i start it up

Unable to create PostgreSQL database: PT3_2011_05_26_172106
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"?

[evil gensis]

In Terminal:

sudo chmod -R 700/Library/PostgreSQL/8.4/
usage: chmod [-fhv] [-R [-H | -L | -P]] [-a | +a | =a [i][# [ n]]] mode|entry file ...
chmod [-fhv] [-R [-H | -L | -P]] [-E | -C | -N | -i | -I] file ...

[kraada]

This time the typo is yours - there's a space between 700 and /Library/PostgreSQL/8.4/.

[evil gensis]

It looked like it switched everything back but it still is not working and getting the same errors?
This literally worked yesterday and only reason I changed access was to submit a log for a ticket but the webpage kept freezing for me so I was unable to do so.

[kraada]

The access settings must be in the original state in order for the server to start properly - otherwise it errors out with the information you've seen. The -R flag should have set those permissions recursively - are you sure the error when attempting to start the server is completely identical (make sure the date is new when looking at the Console - the old error will still be there).

[evil gensis]

5/26/11 6:22:04 PM com.apple.launchd[1] (com.edb.launchd.postgresql-8.4[1960]) Exited with exit code: 1

5/26/11 6:22:08 PM com.apple.launchd.peruser.501[92] ([0x0-0x61061].com.pokertracker.pokertracker3[1946]) Job appears to have crashed: Bus error

5/26/11 6:22:08 PM ReportCrash[1961] Saved crash report for PokerTracker[1946] version ??? (3.0) to /Users/ttossona/Library/Logs/DiagnosticReports/PokerTracker_2011-05-26-182208_"User"-iMac.crash

5/26/11 6:22:14 PM com.apple.launchd[1] (com.edb.launchd.postgresql-8.4[1965]) posix_spawn("/Library/PostgreSQL/8.4//bin/postmaster", ...): No such file or directory

5/26/11 6:22:14 PM com.apple.launchd[1] (com.edb.launchd.postgresql-8.4) Throttling respawn: Will start in 10 seconds

These are the errors in Console but PT3 is acting the same as it has been since the error.

[kraada]

That seems to be saying that it can't even find your PostgreSQL startup files. Did you delete anything in the PostgreSQL's bin directory?

[evil gensis]

No not at all. I copied one log file and tried uploading it into an email to be looked at but that never worked. What are my options I am losing a database with 500K+ Hands 3-4 years of data.
The only thing that was odd when I went into the "get info" for the data folder.. there was a user "dameon" or something like that and that user wasn't in any other files just that one. I am the only user of this Mac.

[tarix]

The easiest way to solve this is to just upgrade. You will not lose any existing data doing this.

1) Download PostgreSQL 8.4.8-1 (Mac)
2) Double-click the dmg file and it will open up a new finder window.
3) Double-click the installer postgresql-8.4.8-1-osx
4) If you get a warning click open and if you are prompted for your admin password enter it.
5) Click "Next >" about four times, then wait for it to install.
6) Uncheck the "Launch Stack Builder?" at exit checkbox.
7) Click Finish.

If everything completed with no errors you should be able to run PT3 as normal. Note you can reinstall PostgreSQL as much as you want and it will not delete your data as long as you never uninstall first.

If you continue to have trouble please post the last few entries from your Console log again.

[evil gensis]

I followed all of those steps and everything was successful, but PT3 is still having the same errors. Here are the log errors:
5/31/11 2:31:58 PM com.apple.launchd.peruser.501[92] ([0x0-0x257257].com.pokertracker.pokertracker3[44068]) Job appears to have crashed: Bus error
5/31/11 2:31:58 PM ReportCrash[44062] Saved crash report for PokerTracker[44068] version ??? (3.0) to /Users/ttossona/Library/Logs/DiagnosticReports/PokerTracker_2011-05-31-143158_A***-iMac.crash
5/31/11 2:32:05 PM com.apple.launchd[1] (com.edb.launchd.postgresql-8.4[44081]) posix_spawn("/Library/PostgreSQL/8.4//bin/postmaster", ...): No such file or directory
5/31/11 2:32:05 PM com.apple.launchd[1] (com.edb.launchd.postgresql-8.4[44081]) posix_spawn("/Library/PostgreSQL/8.4//bin/postmaster", ...): No such file or directory
5/31/11 2:32:05 PM com.apple.launchd[1] (com.edb.launchd.postgresql-8.4[44081]) Exited with exit code: 1

5/31/11 2:32:05 PM com.apple.launchd[1] (com.edb.launchd.postgresql-8.4) Throttling respawn: Will start in 10 seconds