> Is it common practice to setup a cron job to vacuum your databases
> nightly? Do you just do something like:
> psql my_db < vacuum
> in cron? I was reading about administration and it talked about how
> vacuuming is such a good idea and all.
> If i am going to cron vacuum, is there anything else I should be doing, or
> is just "psql my_db < vacuum" all that needs done on a nightly basis.
you might try adding a something to the shell script that you are kicking off
with cron a dump of your databases. After you dump them, then you could also
push them to another machine on your network, or if a tape is in the tape drive,
write them to tape.
That's just good old UNIX admin advice; I hope its helpful...james
In response to
pgsql-general by date
|Next:||From: Brian||Date: 1998-06-29 12:36:45|
|Subject: Re: [GENERAL] vacuuming|
|Previous:||From: James Olin Oden||Date: 1998-06-29 12:24:34|
|Subject: Re: [GENERAL] Error message|