Re: How to find out database size - Mailing list pgsql-admin

From
Subject Re: How to find out database size
Date
Msg-id 1107.219.65.230.167.1049388190.squirrel@mail.trade-india.com
Whole thread Raw
In response to How to find out database size  (Michael Brusser <michael@synchronicity.com>)
List pgsql-admin

contrib/dbsize gives the diskspace the database is occupying.

not sure though how much space will dup file from pg_dump
occupy. BTW you could use -Fc otpion to produce commpressed
dumps.

regds
mallah.

> Is there a way to find out how much disk space I will need
> for the dump file before I run pg_dump on the database?
> Thank you,
> Mike.
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 3: if
> posting/reading through Usenet, please send an appropriate subscribe-nomail command to
> majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/


pgsql-admin by date:

Previous
From: "Chris White"
Date:
Subject: Problems with Large Objects using Postgres 7.2.1
Next
From: Raquel Vieira
Date:
Subject: Vacuumdb