Martin Pitt wrote:
So I think the best we can do here is to document how to do the
upgrade
What Aiko wrote is *mostly* what I did (apt-get, not aptitude), but:
On Sun, 12 Oct 2014, Aiko Barz wrote:
Backup /etc/postgresql first. From my memory:
$ su - postgres
$ pg_dumpall backup_today.sql # User/DB access
$ pg_dropcluster --stop 9.4 main
$ exit
$ aptitude upgrade
$ su - postgres
$ pg_createcluster --locale en_US.UTF-8 9.4 main
Right, except pg_createcluster only works as root, and
it takes options. Lots of options. I did not know all
the locale, lc_*, encoding, etc. options, so I settled
for --locale=C --encoding=UTF-8 which sounded the most
close to what I’d personally be doing, here.
And this is the reason I still don’t know if I introduced
any changes into the DB now or not…
$ exit
Here in this place I had to manually compare all files
from /etc/postgresql against the saved ones and transfer
changes to the new files in /etc/postgresql manually.
$ /etc/init.d/postgresql start
$ su - postgres
$ psql -f backup_today.sql postgres # User/DB access
$ exit
Or: sudo -u postgres psql postgres backup.sql
Martin Pitt wrote:
and then not repeat the premature release of betas to
unstable?
Yes, please.
Thanks,
//mirabilos
--
tarent solutions GmbH
Rochusstraße 2-4, D-53123 Bonn • http://www.tarent.de/
Tel: +49 228 54881-393 • Fax: +49 228 54881-235
HRB 5168 (AG Bonn) • USt-ID (VAT): DE122264941
Geschäftsführer: Dr. Stefan Barth, Kai Ebenrett, Boris Esser, Alexander Steeg
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org