Advertisement
Guest User

Untitled

a guest
Nov 23rd, 2014
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. /usr/local/var/postgres
  2.  
  3. SHOW data_directory;
  4.  
  5. select setting from pg_settings where name = 'data_directory';
  6.  
  7. -bash-3.2$ ps ax | grep postgres | grep -v postgres:
  8. 4698 ? S 9:59 /opt/PostgreSQL/8.4/bin/postgres -D /opt/PostgreSQL/8.4/data
  9. 6115 ? S 8:16 /opt/PostgreSQL/8.4/bin/postgres -D /opt/PostgreSQL/8.4/data_sums
  10. 30694 pts/9 S+ 0:00 grep postgres
  11.  
  12. pg_lsclusters
  13. Version Cluster Port Status Owner Data directory Log file
  14. 8.4 main 5432 online postgres /home/adam/db/main/data /home/adam/db/main/log
  15.  
  16. CONFIGURE = '--disable-debug' '--prefix=/usr/local/Cellar/postgresql/9.3.2'
  17. '--datadir=/usr/local/Cellar/postgresql/9.3.2/share/postgresql'
  18. '--docdir=/usr/local/Cellar/postgresql/9.3.2/share/doc/postgresql'
  19. '--enable-thread-safety' '--with-bonjour' '--with-gssapi' '--with-krb5'
  20. '--with-ldap' '--with-openssl' '--with-pam' '--with-libxml' '--with-libxslt'
  21. '--with-ossp-uuid' '--with-python' '--with-perl' '--with-tcl' 'CC=clang'
  22. 'CFLAGS=-I/usr/local/Cellar/ossp-uuid/1.6.2/include'
  23. 'LDFLAGS=-L/usr/local/Cellar/ossp-uuid/1.6.2/lib' 'LIBS=-luuid'
  24.  
  25. base
  26. global
  27. pg_clog
  28. pg_hba.conf
  29. pg_ident.conf
  30. pg_log
  31. pg_multixact
  32. pg_notify
  33. pg_stat_tmp
  34. pg_subtrans
  35. pg_tblspc
  36. pg_twophase
  37. PG_VERSION
  38. pg_xlog
  39. postgresql.conf
  40. postmaster.opts
  41. stderr
  42. stdout
  43.  
  44. sudo serveradmin settings postgres
  45.  
  46. postgres:log_connections = "on"
  47. postgres:unix_socket_directory = "/private/var/pgsql_socket"
  48. postgres:listen_addresses = "127.0.0.1,::1"
  49. postgres:unix_socket_group = "_postgres"
  50. postgres:log_statement = "ddl"
  51. postgres:log_line_prefix = "%t "
  52. postgres:unix_socket_permissions = "0770"
  53. postgres:log_lock_waits = "on"
  54. postgres:logging_collector = "on"
  55. postgres:log_filename = "PostgreSQL.log"
  56. postgres:dataDir = "/Library/Server/PostgreSQL/Data"
  57. postgres:log_directory = "/Library/Logs/PostgreSQL"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement