Re: [PERFORM] syslog slowing the database? - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: [PERFORM] syslog slowing the database?
Date
Msg-id 40507DCA.8030609@commandprompt.com
Whole thread Raw
In response to Re: [PERFORM] syslog slowing the database?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
>>Not an option I'm afraid.  PostgreSQL just jams and stops logging after
>>the first rotation...

Are you using a copy truncate method to rotate the logs? In RedHat add
the keyword COPYTRUCATE to your /etc/logrotate.d/syslog file.

Sincerely,

Joshua D. Drake



>
>
> I know some people use this in production.  Dunno what went wrong in
> your test, but it can be made to work.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


Attachment

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [PERFORM] started Data Warehousing
Next
From: bdealhoy@sympatico.ca (Byrocat)
Date:
Subject: POrtability of ODBC and DBArtisan connection information