Re: Backup and analyse

Christopher Sawtell <csawtell(at)xtra(dot)co(dot)nz> wrote:
>a) Does VACUUMing ( with ANALYSE ) in effect perform a file consistency
>check on the database structure as a side effect?

As I understand it, it is more of a cleanup than a file consistency check.

>b) Is it ok to VACUUM while the database is alive and active?

Yes.

>c) Can I backup via pg_dump while the database is alive and active and have
>the backup consistent to the state the database was in when the backup
>started?

The backup is consistent; I assume it's consistent with the state of the
database when pg_dump was started.

HTH,
Ray
--
Pinky, Are You Pondering What I'm Pondering?
I think so Brain, but "instant karma" always gets so lumpy.
Pinky and the Brain in "Brainwashed Part 3: Wash Harder"