Re: How robust is postgresql ?

From: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>
To: John Madden <weez(at)freelists(dot)org>
Cc: Simon Crute <Simon(at)geordie(dot)demon(dot)co(dot)uk>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How robust is postgresql ?
Date: 2001-03-07 19:17:15
Message-ID: Pine.LNX.4.30.0103071415010.15784-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 7 Mar 2001, John Madden wrote:

> 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?

I don't see why not -- you're just copying files. The biggest issue with
the filesystem backup is making sure you get the correct logs backed up
also.

If you are upgrading between version, though, you have to use the pg_dump
way, as binary compatibility between versions is not guaranteed.

-- Brett
http://www.chapelperilous.net/~bmccoy/
------------------------------------------------------------------------
Live free or die.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Warren Vanichuk 2001-03-07 19:18:22 Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language
Previous Message The Hermit Hacker 2001-03-07 19:03:23 Re: When is 7.1 going out