Re: pg_database_size() and actual disk space usage

[Vladimir Rusinov <vladimir@xxxxxxxxxxxxxx>]

On Fri, Mar 30, 2012 at 2:34 PM, Alexander Fortin <alexander.fortin@xxxxxxxxx> wrote:

On 3/30/12 12:14 PM, Bernhard Schrader wrote:

 

# df -h /var/lib/postgresql

Filesystem            Size  Used Avail Use% Mounted on
/dev/md_d0            128G   44G   85G  35% /var/lib/postgresql

# /etc/init.d/postgresql stop
 * Stopping PostgreSQL 9.1 database server
  ...done.

# df -h /var/lib/postgresql
Filesystem            Size  Used Avail Use% Mounted on
/dev/md_d0            128G   36G   93G  28% /var/lib/postgresql


so, with Postgres shut down, numbers get back to make sense to me.

Are you rotating postgresql log files? If so, how do you do that?

Do you have archive_command set in postgresql.conf?

-- 
Vladimir Rusinov
http://greenmice.info/