From: | Geoffrey <lists(at)serioustechnology(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | warm standby with WAL shipping |
Date: | 2009-06-02 19:21:43 |
Message-ID: | 4A257BC7.4050004@serioustechnology.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to set up a warm standby via WAL shipping. I'm digging
through the source of pg_standby.c to determine the proper method.
Since we are using scp to access the archive files, pg_standby doesn't
provide a solution to our problem.
From reading the comments in pg_standby.c, I see:
'Check for initial history file: always the first file to be requested
It's OK if the file isn't there - all other files need to wait'
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?
--
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 | Joshua D. Drake | 2009-06-02 19:33:16 | Re: warm standby with WAL shipping |
Previous Message | Louis Lam | 2009-06-02 19:13:15 | catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role |