is backing up a live postgres enough? - Mailing list pgsql-general

From Louis-David Mitterrand
Subject is backing up a live postgres enough?
Date
Msg-id 20021124095101.GA4234@apartia.org
Whole thread Raw
Responses Re: is backing up a live postgres enough?
List pgsql-general
I recently restored a debian system from off-site rsync'ed copie of
/{var,etc,home} including a large Postgres db in /var/lib/postgres/data.
FWIW the rsync backup was run nightly on the _live_ system with all
daemons active.

The db started fine on the restored filesystem. Was I lucky? Is it still
necessary to create a daily dump with pg_dump? What is the accepted
practice w.r.t Postgres backups?

Thanks in advance, cheers,

--
 HIPPOLYTE: Puis-je vous demander quel funeste nuage,
            Seigneur, a pu troubler votre auguste visage ?
                                          (Phèdre, J-B Racine, acte 4, scène 2)

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: test
Next
From: Holger Marzen
Date:
Subject: test against regexp in database