I followed exactly that page to do.
Scott Marlowe escreveu:
>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
>>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
>>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?
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
In response to
pgsql-admin by date
|Next:||From: Donald Fraser||Date: 2006-07-14 12:07:42|
|Subject: hooks for User login process|
|Previous:||From: Thomas Mack||Date: 2006-07-14 08:30:46|
|Subject: Re: *** How can I install two postgresqls in the same machine? *****|
pgadmin-support by date
|Next:||From: Dave Page||Date: 2006-07-14 12:46:18|
|Subject: Re: help: trigger functions/functions/procedures, bug list, and window state|
|Previous:||From: Scott Marlowe||Date: 2006-07-13 22:45:46|
|Subject: Re: [ADMIN] Restore Database|