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
$ exit

$ /etc/init.d/postgresql start

$ su - postgres
$ psql -f backup_today.sql postgres # User/DB access
$ exit
-- 
:wq ✉

_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

Reply via email to