Re: Taking databases offline

"Mariusz Czuada" <manieq(at)idea(dot)net(dot)pl> writes:
> Is it possible (and safe) to move database files to other location while
> server is working?

No. Shut down the postmaster first.

> But had to shutdown server first. So my question (and
> suggestion) is to consider:
> ALTER DATABASE <dbname> { OFFLINE [ { WAIT | IMMEDIATE }] | ONLINE };

Of course, you have this ability now on an installation-wide basis
with the available postmaster shutdown options. It's difficult to get
excited about expending the work to make this doable on a per-database
basis, mainly because I foresee multi-database installations getting
much less popular once we implement SQL schemas. Lots of schemas in
one (user) database per installation will become the norm, I think.
In that scenario a per-database shutdown option will be useless.

regards, tom lane