Re: Great change (size of data dir) upgrading postgresql - Mailing list pgsql-general

From Carlos Costa Portela
Subject Re: Great change (size of data dir) upgrading postgresql
Date
Msg-id Pine.LNX.4.33.0401182156310.24122-100000@casa.ccp.servidores.net
Whole thread Raw
In response to Great change (size of data dir) upgrading postgresql  (Carlos Costa Portela <ccosta@servidores.net>)
Responses Re: Great change (size of data dir) upgrading postgresql  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List 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 by date:

Previous
From: "D. Dante Lorenso"
Date:
Subject: Re: Tool to ease development of plpgsql
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: Great change (size of data dir) upgrading postgresql