Re: Great change (size of data dir) upgrading postgresql

Поиск
Список
Период
Сортировка
От Carlos Costa Portela
Тема Re: Great change (size of data dir) upgrading postgresql
Дата
Msg-id Pine.LNX.4.33.0401182156310.24122-100000@casa.ccp.servidores.net
обсуждение исходный текст
Ответ на Great change (size of data dir) upgrading postgresql  (Carlos Costa Portela <ccosta@servidores.net>)
Ответы Re: Great change (size of data dir) upgrading postgresql  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список pgsql-general
On Sun, 18 Jan 2004, Nigel J. Andrews wrote:
> On Sun, 18 Jan 2004, Carlos Costa Portela wrote:
> > S.ficheros          Tamaño Usado  Disp Uso% Montado en
> > /dev/hda1             1.9G  1.8G   64M  97% /usr/local/pgsql/data.old
> > /dev/hdb2             4.5G  357M  3.9G   9% /usr/local/pgsql/data
> >
> Well, to be safe...back it up.

I've backed up it to cd. Thanks.

> However, I would suggest that you haven't 'vacuum'-ed you 7.3 database for some
> time. To give some level of comfort before destroying the original data
> directory you could fire up the 7.2 server and run vacuum full against it's

I have a vacuum command each day on my crontab :-?



       [ http://www.biologia.org/ :: portal especializado en Biología ]
 _______Carlos Costa Portela_________________________________________________
| e-mail:  ccosta@servidores.net | home page: http://casa.ccp.servidores.net |
|_____Tódalas persoas maiores foron nenos antes, pero poucas se lembran______|


В списке pgsql-general по дате отправления:

Предыдущее
От: "D. Dante Lorenso"
Дата:
Сообщение: Re: Tool to ease development of plpgsql
Следующее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: Great change (size of data dir) upgrading postgresql