Step1:將原本confluence資料庫DUMP 出來
(or pg_dump -Fc confluence > /tmp/confluence.backup)
Step2:確認目前安裝那些postgresql
Step3:移除POSTGRESQL
Step4:移除postgresql8.3
Step5: 刪除postgresql 資料匣
Step6:
sudo apt-get install postgresql-9.3
Step7:delete database and create new empty database
Additional information:
$ psql -U postgres
psql (9.4.4)
Type "help" for help.
postgres=# CREATE ROLE confluence with password 'confluence' LOGIN CREATEDB CREATEROLE VALID UNTIL 'infinity';
postgres=# CREATE DATABASE confluence WITH ENCODING 'utf8' OWNER confluence;
postgres=# \q
改postgres密碼:alter user postgres password 'apassword';
Step8:設定的過程會出現下列錯誤訊息
Step9:修改下列設定檔
Step10:
https://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge
https://www.liquidweb.com/kb/what-is-the-default-password-for-postgresql/
https://medium.com/@tk512/upgrading-postgresql-from-9-3-to-9-4-on-ubuntu-14-04-lts-2b4ddcd26535
https://askubuntu.com/questions/633919/how-install-postgresql-9-4
https://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge