Testing Huge PostgreSQL Backups for 37 Cents a Day

feedbin.com

20 pointssashk3 comments

Don't you need a sleep after mail to make sure it is sent before the shutdown kills network? Feels race conditiony

Nit 2: I would add some select counts or similar to ensure a few big tables are there. Would maybe include the counts in the email.

Also - can this last part be written different? Feels monolithic

sudo -u postgres bash -c "cat > /var/lib/postgresql/9.2/main/recovery.conf <<- _EOF_ restore_command = 'env ......blahblah"

Critically, no matter what your bid is, you never pay more than the spot price which is “The current market price of a Spot instance per hour.” With this in mind you don’t have to guess what to bid and since your bid matches the on-demand price, your instance will never be terminated early due to the price exceeding your bid.

This isn't accurate, the spot price can absolutely be higher than on demand pricing and isn't a reliable method to prevent your instance from being terminated.

Reply on news.ycombinator.com