From: | will trillich <will(at)serensoft(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How robust is postgresql ? |
Date: | 2001-03-07 19:50:34 |
Message-ID: | 20010307135034.B7500@mail.serensoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew | 2001-03-07 20:07:25 | RE: SELECT performance drop v 6.5 -> 7.0.3 |
Previous Message | will trillich | 2001-03-07 19:45:00 | unbalanced indexes -> fixed via dump/restore? |