Monday 15 August 2011

postgresql - Mac OSX Lion Postgres does not accept connections on /tmp/.s.PGSQL.5432 -


I get a common Mac OSX error for postgrad's homebrew installations,

  Do not have to accept the server and connection running locally on such a file or directory on Unicode domain socket "/tmp/.s.PGSQL.5432"?   

This is clearly due to multiple installs on the system. However, the general steps are not resolved.

I can successfully start a postgrace and are running:

  ps auxw | Grep post   

returns ..

  euanmillar 847 0.0 0.0 2432768 588 s000 R + 11:19 am 0: 00.00 grep Postgraduation euanmillar 845 0.0 0.0 2439324 448 ?? SS 11:19 AM 0: 00.00 Postgres: Statistics Collector's Process EonMiller 844 0.0 0.0 2443176 1520 ?? SS 11:19 AM 0: 00.00 Postgres: Autovoke Launcher Process EonMiller 843 0.0 0.0 2443044 544 ?? SS 11:19 am 0: 00.00 Postgresge: Wall Author Process EuMiller 842 0.0 0.0 2443044 584 ?? SS 11:19 AM 0: 00.00 Postgrad: Author Process EonMiller 841 0.0 0.0 2443044 596 ?? SS 11:19 AM 0: 00.00 Postgres: Checkpoint Process EonMiller 839 0.0 0.0 2443044 3616 s000 S 11:19 am 0: 00.02 / us   

So it looks like post-grace is going on is.

I have commented in the following lines in postgresql.conf

  port = 5432 unix_socket_directory = '/ var / pgsql_socket' unix_socket_permissions = 0777   

And in var / pgsql_socket / I have a hidden file. PGSQL.5432

I have tried to solve many posts here. It looks particularly like this:

But the difference is that I have There is a '/ var / pgsql_socket' directory which is CHOWN-ed for everyone. I have used the homebrew to completely remove and install Postgres and yet I have the same problem.

You need to remove the postmaster.pid, which should be in the following path: / Usr / local / var / postgres / postmaster.pid

No comments:

Post a Comment