is backing up a live postgres enough?

From: Louis-David Mitterrand <vindex(at)apartia(dot)org>
To: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: is backing up a live postgres enough?
Date: 2002-11-24 09:51:01
Message-ID: 20021124095101.GA4234@apartia.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holger Marzen 2002-11-24 12:23:54 test against regexp in database
Previous Message Justin Clift 2002-11-24 08:44:36 Re: GUI for Postgres Management? PostgreSQL vs MySQL.