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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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