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

Re: pg_database_size() and actual disk space usage

From: Vladimir Rusinov <vladimir(at)greenmice(dot)info>
To: Alexander Fortin <alexander(dot)fortin(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_database_size() and actual disk space usage
Date: 2012-03-30 10:39:16
Message-ID: CANjgnBteHV2RnUfYnpPubAB-xidEqgDiUzM6_vde=x1r0c0zMg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, Mar 30, 2012 at 2:34 PM, Alexander Fortin <
alexander(dot)fortin(at)gmail(dot)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/

In response to

Responses

pgsql-admin by date

Next:From: Alexander FortinDate: 2012-03-30 10:45:09
Subject: Re: pg_database_size() and actual disk space usage
Previous:From: Alexander FortinDate: 2012-03-30 10:34:45
Subject: Re: pg_database_size() and actual disk space usage

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