On Apr 23, 2008, at 10:03 AM, Gabor Siklos wrote:
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? Or should I instead just
dump the data, using pg_dump, and
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? Or should I instead just dump the data, using
pg_dump, and back up the dump?
The advantage of the first method would