The steps should be the same for 10 to 11 or any major version updates.
The key is the permissions.
ALWAYS BACKUP THE ORIGINAL DATABASE FOLDER
it's located in /share/CACHEDEV1_DATA/.POSTGRESQL_DB/
the steps are generally the same as what you'll find online. Taking special note on permissions and ownership. So
Code: Select all
chmod 700
Code: Select all
chown postgres
building on the previous post, after you have done a pg_dumpall
backup the existing QPostgresSQL for the settings and binary
everything is executed in the /opt/QPostgreSQL/bin folder
check your current database tables.
Code: Select all
./psql -l
Code: Select all
cp -r /opt/QPostgresSQL/ /backupdir/QPostgresSQL
Code: Select all
mv /share/CACHEDEV1_DATA/.POSTGRESQL_DB/ /backupdir/POSTGRESQL_DB/
Code: Select all
./initdb -D /share/CACHEDEV1_DATA/.POSTGRESQL_DB/
Code: Select all
cp /backdir/POSTGRESQL_DB/pg_hba.conf /share/CACHEDEV1_DATA/.POSTGRESQL_DB/
Code: Select all
cp /backdir/POSTGRESQL_DB/postgresql.conf /share/CACHEDEV1_DATA/.POSTGRESQL_DB/
Code: Select all
./pg_ctl -D /share/CACHEDEV1_DATA/.POSTGRESQL_DB/ start
Code: Select all
./psql -d postgres -f /backupdir/dumpall.bak
Code: Select all
./vaccumdb -a -z
Code: Select all
./psql -l