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