* Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> [100211 08:29]: > To suppport a restore_command that does the sleeping itself, like > pg_standby, would require a major rearchitecting of the retry logic. And > I don't see why that'd desirable anyway. It's easier for the admin to > set up using simple commands like 'cp' or 'scp', than require him/her to > write scripts that handle the sleeping and retry logic.
But colour me confused, I'm still not understanding why this is any different that with normal PITR recovery. So even with a plain "cp" in your recovery command instead of a sleep+copy (a la pg_standby, or PITR tools, or all the home-grown solutions out thery), I'm not seeing how it's going to get "half files". The only way I can see that is if you're out of disk space in your recovering pg_xlog. It's well know in PostgreSQL wal archivne - you don't just "shove" files into the archive, you make sure they appear there with the right name atomically. And if the master is only running the archive command on whole WAL files, I just don't understand this whole short wal problem. And don't try and tell me your just "poaching" files from a running cluster's pg_xlog directory, because I'm going to cry... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave.
signature.asc
Description: Digital signature
