| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Alexander Burbello <burbello3000(at)yahoo(dot)com(dot)br> |
| Cc: | Aaron Bono <postgresql(at)aranya(dot)com>, Lista Postgres <pgadmin-support(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [ADMIN] Restore Database |
| Date: | 2006-07-13 22:45:46 |
| Message-ID: | 1152830746.14241.101.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-admin |
On Wed, 2006-07-12 at 15:04, Alexander Burbello wrote:
> Ok! Its a good tool, but for Production Database I think it is not
> recommended.
> Only using pg_dump for the second backup plain.
> Suppose that you backed up at 6:00am and at 9am happened a crash on the
> server.
> In this case, I would lost data between that time, 3 hours of information.
>
> For production databases, my plan is to do phisical backup including WAL.
> If a crash happen, I can restore the datafiles and recover applying the
> WAL logs until the last file was generated.
> As Oracle does in this type of crash.
>
> My doubt is that I am not getting apply the WAL files on recover stage.
>
> Any other suggestion?
You have read this section of the manual, right?
http://www.postgresql.org/docs/8.1/interactive/backup-online.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Burbello | 2006-07-14 11:42:54 | Re: [ADMIN] Restore Database |
| Previous Message | Kevin Field | 2006-07-13 17:23:33 | help: trigger functions/functions/procedures, bug list, and window state |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benjamin Krajmalnik | 2006-07-14 00:01:34 | Determining object name from filenode |
| Previous Message | Chris Browne | 2006-07-13 19:15:18 | Re: 8.1 Unique Index Issue/Bug??? |