Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ## Postgresql
- Clean config
- cat postgresql.conf.bak | grep -Pv "(^#)|^$" | sed 's/#.*$//g' | sed '/^\s*$/d'
- Add path to postgres
- echo 'pathmunge /usr/pgsql-9.6/bin/' > /etc/profile.d/postgres.sh
- . /etc/profile
- Minimal postgres 9.6 config
- max_connections = 100
- shared_buffers = 128MB
- dynamic_shared_memory_type = posix
- log_destination = 'stderr'
- logging_collector = on
- log_directory = 'pg_log'
- log_filename = 'postgresql-%a.log'
- log_truncate_on_rotation = on
- log_rotation_age = 1d
- log_rotation_size = 0
- log_line_prefix = '< %m > '
- log_timezone = 'W-SU'
- datestyle = 'iso, mdy'
- timezone = 'W-SU'
- lc_messages = 'en_US.UTF-8'
- lc_monetary = 'en_US.UTF-8'
- lc_numeric = 'en_US.UTF-8'
- lc_time = 'en_US.UTF-8'
- default_text_search_config = 'pg_catalog.english'
- listen_addresses = '*'
- #replication
- wal_level = hot_standby
- wal_log_hints = on
- max_wal_senders = 8
- wal_keep_segments = 64
- hot_standby = on
- minimal recovery.conf
- standby_mode = 'on'
- primary_conninfo = 'user=postgres host=master port=5432 sslmode=prefer sslcompression=1 krbsrvname=postgres'
- pg_basebackup
- pg_basebackup -P -X stream -R -D data/ -h master
Add Comment
Please, Sign In to add comment