| From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
|---|---|
| To: | David Wall <d(dot)wall(at)computer(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: standby questions |
| Date: | 2008-02-09 07:50:34 |
| Message-ID: | Pine.GSO.4.64.0802090246130.1627@westnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 8 Feb 2008, David Wall wrote:
> Does pg_standby take care of this by checking file sizes or the like? In my
> testing with scp, we never experienced any problems, but I wonder if we were
> somehow "just lucky."
pg_standby only processes files of exactly the length they're supposed to
be. On Windows it even sleeps a bit after that to give time for things to
settle.
The main risky situation you could end up in is if you were using a copy
program that created the whole file at its full size first then wrote the
data to it. I don't think there are many programs that operate like that
around and certainly scp doesn't do that.
--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-02-09 08:24:37 | Re: POLL: Women-sized t-shirts for PostgreSQL |
| Previous Message | Greg Smith | 2008-02-09 07:45:04 | Re: standby questions |