Skip site navigation (1) Skip section navigation (2)

Re: [ADMIN] Restore Database

From: Alexander Burbello <burbello3000(at)yahoo(dot)com(dot)br>
To: Lista Postgres <pgadmin-support(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Restore Database
Date: 2006-07-14 11:42:54
Message-ID: 44B7833E.8080202@yahoo.com.br (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-admin
Yes!
I followed exactly that page to do.

Thanks



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 
>>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
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>
>  
>


In response to

pgsql-admin by date

Next:From: Donald FraserDate: 2006-07-14 12:07:42
Subject: hooks for User login process
Previous:From: Thomas MackDate: 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 PageDate: 2006-07-14 12:46:18
Subject: Re: help: trigger functions/functions/procedures, bug list, and window state
Previous:From: Scott MarloweDate: 2006-07-13 22:45:46
Subject: Re: [ADMIN] Restore Database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group