Message-ID: <4F758EB5.30005@gmail.com>
Date: Fri, 30 Mar 2012 12:45:09 +0200
From: Alexander Fortin <alexander.fortin@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
	rv:11.0) Gecko/20120327 Thunderbird/11.0.1
MIME-Version: 1.0
To: Vladimir Rusinov <vladimir@greenmice.info>
CC: pgsql-admin@postgresql.org
Subject: Re: pg_database_size() and actual disk space usage
References: <4F742D3A.8010501@gmail.com>
	<CA+h6AhgGgREbgpt2bobXUzunppWRbgii2TYMSksSbeYouM9Agg@mail.gmail.com>
	<4F743C47.1040907@gmail.com> <4F746282.3060406@innogames.de>
	<4F755EBE.2070908@gmail.com> <4F758796.6090000@innogames.de>
	<4F758C45.3000704@gmail.com>
	<CANjgnBteHV2RnUfYnpPubAB-xidEqgDiUzM6_vde=x1r0c0zMg@mail.gmail.com>
In-Reply-To: 
 <CANjgnBteHV2RnUfYnpPubAB-xidEqgDiUzM6_vde=x1r0c0zMg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

On 3/30/12 12:39 PM, Vladimir Rusinov wrote:
> Are you rotating postgresql log files? If so, how do you do that?
> 
> Do you have archive_command set in postgresql.conf?

Hi Vladimir.

Yes, I'm using the packaged Postgres 9.1.2 version shipped with Ubuntu
11.10. From my understanding, it's logrotate that does the job, given
that the package postgresql-common creates an entry for daily
/var/log/postgresql/*.log rotation.

As for the archive_command, no, it's defaulted to empty:
#archive_command = ''

-- 
Alexander Fortin
http://about.me/alexanderfortin/