Re: How to find out database size

Поиск
Список
Период
Сортировка
От
Тема Re: How to find out database size
Дата
Msg-id 1107.219.65.230.167.1049388190.squirrel@mail.trade-india.com
обсуждение исходный текст
Ответ на How to find out database size  (Michael Brusser <michael@synchronicity.com>)
Список 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 по дате отправления:

Предыдущее
От: "Chris White"
Дата:
Сообщение: Problems with Large Objects using Postgres 7.2.1
Следующее
От: Raquel Vieira
Дата:
Сообщение: Vacuumdb