From: | Maila Fatticcioni <mfatticcioni(at)mbigroup(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | My postgres is not logging anymore |
Date: | 2015-06-18 09:34:37 |
Message-ID: | 558290AD.5040809@mbigroup.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello.
I have a postgres cluster made by two nodes with OS Ubuntu 14.04.
About two weeks ago I did a minor update of postgres to the version
9.4.1-1.pgdg70+1. After I had to shutdown the machines and I could
start them just last week.
Since then postgresql has been stopping logging on both nodes. If I
destroy the log file and I do a restart, a new file is created but it
remains empty. I have tried to change some configuration parameters
with no success. I have tried to restart postgres on both nodes and
relocate the service as well - nothing. Apart from this everything is
working fine and my applications don't show any errors during the
connection to the database. Any ideas about how to have back the log?
Here my configuration file postgresql.conf:
- ---------------------------------------------------------
listen_addresses = '*'
work_mem = 32MB
wal_level = 'hot_standby'
synchronous_commit = on
checkpoint_segments = 128
checkpoint_completion_target = 0.9
archive_mode = on
archive_command = 'rsync -e ssh -a %p
postgres(at)172(dot)31(dot)7(dot)1:/var/lib/postgresql/pg_archive/%f'
max_wal_senders = 5
wal_keep_segments = 32
hot_standby = on
max_standby_streaming_delay = 30s
wal_receiver_status_interval = 2s
hot_standby_feedback = on
log_min_messages = error
log_min_error_statement = error
log_min_duration_statement = 10000
log_connections = on
log_disconnections = on
log_duration = on
log_error_verbosity = terse
log_statement = 'all'
log_timezone = 'localtime'
datestyle = 'iso, mdy'
timezone = 'localtime'
default_text_search_config = 'pg_catalog.english'
restart_after_crash = off
- ---------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)
iEYEARECAAYFAlWCkK0ACgkQi2q3wPb3FcM84ACfQVc4mMWLx/c9cSEBPFsmvDia
vLEAoMj+nWBOueJwM3eafcx8AfMMYcUl
=Gkgk
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2015-06-18 09:48:18 | Re: My postgres is not logging anymore |
Previous Message | Piotr Gackiewicz | 2015-06-18 08:58:35 | Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux |