From 30c6202a2a3f2319c14d0fed58a42d7a497df7ba Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 15 Dec 2008 22:08:35 +0000 Subject: [PATCH] Add documentation that pg_standby sleeps on Win32 because of 'copy' behavior. --- doc/src/sgml/pgstandby.sgml | 13 +++++++++++-- 1 file changed, 11 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/pgstandby.sgml b/doc/src/sgml/pgstandby.sgml index 9973f02902..2b8aad7824 100644 --- a/doc/src/sgml/pgstandby.sgml +++ b/doc/src/sgml/pgstandby.sgml @@ -1,4 +1,4 @@ - + pg_standby @@ -295,7 +295,16 @@ restore_command = 'pg_standby -d -s 5 -t C:\pgsql.trigger.5442 ...\archive %f %p - Since the Windows example uses copy at both ends, either + The copy command on Windows sets the final file size + before the file is completely copied, which would ordinarly confuse + pg_standby. Therefore + pg_standby waits sleeptime + seconds once it sees the proper file size. GNUWin32's cp + sets the file size only after the file copy is complete. + + + + Using the Since the Windows example uses copy at both ends, either or both servers might be accessing the archive directory across the network. -- 2.40.0