7,649
edits
Changes
Jump to navigation
Jump to search
Research Computing Configuration (view source)
Revision as of 16:14, 26 October 2020
, 16:14, 26 October 2020→PostGIS Issues
') AS attfdwoptions FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = '19998614'::pg_catalog.oid AND
a.attnum > 0::pg_catalog.int2 ORDER BY a.attnum
======Postgres Upgrade Attempt (Failed)======
My changes weren't substantial, so I proceeded with an upgrade. First I checked to see if I had postgres12 installed and listening on another port or not:
#This failed too - there are unmet dependencies and they are 'not installable'.
======Switching over the installations====== So, option 2 is toI took an alternative approach. The plan:
#Take version 10 offline
#Move version 10's data to a new location (/var/lib/postgresql/10/main)
rsync -av /var/lib/postgresql/12/master/ /data/postgres
systemctl start postgresql
pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
10 main 5433 online postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log
12 master 5432 online postgres /data/postgres /var/log/postgresql/postgresql-12-master.log
Then restore the databases:
====Other Fixes====
