Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /usr/local/var/postgres
- SHOW data_directory;
- select setting from pg_settings where name = 'data_directory';
- -bash-3.2$ ps ax | grep postgres | grep -v postgres:
- 4698 ? S 9:59 /opt/PostgreSQL/8.4/bin/postgres -D /opt/PostgreSQL/8.4/data
- 6115 ? S 8:16 /opt/PostgreSQL/8.4/bin/postgres -D /opt/PostgreSQL/8.4/data_sums
- 30694 pts/9 S+ 0:00 grep postgres
- pg_lsclusters
- Version Cluster Port Status Owner Data directory Log file
- 8.4 main 5432 online postgres /home/adam/db/main/data /home/adam/db/main/log
- CONFIGURE = '--disable-debug' '--prefix=/usr/local/Cellar/postgresql/9.3.2'
- '--datadir=/usr/local/Cellar/postgresql/9.3.2/share/postgresql'
- '--docdir=/usr/local/Cellar/postgresql/9.3.2/share/doc/postgresql'
- '--enable-thread-safety' '--with-bonjour' '--with-gssapi' '--with-krb5'
- '--with-ldap' '--with-openssl' '--with-pam' '--with-libxml' '--with-libxslt'
- '--with-ossp-uuid' '--with-python' '--with-perl' '--with-tcl' 'CC=clang'
- 'CFLAGS=-I/usr/local/Cellar/ossp-uuid/1.6.2/include'
- 'LDFLAGS=-L/usr/local/Cellar/ossp-uuid/1.6.2/lib' 'LIBS=-luuid'
- base
- global
- pg_clog
- pg_hba.conf
- pg_ident.conf
- pg_log
- pg_multixact
- pg_notify
- pg_stat_tmp
- pg_subtrans
- pg_tblspc
- pg_twophase
- PG_VERSION
- pg_xlog
- postgresql.conf
- postmaster.opts
- stderr
- stdout
- sudo serveradmin settings postgres
- postgres:log_connections = "on"
- postgres:unix_socket_directory = "/private/var/pgsql_socket"
- postgres:listen_addresses = "127.0.0.1,::1"
- postgres:unix_socket_group = "_postgres"
- postgres:log_statement = "ddl"
- postgres:log_line_prefix = "%t "
- postgres:unix_socket_permissions = "0770"
- postgres:log_lock_waits = "on"
- postgres:logging_collector = "on"
- postgres:log_filename = "PostgreSQL.log"
- postgres:dataDir = "/Library/Server/PostgreSQL/Data"
- postgres:log_directory = "/Library/Logs/PostgreSQL"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement