Installation

• ./configure ; make ; make install
• Defaults:
• Installation directory: /usr/local/pgsql
• Port: 5432
• Adding compile time features:
• --enable-locale, --enable-multibyte, --enable-nls
• --enable-debug
• --with-pgport
• --with-(perl|python|java|tcl)
• --with-krb(4|5)
• --with-openssl
• --with-odbc
• --enable-syslog
• Selecting a database superuser
• Initialising the database cluster (ie, table space)

Runtime configuration

• Database configuration: postgresql.conf
• logging/debugging:
• debug_level
• debug_print_query
• log_connections
• log_timestamp
• performance tuning:
• shared_buffers
• sort_mem
• write ahead log:
• wal_files
• wal_buffers
• general:
• max_connections
• port
• tcpip_socket
• virtual_host
• Authentication configuration: pg_hba.conf, pg_ident.conf

Server state manipulation:

• pg_ctl

Hot backup:

• pg_dump

Interactive console:

• psql

Prev

Next