| From: | <mallah(at)trade-india(dot)com> |
|---|---|
| To: | <michael(at)synchronicity(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How to find out database size |
| Date: | 2003-04-03 16:43:10 |
| Message-ID: | 1107.219.65.230.167.1049388190.squirrel@mail.trade-india.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)postgresql(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Will LaShell | 2003-04-03 18:13:02 | Re: 7.2.3 -> 7.3.2: timeofday(), server crashed |
| Previous Message | Chris White | 2003-04-03 16:35:36 | Problems with Large Objects using Postgres 7.2.1 |