Re: warm standby with WAL shipping

From: Geoffrey <lists(at)serioustechnology(dot)com>
To: jd(at)commandprompt(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: warm standby with WAL shipping
Date: 2009-06-02 20:41:51
Message-ID: 4A258E8F.8030206@serioustechnology.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Geoffrey wrote:
> Joshua D. Drake wrote:
>> On Tue, 2009-06-02 at 15:21 -0400, Geoffrey wrote:
>>
>>> My problem is, I never see a *.history file, thus my script sits in a
>>> loop looking for it. I see the WAL files showing up on the archive
>>> server, but I don't see a *.history file.
>>>
>>> What am I missing?
>>
>> pg_standby it self isn't a solution for warm standby. It is a component
>> thereof. Also don't use SCP. Use rsync. Take a look at walmgr or
>> PITRTools it will make your life easier.
>
> Okay, I'm attempting to check out PITRTools:
>
> svn co
> https://projects.commandprompt.com/public/pitrtools/repo/branches/1.2
>
> svn: Unrecognized URL scheme for
> 'https://projects.commandprompt.com/public/pitrtools/repo/branches/1.2'
>
> What am I missing here?

Nevermind, ID 10T error.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-06-02 20:45:57 Re: Really out of memory?
Previous Message Merlin Moncure 2009-06-02 20:30:30 Re: loops