Thread: PostgreSQL doesn't log
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 # min 128kB
dynamic_shared_memory_type = posix # the default is the first option
logging_collector = on # Enable capturing of stderr and csvlog
log_directory = '/tmp' # directory where log files are written,
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
log_file_mode = 0644 # creation mode for log files,
log_error_verbosity = verbose # terse, default, or verbose messages
log_statement = 'all' # none, ddl, mod, all
log_timezone = 'Asia/Jakarta'
datestyle = 'iso, dmy'
timezone = 'Asia/Jakarta'
lc_messages = 'en_CA.UTF-8' # locale for system error message
lc_monetary = 'en_CA.UTF-8' # locale for monetary formatting
lc_numeric = 'en_CA.UTF-8' # locale for number formatting
lc_time = 'en_CA.UTF-8' # locale for time formatting
default_text_search_config = 'pg_catalog.english'
then restart or reload the service:
sudo systemctl restart postgresql
sudo systemctl reload postgresql
the /tmp
permission:
$ ll /tmp/
total 11656
drwxrwxrwt 22 root root 580 Jun 29 10:05 ./
drwxr-xr-x 17 root root 4096 Jun 10 08:04 ../
...
the /tmp
usage:
$ df | grep /tmp
tmpfs 8159996 31204 8128792 1% /tmp
doing some query on psql
, but the /tmp/postgresql-*
still doesn't show up. What can I do to find which part that prevent log from being created?
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.
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@commandprompt.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
Kiswono P
GB