-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Package: postgresql-9.4 Version: 9.4~rc1-1 Severity: grave Justification: renders package unusable
This is addendum to bug #764705 and #768009. Opening a new report since mail replying to update those is rejected "550 Unknown or archived bug" The instructions displayed by the current packages are still not working: " To resolve the situation, before upgrading, execute: # su - postgres $ pg_lsclusters $ pg_ctlcluster 9.4 main start $ pg_dumpall --cluster 9.4/main | gzip > 9.4-main.dump.gz $ cp -a /etc/postgresql/9.4/main 9.4-main.config $ pg_dropcluster 9.4 main --stop Then after the upgrade, execute: # su - postgres $ pg_createcluster 9.4 main $ cp 9.4-main.config/* /etc/postgresql/9.4/main $ pg_ctlcluster 9.4 main start $ zcat 9.4-main.dump.gz | psql -q --cluster 9.4/main $ rm -rf 9.4-main.config 9.4-main.dump.gz " I followed them verbatim on a clean 'old' install and still encountered this error: $ zcat 9.4-main.dump.gz | psql -q --cluster 9.4/main ERROR: role "postgres" already exists Manually decompressing the dump file and editing out the "CREATE ROLE postgres;" was required for the final instructions to run successfully. AYJ -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (MingW32) iQEcBAEBAgAGBQJUbr7RAAoJELJo5wb/XPRjYNMH+QHXHF7gS9IExsI0M7X3/kfN jNPwbKhkxOb4psGtQqdOt+jaXxukE4nuYRgeLGIY8hIZFRXIAL+B1qE9EefhYGin 1ZThes+B8xyxTCIPMhrrtfn8gVNLDkb1u0LuhojyhC3yo8NaJJ3LYFDgpx/hYMZK Gexojsi/XmxyfLx0QyTllIEj0Zd2Od57mIj9oybEzt+cXyXuQUOJiITHcjU5t1p2 gHfQttsWoUU4cbBJQbF1rzz01dhI9+gVwxVMA5cKuo5BlHwwVoCmilpSQfXXY09g 7unklMeD7b9Rz/GxcBOqOyk2hGuutmg/rFZYeu5LU7LYE6/15mKzKd0AfabKrvA= =JEcf -----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
