Search Postgresql Archives

Re: My postgres is not logging anymore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 18/06/2015 10:34, Maila Fatticcioni wrote:
> 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:

What have you got set for the following? - Here's what they're set to on
my laptop (Windows 7, PG 9.4):

log_destination = 'stderr'
logging_collector = on
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_file_mode = 0600
log_truncate_on_rotation = off
log_rotation_age = 1d
log_rotation_size = 10MB

The comments in postgresql.conf indicate that log_destintion and
logging_collector, at least, need to be set as above to generate log files.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux