Re: 2 questions - Mailing list pgsql-general

On 11/25/2015 10:28 AM, anj patnaik wrote:
> 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.

Define 'setup with NFS'.

So are you saying this how you set up the old instance or how you are
setting up the new VM?

>
> 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.

Where is Postgres installed now?

Not entirely following, but I hope you are not asking if two Postgres
installs can share the same NFS mount? That will end badly.


It might help if you give a schematic description of what you are trying
to achieve.

>
> 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?

What I do is keep the previous 2 days of files as written and then keep
compressed files older then that to some period of time. The files
compress a good bit so it works well for me. This is done via a cron
script that runs each night.

>
> 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.

So what are the errors?

As to 'terse':

http://www.postgresql.org/docs/9.4/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
log_error_verbosity (enum)

     Controls the amount of detail written in the server log for each
message that is logged. Valid values are TERSE, DEFAULT, and VERBOSE,
each adding more fields to displayed messages. TERSE excludes the
logging of DETAIL, HINT, QUERY, and CONTEXT error information. VERBOSE
output includes the SQLSTATE error code (see also Appendix A) and the
source code file name, function name, and line number that generated the
error. Only superusers can change this setting.


You lose a lot of valuable information this way. I would go with Albe's
suggestion and change log_min_error_statement.


>
> 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.
>


--
Adrian Klaver
adrian.klaver@aklaver.com