ubuntu-remove postgresql and install new version

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