Postgres Pro
Downloads
Home   >   mailing lists

Question about backup/restore - Mailing list pgsql-admin

From Nigel Bishop
Subject Question about backup/restore
Date
Msg-id 8D206F73E2BE3E419EE87066E31F54EEEB30@intyoad01.uk.ioko365.com
Whole thread Raw
Responses Re: Question about backup/restore
List pgsql-admin
Tree view
Could someone please advise:
 
I'm new to Postgres (13 years Oracle DBA experience) and I'm trying to understand the nature of Postgres backup/restores.
 
An example:
 
If I take a backup (via pg_dump) at 8pm on Wednesday and then on Thursday at 10am I have some form of media failure, how do I roll the DB forward from the backup to the point of failure.
 
Can this be done?
 
Thanks for any assistance.
 
Regards
 

Nigel

pgsql-admin by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: Fwd: Postgresql
Next
From: Tom Lane
Date:
Subject: Re: Database access problem : SOS