Re: pg_database_size() and actual disk space usage

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/