Re: disk backups

Stephen Lawrence Jr. wrote:
>
> I think the way most people do that is to have pg_dump or pg_dumpall make a
> dump of the databases into the postgres directory each nite. That way, when
> you do a full disk backup, the database dumps would be backed up as well.

Is there a better way? Here pg_dumping the DB takes over half an hour
(mainly because pg_dump chews all available memory). It would be nicer
if we knew that tarring it up would work also...

> ----- Original Message -----
> From: "mikeo" <mikeo(at)spectrumtelecorp(dot)com>
> Subject: [GENERAL] disk backups
>
> > hi,
> > would someone be so kind as to comment on restoring a database from
> > file backups?

--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/