On Thu, 2005-12-29 at 10:47 +0300, Dmitry Panov wrote:
> On Wed, 2005-12-28 at 11:05 -0500, Tom Lane wrote:
> > Dmitry Panov <[EMAIL PROTECTED]> writes:
> > > Yes, but if the server has crashed earlier the script won't be called
> > > and if the filesystem can't be recovered the changes will be los
On Wednesday 2005-12-28 05:38, Martijn van Oosterhout wrote:
> On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote:
> > I'm currently considering setting up online backup procedure and I
> > thought maybe it would be a useful feature if the online logs could be
> > written into more than o
On Wed, 2005-12-28 at 16:38 +, Ian Harding wrote:
> On 12/28/05, Dmitry Panov <[EMAIL PROTECTED]> wrote:
> > On Wed, 2005-12-28 at 11:05 -0500, Tom Lane wrote:
> > > Dmitry Panov <[EMAIL PROTECTED]> writes:
> > > > Yes, but if the server has crashed earlier the script won't be called
> > > > an
On 12/28/05, Dmitry Panov <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-12-28 at 11:05 -0500, Tom Lane wrote:
> > Dmitry Panov <[EMAIL PROTECTED]> writes:
> > > Yes, but if the server has crashed earlier the script won't be called
> > > and if the filesystem can't be recovered the changes will be lost.
On Wed, 2005-12-28 at 11:05 -0500, Tom Lane wrote:
> Dmitry Panov <[EMAIL PROTECTED]> writes:
> > Yes, but if the server has crashed earlier the script won't be called
> > and if the filesystem can't be recovered the changes will be lost. My
> > point is the server should write into both (or more)
Dmitry Panov <[EMAIL PROTECTED]> writes:
> Yes, but if the server has crashed earlier the script won't be called
> and if the filesystem can't be recovered the changes will be lost. My
> point is the server should write into both (or more) files at the same
> time.
As for that, I agree with the ot
On Wed, 2005-12-28 at 10:39 -0500, Tom Lane wrote:
> Dmitry Panov <[EMAIL PROTECTED]> writes:
> > I'm currently considering setting up online backup procedure and I
> > thought maybe it would be a useful feature if the online logs could be
> > written into more than one place (something like oracle
Dmitry Panov <[EMAIL PROTECTED]> writes:
> I'm currently considering setting up online backup procedure and I
> thought maybe it would be a useful feature if the online logs could be
> written into more than one place (something like oracle redo logs
> multiplexing).
You can do whatever you want
On 12/28/05, Dmitry Panov <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-12-28 at 13:38 +0100, Martijn van Oosterhout wrote:
> > On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote:
> > > I'm currently considering setting up online backup procedure and I
> > > thought maybe it would be a useful
On Wed, 2005-12-28 at 13:38 +0100, Martijn van Oosterhout wrote:
> On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote:
> > I'm currently considering setting up online backup procedure and I
> > thought maybe it would be a useful feature if the online logs could be
> > written into more th
On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote:
> I'm currently considering setting up online backup procedure and I
> thought maybe it would be a useful feature if the online logs could be
> written into more than one place (something like oracle redo logs
> multiplexing).
>
> If I
Hi,
I'm currently considering setting up online backup procedure and I
thought maybe it would be a useful feature if the online logs could be
written into more than one place (something like oracle redo logs
multiplexing).
If I got it right if the server's filesystem crashes completely then the
6 PM
> To: Jason Tesser
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Wal logs
> Jason Tesser wrote:
> > This question may seem trivial but how do I rebuild a database with the
> > wal logs?
>
> You can't, but with 7.5 you can archive those logs and use
how
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Thu 7/29/2004 7:56 PM
To: Jason Tesser
Cc: [EMAIL PROTECTED]
Subject:Re: [GENERAL] Wal logs
Jason Tesser wrote:
> This question may seem trivial but how do I rebuild a database with the
&g
Jason Tesser wrote:
> This question may seem trivial but how do I rebuild a database with the
> wal logs?
You can't, but with 7.5 you can archive those logs and use them and a
recent backup for point-in-time recovery.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL
This question may seem trivial but how do I rebuild a database with the
wal logs?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Barry Lind <[EMAIL PROTECTED]> writes:
> Given what you say below, I think there is a documentation bug then. In
> Section 9.3 of the Administrators Guide it says:
> "After a checkpoint has been made, any log segments written before the
> redo record are removed, so checkpoints are used to fre
Earlier I posted with my problems about the WAL logs eating up all my
diskspace. I tried the solutions offered--checkpoint after a big copy and
shortening the time between flushes. They helped somewhat.
Unfortunately, the problem snow seems to happen when I vacuum-analyze after a
big delete.
18 matches
Mail list logo
