7,649
edits
Changes
Jump to navigation
Jump to search
=====PostGIS Issues=====
Research Computing Configuration (view source)
Revision as of 16:06, 26 October 2020
, 16:06, 26 October 2020→Address the upgrade issues
And the wiki now seems happy!
I also checked postgres and everything seemed ok:
su researcher
#This failed too - there are unmet dependencies and they are 'not installable'.
So, option 2 is to shutdown :#Take version 10, move offline#Move version 12 10's data to a new location (/var/lib/postgresql/10/main)#Switch the right port, ports of versions 10 and load 12#Move version 12's data to /data#Put version 12 online#Load up the dbases... Then data in version 12!#Optionally wipe out the old datastructure and move the new one to the right location. installation
Shut it down:
pg_ctlcluster 12 master start
pg_lsclusters
#The cluster
Ver Cluster Port Status Owner Data directory Log file
10 main 5432 online postgres /data/postgres /var/log/postgresql/postgresql-10-main.log
12 master 5433 down online postgres /var/lib/postgresql/12/master /var/log/postgresql/postgresql-12-master.loglogg systemctl stop postgresql systemctl status postgresql Edit the config files: vi /etc/postgresql/10/main/postgresql.conf data_directory = '/var/lib/postgresql/10/main' port = 5433 vi /etc/postgresql/12/master/postgresql.conf data_directory = '/data/postgres' port = 5432 #While we are here do some performance tuning: shared_buffers = 512MB huge_pages = try temp_buffers = 8G work_mem = 4GB maintenance_work_mem = 64 max_stack_depth = 24MB effective_cache_size = 384GB #Note that I didn't reduce the number of connections (and the max_wal_senders, which must be < max connections) Move the data: df #to check diskspace rm -R /var/lib/postgresql/10/main #Note that none of the config files in here were valid (though you should check this is true before you do it!) rsync -av /data/postgres/ /var/lib/postgresql/10/main #Takes awhile, but make sure it is all done before the next step rm -R /data/postgres rsync -av /var/lib/postgresql/12/master/ /data/postgres systemctl start postgresql
====Other Fixes====
