cannot connect to server after changing for network access

[mmumma]

I have followed the instructions under viewtopic.php?f=45&t=4638#p21987 how to configure for network access. After making the changes, I am unable to stop/start/restart database. PT3 obviously won't start because it cannot connect to the database. I tried the SQL Shell.app and got the following:

Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
WARNING: password file "/Users/xxxxxxx/.pgpass" has group or world access; permissions should be u=rw (0600) or less
psql: could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

Press <return> to continue...

There is no file called .pgpass and if I try to look at it with PGAdmin III it shows a blank file. Would greatly appreciate any help. Been searching this forum nonstop!

Thanks,

Mike

Oh yeah, for the record, I did reboot also...

[kraada]

The pgpass warning just means the file wasn't used - if you didn't try to set one up, you can ignore the warning safely.

What happens when you try to restart the server?

[mmumma]

Sorry I didn't make that clear. With SQL shell I hit return and it says:

logout
[process completed]

With the Start Server.app it takes about a minute and then says:

Command exited with non-zero status.

Thanks in advance for the help.

[WhiteRider]

If you undo your changes to the config file, does it work then?

[mmumma]

Sorry it's taking me so long to answer. I was out of the house. I undid the single change I made to pg_hba.conf, removed that line, saved it. Still won't start. Same messages.

[WhiteRider]

Have you tried rebooting? That often fixes postgres issues like this..

[mmumma]

I tried rebooting before, but just tried again, no change.

[mmumma]

I suppose I could reinstall from scratch, but I spent a lot of time get hand histories and tournament results in the database, hate to just lose them -- especially since ultimately I still want to try to run it over the network.

[WhiteRider]

I'm sure you won't need to re-install, but even if you do you don't need to lose your databases.
Kraada (and others) know more about postgres than I do, so I'm going to have to leave it to them, I'm afraid - it's bedtime for me now.

[mmumma]

Thank you for trying. I'll wait for kraada.