From: | Naomi Walker <nwalker(at)eldocomp(dot)com> |
---|---|
To: | Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org>, Naomi Walker <nwalker(at)eldocomp(dot)com> |
Cc: | "P(dot) Dwayne Miller" <dmiller(at)espgroup(dot)net>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Backup and Recovery |
Date: | 2001-06-20 20:41:23 |
Message-ID: | 4.2.2.20010620133931.00a9a100@logic1design.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
At 12:26 PM 6/20/01 +0100, Matthew Kirkwood wrote:
>On Tue, 19 Jun 2001, Naomi Walker wrote:
>
> > Even more important that uptime to us, is to never put ourselves in a
> > position where we could lose data. I understand I can do a hot backup
> > with pg_dumpall. What we need on top of that is the ability to replay
> > the transaction logs against the previous database archive. Without
> > such a feature, even if I did a full backup a few times a day, we
> > would be vulnerable to losing hours of data (which would not be
> > acceptable to our users).
>
>This is what I'd like too (though I'm not that bothered about
>rolling forward from a dump if I can just do it by replaying
>logs onto real datafiles).
>
>I mentioned it a while ago:
>
>http://fts.postgresql.org/db/mw/msg.html?mid=114397
>
>but got no response.
Well, so now there is at least TWO of us....
We should start the thread again.
>You are aware that you can still lose up to (by default) 16Mb
>worth of transactions in this scheme, I presume?
I'm just starting with Postgresql, but, I thought with fsync on this was
not the case. Is that not true or what else did I miss?
>Matthew.
>
>
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Myers | 2001-06-20 20:48:04 | Re: Re: [PATCHES] Australian timezone configure option |
Previous Message | Peter Eisentraut | 2001-06-20 20:37:02 | Re: Embedding postgresql |