Обсуждение: Control File

Hi,

Today I was playing with our test environment and noticed that if I delete a
PostgreSQL datafile (with cluster down) and bring up the database, It will
simple... come up???? :-/

I wonder if it shouldn't complain about the missing datafile before opening
the cluster... I don't know... Maybe something like the oracle control file
which stores information about the files needed to start the database.

It seems pretty easy to do it (I may be wrong...).

What do you think? Are there any special reasons for PostgreSQL not complain
about the missing datafiles on startup? Would that be hard to implement
(maybe I could do it).


C ya,
Bruno

""Bruno Almeida do Lago"" <teolupus@gmail.com> wrote in message 
news:43c7d194.15ee8336.2e7c.ffffb362@mx.gmail.com...
> Hi,
>
> Today I was playing with our test environment and noticed that if I delete 
> a
> PostgreSQL datafile (with cluster down) and bring up the database, It will
> simple... come up???? :-/
>
> I wonder if it shouldn't complain about the missing datafile before 
> opening
> the cluster... I don't know... Maybe something like the oracle control 
> file
> which stores information about the files needed to start the database.
>
> It seems pretty easy to do it (I may be wrong...).
>

What if after you check done, I remove the data file ?

Regards,
Qingqing