Bii o ṣe le Fi PostgreSQL 9.6 sori Debian ati Ubuntu

PostgreSQL jẹ agbara, iwọn ti o ga julọ, orisun ṣiṣi ati agbekọja-pẹpẹ ipilẹ-nkan data isomọ data ti o ṣiṣẹ lori awọn ọna ṣiṣe Unix-bii pẹlu Linux ati Windows OS. O jẹ eto ibi ipamọ data ipele ti iṣowo eyiti o jẹ igbẹkẹle ga julọ ati pe o funni ni iduroṣinṣin data ati atunṣe si awọn olumulo.

Ninu nkan wa tẹlẹ, a ti ṣe alaye fifi sori PostgreSQL 10 lori CentOS/RHEL ati Fedora. Ninu àpilẹkọ yii, a yoo ṣalaye bi a ṣe le fi sori ẹrọ PostgreSQL 9.6 lori Debian, Ubuntu ati awọn itọsẹ rẹ nipa lilo ibi ipamọ APT osise PostgreSQL.

Ṣafikun Ibi ipamọ APT PostgreSQL

Ibi ipamọ APT osise yii yoo darapọ pẹlu eto Lainos rẹ ati nfunni awọn imudojuiwọn aifọwọyi fun gbogbo awọn ẹya atilẹyin ti PostgreSQL lori awọn pinpin Debian ati Ubuntu.

Lati ṣafikun ibi ipamọ ti o yẹ, akọkọ ṣẹda faili /etc/apt/sources.list.d/pgdg.list , ati ṣafikun ila kan fun ibi ipamọ bi fun pinpin rẹ.

--------------- On Ubuntu 17.04 ---------------
deb http://apt.postgresql.org/pub/repos/apt/ zesty-pgdg main

--------------- On Ubuntu 16.04 ---------------
deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main

--------------- On Ubuntu 14.04 ---------------
deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main

--------------- On Stretch 9.x ---------------
deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main

--------------- On Jessie 8.x ---------------
deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main

--------------- On Wheezy 7.x ---------------
deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main

Lẹhinna gbe bọtini iforukọsilẹ ibi ipamọ wọle, ki o ṣe imudojuiwọn awọn atokọ eto eto bii eleyi.

$ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
$ sudo apt update

Fi sori ẹrọ Server PostgreSQL

Lọgan ti o ba ti ṣafikun ibi ipamọ apọju PostgreSQL ninu pinpin kaakiri Linux rẹ, ni bayi fi olupin PostgreSQL ati awọn idii alabara sori ẹrọ gẹgẹbi atẹle:

$ sudo apt install postgresql-9.6-server postgresql-9.6

Pataki: Ko dabi RHEL/CentOS/Fedora nibiti o ni lati fi ọwọ bẹrẹ ipilẹ eto data, ni Ubuntu/Debian, o ti ṣe ipilẹṣẹ laifọwọyi. Nitorinaa tẹsiwaju tẹsiwaju lati bẹrẹ olupin data bi a ti ṣalaye ninu abala atẹle.

Ilana data PostgreSQL /var/lib/postgresql/9.6/main ni gbogbo awọn faili data fun ibi ipamọ data naa.

Bẹrẹ ati Jeki Server PostgreSQL

Pẹlu olupin ipilẹ data ti bẹrẹ, bẹrẹ iṣẹ PostgreSQL ki o mu iṣẹ PostgreSQL ṣiṣẹ lati bẹrẹ aifọwọyi lori bata eto bi eleyi.

--------------- On SystemD --------------- 
$ sudo systemctl start postgresql.service
$ sudo systemctl enable postgresql.service 
$ sudo systemctl status postgresql.service 

--------------- On SysVinit --------------- 
$ sudo service postgresql-9.6 start
$ sudo chkconfig postgresql on
$ sudo service postgresql-9.6 status

Daju fifi sori PostgreSQL

Lẹhin fifi sori ẹrọ eto data PostgreSQL lori olupin rẹ, jẹrisi fifi sori rẹ nipa sisopọ si olupin ibi ipamọ data postgres. Olumulo olutọju PostgreSQL ni orukọ bi postgres, tẹ aṣẹ yii lati wọle si akọọlẹ eto olumulo.

$ sudo su postgres
# cd
# psql

Lati ṣeto ọrọ igbaniwọle kan fun olumulo olutọju ibi ipamọ data, lo aṣẹ yii:

postgres=# \password postgres

Lati ni aabo iwe eto olumulo olumulo postgre, lo pipaṣẹ igbaniwọle ni isalẹ.

$ sudo passwd postgres 

Enter new UNIX password: 
Retype new UNIX password: 
passwd: password updated successfully

$su - postgre
$ ls
$ psql

Fun alaye diẹ sii, lọ si oju-iwe akọọkan PostgreSQL: https://www.postgresql.org/

Ni ikẹhin, tun ka nipasẹ awọn nkan wọnyi nipa awọn eto iṣakoso data olokiki:

Fifi sori MariaDB 10.1 ni Debian Jessie ati Ṣiṣe Awọn oriṣiriṣi Awọn ibeere MariaDB
Bii o ṣe le Yi ilana data MySQL Aiyipada/MariaDB pada ni Linux
Fi sori ẹrọ MongoDB Edition Edition 3.2 lori Awọn ọna ṣiṣe Linux

Iyẹn ni gbogbo fun bayi! Lati pin eyikeyi awọn ero pẹlu wa, ṣe lilo fọọmu esi ni isalẹ. Ranti lati wa nigbagbogbo sopọ si linux-console.net fun awọn nkan Linux ti o nifẹ si.