pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed[BACKUPS]Little backups
6+ messages / 6 participants
[nested] [flat]
* [BACKUPS]Little backups
@ 2008-07-21 18:20 Leví Teodoro da Silva <tlevisilva@gmail.com>
0 siblings, 4 replies; 6+ messages in thread
From: Leví Teodoro da Silva @ 2008-07-21 18:20 UTC (permalink / raw)
To: pgsql-performance
Hi Guys,
I am developing a project with PostgreSQL and one guy from project is
familiar with Oracle and did a question for me, but i could not answer, if
someone could help it will be good. =)
The question is :
*
- In oracle he makes a full backup two times in a day. In this range of
time, Oracle make a lot of mini-backups, but this backups is about just the
data whose have changed in this time. If the system fails, he could
reconstruct the database adding the last "big backup" with "mini-backups".
Can Postgres do this ? *
Regards,
Leví - Brazil
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [BACKUPS]Little backups
@ 2008-07-21 18:28 Berge Schwebs Bjørlo <berge@trivini.no>
parent: Leví Teodoro da Silva <tlevisilva@gmail.com>
3 siblings, 0 replies; 6+ messages in thread
From: Berge Schwebs Bjørlo @ 2008-07-21 18:28 UTC (permalink / raw)
To: pgsql-performance
On Mon, Jul 21, 2008 at 03:20:27PM -0300, Leví Teodoro da Silva wrote:
> - In oracle he makes a full backup two times in a day. In this range of
> time, Oracle make a lot of mini-backups, but this backups is about just the
> data whose have changed in this time. If the system fails, he could
> reconstruct the database adding the last "big backup" with "mini-backups".
> Can Postgres do this ? *
Take a look at Point-In-Time-Recovery, PITR:
http://www.postgresql.org/docs/current/static/continuous-archiving.html
-Berge
--
Berge Schwebs Bjørlo
Alegría!
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [BACKUPS]Little backups
@ 2008-07-21 18:30 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Leví Teodoro da Silva <tlevisilva@gmail.com>
3 siblings, 0 replies; 6+ messages in thread
From: Kevin Grittner @ 2008-07-21 18:30 UTC (permalink / raw)
To: Leví Teodoro da Silva <tlevisilva@gmail.com>; pgsql-performance
>>> "Leví Teodoro da Silva" <tlevisilva@gmail.com> wrote:
> - In oracle he makes a full backup two times in a day. In this range
of
> time, Oracle make a lot of mini-backups, but this backups is about
just the
> data whose have changed in this time. If the system fails, he could
> reconstruct the database adding the last "big backup" with
"mini-backups".
> Can Postgres do this ? *
The equivalent capability in PostgreSQL is the Point-In-Time Recovery
backup strategy:
http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html
Twice daily seems rather extreme -- we generally go with monthly.
-Kevin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [BACKUPS]Little backups
@ 2008-07-21 18:30 Albert Cervera Areny <albert@sedifa.com>
parent: Leví Teodoro da Silva <tlevisilva@gmail.com>
3 siblings, 0 replies; 6+ messages in thread
From: Albert Cervera Areny @ 2008-07-21 18:30 UTC (permalink / raw)
To: pgsql-performance
A Dilluns 21 Juliol 2008, Leví Teodoro da Silva va escriure:
> Hi Guys,
>
> I am developing a project with PostgreSQL and one guy from project is
> familiar with Oracle and did a question for me, but i could not answer, if
> someone could help it will be good. =)
> The question is :
> *
> - In oracle he makes a full backup two times in a day. In this range of
> time, Oracle make a lot of mini-backups, but this backups is about just the
> data whose have changed in this time. If the system fails, he could
> reconstruct the database adding the last "big backup" with "mini-backups".
> Can Postgres do this ? *
Yes, it can. If you need detailed information, you can take a look at
http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html
>
>
>
>
> Regards,
> Leví - Brazil
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [BACKUPS]Little backups
@ 2008-07-21 18:38 A. Kretschmer <andreas.kretschmer@schollglas.com>
parent: Leví Teodoro da Silva <tlevisilva@gmail.com>
3 siblings, 1 reply; 6+ messages in thread
From: A. Kretschmer @ 2008-07-21 18:38 UTC (permalink / raw)
To: pgsql-performance
am Mon, dem 21.07.2008, um 15:20:27 -0300 mailte Leví Teodoro da Silva folgendes:
> - In oracle he makes a full backup two times in a day. In this range of time,
> Oracle make a lot of mini-backups, but this backups is about just the data
> whose have changed in this time. If the system fails, he could reconstruct the
> database adding the last "big backup" with "mini-backups". Can Postgres do this
> ?
Sure, with the WAL-files.
http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [BACKUPS]Little backups
@ 2008-07-21 19:01 Levi <tlevisilva@gmail.com>
parent: A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 0 replies; 6+ messages in thread
From: Levi @ 2008-07-21 19:01 UTC (permalink / raw)
To: pgsql-performance
Thank you guys for the fast answer.
This same guy asked me about the support on PostgreSQL. When he see the
community behind PostgreSQL , he never will be worried about support. =)
Thanks a lot,
Leví
A. Kretschmer escreveu:
> am Mon, dem 21.07.2008, um 15:20:27 -0300 mailte Leví Teodoro da Silva folgendes:
>
>> - In oracle he makes a full backup two times in a day. In this range of time,
>> Oracle make a lot of mini-backups, but this backups is about just the data
>> whose have changed in this time. If the system fails, he could reconstruct the
>> database adding the last "big backup" with "mini-backups". Can Postgres do this
>> ?
>>
>
> Sure, with the WAL-files.
>
> http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html
>
>
> Andreas
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2008-07-21 19:01 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-07-21 18:20 [BACKUPS]Little backups Leví Teodoro da Silva <tlevisilva@gmail.com>
2008-07-21 18:28 ` Berge Schwebs Bjørlo <berge@trivini.no>
2008-07-21 18:30 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2008-07-21 18:30 ` Albert Cervera Areny <albert@sedifa.com>
2008-07-21 18:38 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2008-07-21 19:01 ` Levi <tlevisilva@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox