Determining size of a database before dumping - Mailing list pgsql-general

From Madison Kelly
Subject Determining size of a database before dumping
Date
Msg-id 452173DD.5070101@alteeve.com
Whole thread Raw
Responses Re: Determining size of a database before dumping  (Steve Wampler <swampler@noao.edu>)
Re: Determining size of a database before dumping  (Alexander Staubo <alex@purefiction.net>)
List 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

pgsql-general by date:

Previous
From: "Damian C"
Date:
Subject: Re: Postgres backup
Next
From: Steve Wampler
Date:
Subject: Re: Determining size of a database before dumping