Re: Replication/cloning: rsync vs modification dates?

On Fri, Jul 27, 2012 at 09:57:55AM +1000, Chris Angelico wrote:
> On Fri, Jul 27, 2012 at 9:53 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > You might want to look at the hackers list thread I started about the
> > same topic a week before your post:
> >
> > http://archives.postgresql.org/pgsql-hackers/2012-07/msg00416.php
> >
> > Basically, you can only use mtime/size if you are replaying WAL.
>
> I'll check that out in a bit; but hot standby includes replaying WAL,
> right? That's what we're doing - full live replication with
> possibility to "pg_ctl promote" a slave straight up to master.

Yes, WAL is replayed in that case and any sub-second changes are going
to be replayed from the WAL log.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +