Bug#460576: pg_upgradecluster: cannot upgrade from 8.1 to 8.2
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]
Bug#460576: pg_upgradecluster: cannot upgrade from 8.1 to 8.2
Hi, Stanislav Maslovski [2008-01-14 11:39 +0300]: 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. Ah, I see. 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. In fact I had this check in previous versions, but some people asked me to make pg_*cluster work under the postgres account, too, provided that the permissions of /etc/postgresql and /var/lib/postgresql/ were sufficient (i. e. writable by postgres). Seems that the default setup does not match this, at least not for upgrades. Thanks for the details, I'll improve the error mesage. Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#460576: pg_upgradecluster: cannot upgrade from 8.1 to 8.2
Package: postgresql-8.2 Version: 8.2.6-1 Severity: normal 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? -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (900, 'testing'), (90, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.23-minimal (PREEMPT) Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages postgresql-8.2 depends on: ii libc6 2.7-5 GNU C Library: Shared libraries ii libcomerr21.40.3-1 common error description library ii libkrb53 1.6.dfsg.3~beta1-2 MIT Kerberos runtime libraries ii libpam0g 0.99.7.1-5 Pluggable Authentication Modules l ii libpq58.2.6-1PostgreSQL C client library ii libssl0.9.8 0.9.8g-3 SSL shared libraries ii postgresql-client-8.2 8.2.6-1front-end programs for PostgreSQL ii postgresql-common 82 PostgreSQL database-cluster manage ii tzdata2007k-1time zone and daylight-saving time postgresql-8.2 recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#460576: pg_upgradecluster: cannot upgrade from 8.1 to 8.2
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? Should I improve README.Debian somehow? pg_upgradecluster could explain how to drop the cluster? Anything else? Thanks in advance for any feedback! Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]