2 questions - Mailing list pgsql-general

From anj patnaik
Subject 2 questions
Date
Msg-id CAEQKwSkz2NbfbHQe-c39YMZUZ14t-pAsTjUwEZ5p0a4oxDviOw@mail.gmail.com
Whole thread Raw
Responses Re: 2 questions
Re: 2 questions
List pgsql-general
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Old source code needed
Next
From: Ramesh T
Date:
Subject: Re: Taking lot time