Hello Martin, On Mon, Jan 14, 2008 at 07:46:20AM +0100, Martin Pitt wrote: > reassign 460576 postgresql-common > thanks > > Hi Stanislav, > > Stanislav Maslovski [2008-01-13 21:56 +0300]: > > I am trying to upgrade from 8.1 to 8.2. As explained in > > /usr/share/doc/postgresql-8.2/README.Debian right after the > > installation of postgresql-8.2 I do this > > > > # su postgres > > $ pg_dropcluster 8.2 main --stop > > $ pg_upgradecluster 8.1 main > > Error: target cluster 8.2/main already exists > > $ ls -la ~ > > total 18 > > drwxr-xr-x 3 postgres postgres 2048 2008-01-13 21:52 . > > drwxr-xr-x 53 root root 2048 2008-01-06 18:19 .. > > drwxr-xr-x 3 postgres postgres 2048 2008-01-05 11:49 8.1 > > -rw------- 1 postgres postgres 2372 2008-01-13 21:39 .bash_history > > -rw------- 1 postgres postgres 7885 2008-01-08 18:03 .psql_history > > > > Am I doing something wrong or is it a bug in the upgrade script? > > As it says, there already is a cluster 'main' for 8.2 (since this is > created by default on package installation). This is done so that a > fresh installation works out of the box without the need to create a > cluster first, but of course it clashes when you try to upgrade > 8.1/main and 8.2/main exists, too. The recommended procedure is to do > remove the 8.2 one with "pg_dropcluster 8.2 main --stop" and then > pg_upgradecluster. This procedure is explained in README.Debian, > section "Default clusters and upgrading". Since you read it, can you > please give me some hints how to improve the documentation? >
Well, actually I did run that "pg_dropcluster 8.2 main --stop" as you can see from the log. My mistake was that I thought I should do the upgrade under postgres system account. However, I had to do it when being root. > Should I improve README.Debian somehow? pg_upgradecluster could > explain how to drop the cluster? Anything else? Please add a siple uid check to the script so that it will print an informative message when run with not enough priveleges and possibly add a note to the README file. Thanks! -- Stanislav -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
