Changes between Version 42 and Version 43 of wheezy-jessie-upgrade

Timestamp:

Mar 5, 2016, 9:26:21 PM (10 years ago)

Author:

Steve Revilak

Comment:

--

wheezy-jessie-upgrade

@@ -86 +86 @@
 
 After that, dpkg --configure -a succeeded.
+
+
+'''Stallman'''.  Convert postgres 9.1 -> 9.4
+{{{
+pg_dumpall --verbose > pg91.out
+
+# Verify roundcube databases not in 9.4
+psql -p 5433 --list
+
+# load dump into 9.4
+psql -p 5433 < pg91.out
+
+# check
+psql -p 5433 --list
+}}}
+
+Next, stop all postgres instances, and switch 9.4 from the alternate
+port to the main port.
+
+{{{
+systemctl stop postgresql@9.1-main.service
+systemctl stop postgresql@9.4-main.service
+}}}
+
+Set {{{port = 5432}}} in /etc/postgresql/9.4/main/postgresql.conf
+
+{{{
+systemctl start postgresql@9.4-main.service
+systemctl disable postgresql@9.1-main.service
+
+0 roundcube@stallman:~$ psql -U roundcube roundcube
+psql (9.4.6)
+}}}
+