Determining size of a database before dumping

From: Madison Kelly <linux(at)alteeve(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Determining size of a database before dumping
Date: 2006-10-02 20:17:33
Message-ID: 452173DD.5070101@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I am (re)writing a backup program and I want to add a section for
backing up pSQL DBs. In the planning steps (making sure a given
destination has enough space) I try to calculate how much space will be
needed by a 'pg_dump' run *before* actually dumping it.

Is there a relatively easy way to do that? Moreso, if it possible to
do this from an unpriviledged account? If not, is there a way to add the
permissions to a specific pg user to allow that user to perform this?

Thanks in advance!

Madison

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wampler 2006-10-02 20:43:39 Re: Determining size of a database before dumping
Previous Message Damian C 2006-10-02 20:08:35 Re: Postgres backup