Postgres configuration

• Creating Postgres databases
• Creating Postgres tablespaces
• postgresql.conf
  • postgres_conf_settings
  • shared_buffers
  • effective_cache_size
  • shared_preload_libraries
  • Making changes by hand
  • Generating postgresql.conf from scratch
• pg_hba.conf
• pg_ident.conf
• Configuring .pgpass
• The postgres Unix user
  • Shell configuration
  • SSH keys
  • TLS certificates
  • Username
• Creating Postgres users
  • Password generation