From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | Eric Kerin <eric(at)bootseg(dot)com> |
Subject: | Re: will PITR in 8.0 be usable for "hot spare"/"log |
Date: | 2004-08-14 08:41:17 |
Message-ID: | 411DD02D.5030304@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Eric Kerin wrote:
> On Wed, 2004-08-11 at 16:43, Tom Lane wrote:
>
>>Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
>>
>>>Tom Lane wrote:
>>>
>>>>It should work; dunno if anyone has tried it yet.
>>
>>>I was thinking about it but I soon realized that actually is
>>>impossible to do, postgres replay the log only if during the
>>>start the file recover.conf is present in $DATA directory :-(
>>
>><SNIP>
>>
>>Somebody should hack this together and try it during beta. I don't
>>have time myself.
>>
>> regards, tom lane
>
>
>
> I've wrote up a very quick, and insanely dirty hack to do log shipping.
> Actually, it's so poorly written I kinda feel ashamed to post the code.
>
> But so far the process looks very promising, with a few caveats.
>
> The issues I've seen are:
> 1. Knowing when the master has finished the file transfer transfer to
> the backup.
> 2. Handling the meta-files, (.history, .backup) (eg: not sleeping if
> they don't exist)
> 3. Keeping the backup from coming online before the replay has fully
> finished in the event of a failure to copy a file, or other strange
> errors (out of memory, etc).
I did the same work and I had the same problems solved in the exact way
you did, however my version was shell based ( wasted time ) :-(
I guess is better mantain the C version, I will take a look at it and
I will modify it if something doesn't work.
Good work.
Regards
Gaetano Mendola
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2004-08-14 09:00:00 | Re: Why is WIN 1250 client only? |
Previous Message | Peter Eisentraut | 2004-08-14 08:34:38 | Re: Turkish downcasting in PL/pgSQL |