[HACKERS] hot spare / log shipping work on

2004-08-13 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm having some spare time and I'm testing what Tom Lane was suggesting: === Tom Lane wrote: 1. You set up WAL archiving on the master, and arrange to ship copies of

Re: [HACKERS] hot spare / log shipping work on

2004-08-13 Thread Manfred Spraul
Gaetano Mendola wrote: a1) If exist check that is a 16MB file ( the request can ~arrive during the copy ), I think this will fail under windows: copy first sets the file size and then transfers the data. I wouldn't rule out that some Unices use the same implementation. ~

Re: [HACKERS] hot spare / log shipping work on

2004-08-13 Thread Gaetano Mendola
Manfred Spraul wrote: Gaetano Mendola wrote: a1) If exist check that is a 16MB file ( the request can ~arrive during the copy ), I think this will fail under windows: copy first sets the file size and then transfers the data. I wouldn't rule out that some Unices use the

Re: [HACKERS] hot spare / log shipping work on

2004-08-13 Thread Tom Lane
Gaetano Mendola [EMAIL PROTECTED] writes: I'm facing however to the following problems: 1) Discovery the actual WAL file I'm supposing is the last modified file inside the pg_xlog directory. If this is not the good method may I know how I can know it ? While that

Re: [HACKERS] hot spare / log shipping work on

2004-08-13 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: I'm facing however to the following problems: 1) Discovery the actual WAL file I'm supposing is the last modified file inside the pg_xlog directory. If this is not the good method may I know how I can know it ?