Re: How robust is postgresql ?

On Wed, Mar 07, 2001 at 02:18:41PM -0500, John Madden wrote:
> > You can do a database dump and back up the SQL generated, or do a
> > filesystem backup. See
> > http://www.postgresql.org/devel-corner/docs/admin/backup.html for
> > information on the specifics.
>
> Yum - can filesystem backups be done in 7.0.x? (I would much prefer to
> killall -15 postmaster and copy files around than deal with pg_dump
> stuff.) Or do I have to wait for 7.1?
>
> (If that's the case, I think I'll just not backup any databases until I
> can upgrade them ;))

you're brave, like i was, last week. i'm a bit more meek these
days... :)

i rather like the textual 'dump/restore' concept, as it'll
compress nicely, and can be diff'd easily for iterative backups,
as well. plus on recreating (when needed) you'll have the same
data but <guess>probably even cleaner datafiles than you'd have
after a vacuum.</guess> plus it's easy to do remote yanks via
`pg_dump -h server.host.name` without any nfs or other clutter...

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will(at)serensoft(dot)com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!