From: | Geoffrey <lists(at)serioustechnology(dot)com> |
---|---|
To: | jd(at)commandprompt(dot)com |
Cc: | Erik Jones <ejones(at)engineyard(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: warm standby with WAL shipping |
Date: | 2009-06-04 12:18:40 |
Message-ID: | 4A27BBA0.3050701@serioustechnology.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Joshua D. Drake wrote:
> On Wed, 2009-06-03 at 15:07 -0400, Geoffrey wrote:
>
>>> You are still going to need to either:
>>>
>>> A. Reinvent the wheel, by scripting it all yourself
>>> B. Use solutions that are already used by others such as walmgr or
>>> pitrtools
>> My assumption was that since pg_standby does not have the scp/rsync
>> functionality, I would have to either modify it, change the way we do
>> things, or 'reinvent' a little different wheel.
>
> You wouldn't modify pg_standby. You would create a new utility that
> ships logs (or pulls logs) for pg_standby to utilize.
I assume a script that pulls the logs to the warm standby and then calls
pg_standby. That's a thought.
>> There is also an objection to using the python tools as we are small
>> shop and do not have anyone who is versed in python.
>
> At best this seems like a very odd requirement. You aren't doing any
> development. You are using a utility which is written in a specific
> language.
Well, we are an odd group. :)
>> I have not had a chance to look at walmgr, I will do that shortly.
>>
> I believe it is written in Python.
Hmm, I guess I should brush up on my Python.
> Anyway good luck!
Thank you.
> Joshua D. Drkae
echo Joshua D. Drkae |sed 's/ka/ak/'
:)
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Oliva | 2009-06-04 12:23:23 | Re: Upgrading Database: need to dump and restore? |
Previous Message | Grzegorz Jaśkiewicz | 2009-06-04 12:18:03 | Re: Upgrading Database: need to dump and restore? |