Обсуждение: How to find out database size

Поиск
Список
Период
Сортировка

How to find out database size

От
Michael Brusser
Дата:
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.


Re: How to find out database size

От
Дата:

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/