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

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(at)servidores(dot)net | home page: http://casa.ccp.servidores.net |
|_____Tódalas persoas maiores foron nenos antes, pero poucas se lembran______|