disk backups

From: mikeo <mikeo(at)spectrumtelecorp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: disk backups
Date: 2000-06-28 16:00:46
Message-ID: 3.0.1.32.20000628120046.0092ed00@pop.spectrumtelecorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
would someone be so kind as to comment on restoring a database from
file backups? for instance, if i backed up the postgres files, once
the database was down, and there was a subsequent problem, a file lost
or a disk crash maybe, would restoring the disk from the filebackup
cause any consistency problems with postgres?
please assume that all the files on the disk were postgres files
and the backup reflected that.

how about trying to restore just one or two files after an accidental
deletion, maybe? again from the disk file backup instead of from a
pg_dump.

how about using those same file backups to move a database to another,
similar setup machine?

thanks,
mikeo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Doré 2000-06-28 16:05:27 2 phase commit
Previous Message Tom Lane 2000-06-28 15:50:25 Re: Restricting queries by the presence of a WHERE clause