Re: Backup setup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gabor Siklos" <gabor(at)karamaan(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Backup setup
Date: 2008-04-23 15:31:36
Message-ID: 11372.1208964696@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Gabor Siklos" <gabor(at)karamaan(dot)com> writes:
> I need to back up our database off-site for disaster recovery. If I just
> back up the entire database data directory (i.e. /var/lib/pgsql/data) will I
> be able to restore from there?

This will not work. Please read
http://www.postgresql.org/docs/8.3/static/backup.html

(adjust link per your PG version)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christophe 2008-04-23 15:35:08 Re: Backup setup
Previous Message John Gardner 2008-04-23 15:27:33 Vacuuming Questions