Re: Great change (size of data dir) upgrading postgresql - Mailing 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______|