Re: PostgreSQL doesn't log

log_destination is commented:

$ sudo cat /var/lib/postgres/data/postgresql.conf | grep log_des
#log_destination = 'stderr' # Valid values are combinations of

# SELECT name, setting FROM pg_settings WHERE name LIKE '%log%';
name | setting
-----------------------------+--------------------------------
log_autovacuum_min_duration | -1
log_checkpoints | off
log_connections | off
log_destination | stderr
log_directory | /tmp
log_disconnections | off
log_duration | off
log_error_verbosity | verbose
log_executor_stats | off
log_file_mode | 0644
log_filename | postgresql-%Y-%m-%d_%H%M%S.log
log_hostname | off
log_line_prefix |
log_lock_waits | off
log_min_duration_statement | -1
log_min_error_statement | error
log_min_messages | warning
log_parser_stats | off
log_planner_stats | off
log_rotation_age | 1440
log_rotation_size | 10240
log_statement | all
log_statement_stats | off
log_temp_files | -1
log_timezone | Asia/Jakarta
log_truncate_on_rotation | off
logging_collector | on
syslog_facility | local0
syslog_ident | postgres
wal_log_hints | off
(30 rows)

On 1 July 2015 at 08:12, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:

>
> On 06/30/2015 06:07 PM, Kiswono Prayogo wrote:
>
>> I'm using |ArchLinux| and |PostgreSQL| 9.4.4 and have enabled the
>> logging in the config file:
>>
>> |$ sudo egrep-v"^[[:blank:]]*($|#|//|/\*| \*|\*/)"
>> /var/lib/postgres/data/postgresql.conf
>>
>> max_connections= 1024 # (change requires restart)
>> shared_buffers= 128MB# min128kB
>> dynamic_shared_memory_type= posix# thedefault is the firstoption
>> logging_collector= on # Enable capturingof stderrand csvlog
>>
>
> Where is log_destination?
>
> JD
>
> --
> Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
> PostgreSQL Centered full stack support, consulting and development.
> Announcing "I'm offended" is basically telling the world you can't
> control your own emotions, so everyone else should do it for you.
>

--
Best Regards,
Kiswono P
GB