[HACKERS] two questions related to tablespace in PG8.0.1

2005-03-08 Thread Qingqing Zhou
Here are two questions related to PG8.0.1: 1. durability of create tablespace - what happens if several checkpoints done after create tablespace then system crashes - without redo, will the PG_VERSION file and symlinks survive in win32? Seems checkpoint didn't sync the content of PG_VERSION file.

Re: [HACKERS] two questions related to tablespace in PG8.0.1

2005-03-08 Thread Tom Lane
Qingqing Zhou [EMAIL PROTECTED] writes: Here are two questions related to PG8.0.1: 1. durability of create tablespace - what happens if several checkpoints done after create tablespace then system crashes - without redo, will the PG_VERSION file and symlinks survive in win32? Seems checkpoint

Re: [HACKERS] two questions related to tablespace in PG8.0.1

2005-03-08 Thread Qingqing Zhou
There is no such thing as crash without redo: that is what WAL is all about. The creation of the tablespace will be correctly replayed from WAL. (Of course, this claim depends on various assumptions about whether fsync behaves per spec ... but if it does not, tablespace creation is hardly