LMSouq
server-admin Open

Upgrade PostgreSQL from 9.6 to 10.0 on Ubuntu 16.10

TR
trench
1 month ago
3 views
Problem Description
My database is over 600 GB and my current volume is only 1 TB, so that probably limits my options. My config files are here: /etc/postgresql/9.6/main My database is here: /mnt/1TB/postgresql/9.6/main Edit - This guide worked for me. The only addition I needed to make was to download libicu55 manually and install it, and I had to grant postgres 1777 permission for my /tmp/ folder. I was also saving the data folder to a different drive, so I had to use the command: pg_upgradecluster -m upgrade 10 main /mnt/1TB/postgresql/10 https://gist.github.com/delameko/bd3aa2a54a15c50c723f0eef8f583a44

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base