[Pkg-postgresql-public] Bug#681344: Bug#681344: postgresql-common: pg_upgradecluster should use pg_ctlcluster stop --force to shut down the cluster

[Martin von Wittich]

Hi Martin ;)

Am 21.07.2012 17:32, schrieb Martin Pitt:
> I don't think it's a good idea. Usually upgrading a DB to a new major
> version requires some attention anyway, and should not done with any
> level of bruteness.

We upgraded several hundred servers from lenny to squeeze automatically, 
including their postgres databases :)

Admittedly though the databases are rather small, probably none is 
bigger than 1 GB.

>> or a parameter should be added so that users can specify that they
>> want a forced shutdown.
>
> That seems okay, but rather redundant. You can always pg_ctlcluster
> --force stop the cluster yourself before upgrading. Keeping bug open
> to add it to pg_upgradecluster.

I can? AFAIR that didn't work. I can't test it at the moment because I 
don't have a VM with postgres 8.3 ready, but the code seems to agree:

error 'specified cluster is not running' unless $info{'running'};

Martin