daily pastebin goal
38%
SHARE
TWEET

Untitled

a guest Aug 10th, 2018 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Can not connect to local PostgreSQL
  2. PGError
  3. could not connect to server: Permission denied
  4.     Is the server running locally and accepting
  5.     connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
  6.    
  7. /opt/local/share/postgresql84/pg_hba.conf.sample
  8. /opt/local/var/macports/software/postgresql84/8.4.7_0/opt/local/share/postgresql84/pg_hba.conf.sample
  9. /usr/share/postgresql/pg_hba.conf.sample
  10.    
  11. 0    56     1   0 11:41AM ??         0:00.02 /opt/local/bin/daemondo --label=postgresql84-server --start-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql84-server/postgresql84-server.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql84-server/postgresql84-server.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql84-server/postgresql84-server.wrapper restart ; --pid=none
  12.   500   372     1   0 11:42AM ??         0:00.17 /opt/local/lib/postgresql84/bin/postgres -D /opt/local/var/db/postgresql84/defaultdb
  13.   500   766   372   0 11:43AM ??         0:00.37 postgres: writer process                                                                                                                                                                                                                                                                                                                  
  14.   500   767   372   0 11:43AM ??         0:00.24 postgres: wal writer process                                                                                                                                                                                                                                                                                                              
  15.   500   768   372   0 11:43AM ??         0:00.16 postgres: autovacuum launcher process                                                                                                                                                                                                                                                                                                      
  16.   500   769   372   0 11:43AM ??         0:00.08 postgres: stats collector process                                                                                                                                                                                                                                                                                                          
  17.   501  4497  1016   0 12:36PM ttys000    0:00.00 grep postgres
  18.    
  19. # postgresql.conf should contain...
  20. unix_socket_directory = '/var/run/postgresql'       # dont worry if yours is different
  21. #unix_socket_group = ''                             # default is fine here
  22. #unix_socket_permissions = 0777                     # check this one and uncomment if necessary.
  23.    
  24. psql: FATAL:  no pg_hba.conf entry for host "[local]", user "couling", database "main", SSL off
  25.    
  26. psql: FATAL:  password authentication failed for user "couling"
  27.    
  28. psql: could not connect to server: No such file or directory
  29.     Is the server running locally and accepting
  30.     connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
  31.    
  32. psql: could not connect to server: Connection refused
  33.     Is the server running locally and accepting
  34.     connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
  35.    
  36. psql: could not connect to server: Permission denied
  37.     Is the server running locally and accepting
  38.     connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top