On 02/09 02:35, Stuart Henderson wrote:
> I've just tried pg_upgrade following the pkg-readme. It went OK in the
> end but there were some bumps along the way. A few notes:
Sorry about that. The blame lies with me as I wrote the documentation.
How about the following patch, which I think addresses all of the issues
you found? To fix the data.old issue, let's version the old directory,
since that makes data loss less likely. We will need to remember to
update the version when the PostgreSQL major version changes.
Thanks,
Jeremy
Index: pkg/README-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/README-server,v
retrieving revision 1.20
diff -u -p -r1.20 README-server
--- pkg/README-server 18 Dec 2016 18:18:27 -0000 1.20
+++ pkg/README-server 9 Feb 2017 04:56:46 -0000
@@ -125,7 +125,7 @@ to the current version.
# pkg_add -ui postgresql-server
4) Backup your old data directory:
-# mv /var/postgresql/data /var/postgresql/data.old
+# mv /var/postgresql/data /var/postgresql/data-9.5
5) Create a new data directory (using -E UTF8 if appropriate):
# su _postgresql -c "mkdir /var/postgresql/data"
@@ -133,9 +133,9 @@ to the current version.
6) Restore your old pg_hba.conf and (if used) SSL certificates
# su _postgresql -c \
- "cp /var/postgresql/data.old/pg_hba.conf /var/postgresql/data/"
+ "cp /var/postgresql/data-9.5/pg_hba.conf /var/postgresql/data/"
# su _postgresql -c \
- "cp /var/postgresql/data.old/server.{crt,key} /var/postgresql/data/"
+ "cp /var/postgresql/data-9.5/server.{crt,key} /var/postgresql/data/"
Some postgresql.conf settings changed or disappeared in this version.
Examine your old file for local changes and apply them to the new version.
@@ -157,10 +157,10 @@ faster than a dump and reload, especiall
# ${RCDIR}/postgresql stop
2) Upgrade your PostgreSQL package with pkg_add.
-# pkg_add -ui postgresql-pg_upgrade
+# pkg_add postgresql-pg_upgrade
3) Backup your old data directory:
-# mv /var/postgresql/data /var/postgresql/data.old
+# mv /var/postgresql/data /var/postgresql/data-9.5
4) Create a new data directory (using -E UTF8 if appropriate):
# su _postgresql -c "mkdir /var/postgresql/data"
@@ -168,19 +168,27 @@ faster than a dump and reload, especiall
5) Restore your old pg_hba.conf and (if used) SSL certificates
# su _postgresql -c \
- "cp /var/postgresql/data.old/pg_hba.conf /var/postgresql/data/"
+ "cp /var/postgresql/data-9.5/pg_hba.conf /var/postgresql/data/"
# su _postgresql -c \
- "cp /var/postgresql/data.old/server.{crt,key} /var/postgresql/data/"
+ "cp /var/postgresql/data-9.5/server.{crt,key} /var/postgresql/data/"
Some postgresql.conf settings changed or disappeared in this version.
Examine your old file for local changes and apply them to the new version.
-6) Run pg_upgrade:
-# su _postgresql -c "pg_upgrade -b /usr/local/bin/postgresql-9.5/
- -B /usr/local/bin -U postgres
- -d /var/postgresql/data.old/ -D /var/postgresql/data"
+6) Temporarily support connecting without a password for local users by
+ editing pg_hba.conf to include "local all postgres trust"
+# su _postgresql -c "vi /var/postgresql/data/pg_hba.conf"
+
+7) Run pg_upgrade:
+# su _postgresql -c "cd /var/postgresql && \
+ pg_upgrade -b /usr/local/bin/postgresql-9.5/ \
+ -B /usr/local/bin -U postgres \
+ -d /var/postgresql/data-9.5/ -D /var/postgresql/data"
-7) Start PostgreSQL:
+8) Remove "local all postgres trust" line from pg_hba.conf
+# su _postgresql -c "vi /var/postgresql/data/pg_hba.conf"
+
+9) Start PostgreSQL:
# ${RCDIR}/postgresql start
Clients/Frontends
