02) Replication PITR

Created mercredi 17 février 2016

1 archive_mode = on
2   archive_command = 'cp %p /pgarchive/%f'
3   wal_level = 'archive'

Setup a server log file rotation. (7 days or 10MB, whichever comes first)

1   log_directory = '/pgcluster/log'
2   log_filename = 'postgresql-%Y%m%d_%H%M%S.log'
3   log_rotation_age = 7d
4   log_rotation_size = 10MB
5   log_truncate_on_rotation = off
6   log_line_prefix = '%t c%  '

Gather connection information in server log file.

1 log_connections = on
2 log_disconnections = on

Log DDL transactions.

1 log_statement = 'ddl'

Enable SSL traffic.

1 ssl = on
2  ssl_ciphers = 'ALL'