Skip site navigation (1) Skip section navigation (2)

Re: pg_database_size() and actual disk space usage

From: Alexander Fortin <alexander(dot)fortin(at)gmail(dot)com>
To: Vladimir Rusinov <vladimir(at)greenmice(dot)info>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_database_size() and actual disk space usage
Date: 2012-03-30 10:45:09
Message-ID: 4F758EB5.30005@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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/

In response to

pgsql-admin by date

Next:From: Eric SimonDate: 2012-03-30 16:20:44
Subject: Warnings in Standby Logs
Previous:From: Vladimir RusinovDate: 2012-03-30 10:39:16
Subject: Re: pg_database_size() and actual disk space usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group