Re: pg_database_size() and actual disk space usage - Mailing list pgsql-admin

From Vladimir Rusinov
Subject Re: pg_database_size() and actual disk space usage
Date
Msg-id CANjgnBteHV2RnUfYnpPubAB-xidEqgDiUzM6_vde=x1r0c0zMg@mail.gmail.com
Whole thread Raw
In response to Re: pg_database_size() and actual disk space usage  (Alexander Fortin <alexander.fortin@gmail.com>)
Responses Re: pg_database_size() and actual disk space usage  (Alexander Fortin <alexander.fortin@gmail.com>)
List pgsql-admin


On Fri, Mar 30, 2012 at 2:34 PM, Alexander Fortin <alexander.fortin@gmail.com> 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/

pgsql-admin by date:

Previous
From: Alexander Fortin
Date:
Subject: Re: pg_database_size() and actual disk space usage
Next
From: Alexander Fortin
Date:
Subject: Re: pg_database_size() and actual disk space usage