How to upgrade postgres 9.3 to 9.4 in ubuntu
1. Create file /etc/apt/sources.list.d/pgdg.list
Make /etc/apt/sources.list.d/pgdg.list and add a line below.
deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main
2. apt-get update
After saving pgdg.list, import repository signing key and update package list.
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
sudo apt-key add -
sudo apt-get update
3. Install postgres 9.4
sudo apt-get install postgresql-9.4
Then check 9.4 version well
psql --version
psql (PostgreSQL) 9.4.17
For more information, check postgres official docs
'backend > sql (postgres)' 카테고리의 다른 글
| Postgres: 한글 정렬 (Collate) (0) | 2018.06.29 |
|---|---|
| Django: connect to mysql with django (0) | 2018.04.19 |
| Postgres: pg_dump: aborting because of server version mismatch Error (0) | 2018.04.17 |
| Postgres: ubuntu 14.04 에서 password 없이 postgres 접속 (0) | 2018.04.02 |
| RDS에서 로컬로 postgres pg_dump해서 데이터 가져오기 (0) | 2018.03.16 |