| 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 19:47:39 |
| Message-ID: | 4A2581DB.10404@serioustechnology.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
--
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 | Tom Lane | 2009-06-02 20:12:18 | Re: catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role |
| Previous Message | Ben Chobot | 2009-06-02 19:42:09 | Re: Really out of memory? |