Hello all,
I've got 2 more questions. The cron job is now setup and email gets generated with proper body.
I've one setup with NFS which appears to work smoothly. Now soon, I will be given a Linux VM on a different physical server, but will retain my NFS mount. I've installed Postgres 9.4 using the graphical installer and specified the directory for the nfs mount.
1) When I move to the new VM, can I keep using that NFS mount without having to do a re-install of PG? This would be a different physical machine.
2) I have a cron job that deletes log files older than 10 days, but I am noticing rather large log files. Is there a way to limit the size of log files?
users do upserts and they are valid, but those are getting dumped as error statements. I set the verbosity to "terse", but still seeing lots of log output.
My settings are as follows:
postgres=# select name,setting,unit from pg_settings where name like '%log%';
name | setting | unit
-----------------------------+--------------------------------+------
log_autovacuum_min_duration | -1 | ms
log_checkpoints | off |
log_connections | off |
log_destination | stderr |
log_directory | pg_log |
log_disconnections | off |
log_duration | off |
log_error_verbosity | terse |
log_executor_stats | off |
log_file_mode | 0600 |
log_filename | postgresql-%Y-%m-%d_%H%M%S.log |
log_hostname | off |
log_line_prefix | %t |
log_lock_waits | off |
log_min_duration_statement | -1 | ms
log_min_error_statement | error |
log_min_messages | error |
log_parser_stats | off |
log_planner_stats | off |
log_rotation_age | 1440 | min
log_rotation_size | 10240 | kB
log_statement | none |
log_statement_stats | off |
log_temp_files | -1 | kB
log_timezone | EST5EDT |
log_truncate_on_rotation | off |
logging_collector | on |
syslog_facility | local0 |
syslog_ident | postgres |
wal_log_hints | off |
(30 rows)
postgres=#
Thank you.
