-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I managed to run pg_upgrade after installing:
postgresql-server-dev-8.4 postgresql-server-dev-9.0 and relative dependencies. Perhaps the script should stop when it doesn't find pg_config, instead it just displays the following lines: sh: /usr/lib/postgresql/8.4/bin/pg_config: No such file or directory sh: /usr/lib/postgresql/9.0/bin/pg_config: No such file or directory Then continues with the consistency checks so the user has the impression that everything is fine. Three more notes: 1. I had to run the script from /tmp because the postgres user didn't have permission to create delete_old_cluster.sh in my home directory. Perhaps it should be saved in /var/lib/postgresql/9.0/main/ rather than ./ 2. postgresql-9.0 installs two postgresql.conf, I find it confusiong. Are both necessary? If I'm not mistaken 8.4 was installing just one in /var/lib/postgresql/9.0/main/ /etc/postgresql/9.0/main/postgresql.conf /var/lib/postgresql/9.0/main/postgresql.conf 3. pg_upgrade was failing to start the old 8.4 server because it looks for postgres 8.4 config file postgresql.conf in /var/lib/postgresql/8.4/main/ instead of /etc/postgresql/8.4/main/ The command that failed was: "/usr/lib/postgresql/8.4/bin/pg_ctl" -l "/dev/null" -D "/var/lib/postgresql/8.4/main" -o "-p 5432 -c autovacuum=off -c autovacuum_freeze_max_age=2000000000" start >> "/dev/null" 2>&1 To solve this I had to copy postgresql.conf in /var/lib/postgresql/8.4/main/. Regards, Paolo. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkyYyqoACgkQqAaEpZvj+VPcxgCgmKhFB6WmRvNxiNykOonAoQ02 BfwAn2t+AXOFRJ4QFXyordKJ/aweqSp6 =SibP -----END PGP SIGNATURE----- -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org