Otu esi etinye PostgreSQL 9.6 na Debian na Ubuntu
PostgreSQL bụ ihe dị ike, nke nwere ike ịgbatị nke ukwuu, ebe mepere emepe yana sistemụ nchekwa data ihe jikọrọ ihe na-agba ọsọ na sistemụ arụmọrụ Unix gụnyere Linux na Windows OS. Ọ bụ sistemụ nchekwa data ọkwa ụlọ ọrụ bụ nke a pụrụ ịdabere na ya nke ukwuu ma na-enye ndị ọrụ data iguzosi ike n'ezi ihe na izi ezi.
N'isiokwu anyị gara aga, anyị akọwala PostgreSQL 10 ntinye na CentOS/RHEL na Fedora. N'isiokwu a, anyị ga-akọwa otu esi etinye PostgreSQL 9.6 na Debian, Ubuntu na usoro ya site na iji ebe nchekwa PostgreSQL APT.
Tinye ebe nchekwa PostgreSQL APT
Ụlọ ọrụ nchekwa PostgreSQL APT a ga-ejikọta ya na sistemụ Linux gị ma na-enye mmelite akpaka maka ụdị PostgreSQL niile akwadoro na nkesa Debian na Ubuntu.
Iji tinye ebe nchekwa dabara adaba, buru ụzọ mepụta faịlụ /etc/apt/sources.list.d/pgdg.list, ma tinye ahịrị maka ebe nchekwa ahụ dịka nkesa gị si dị.
--------------- 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
Webata igodo mbinye aka n'ebe nchekwa, wee melite ndepụta ngwugwu sistemụ dị ka nke a.
$ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - $ sudo apt update
Wụnye ihe nkesa PostgreSQL
Ozugbo ị gbakwunyere ebe nchekwa PostgreSQL kwesịrị ekwesị na nkesa Linux gị, tinyezie ihe nkesa PostgreSQL na ngwugwu ndị ahịa dị ka ndị a:
$ sudo apt install postgresql-9.6-server postgresql-9.6
Ihe dị mkpa: N'adịghị ka na RHEL/CentOS/Fedora ebe ị ga-eji aka gị malite usoro nchekwa data, na Ubuntu/Debian, a na-ebute ya na akpaghị aka. Ya mere, gaa n'ihu ịmalite ihe nkesa nchekwa data dịka akọwara na ngalaba na-esote.
Akwụkwọ ndekọ data PostgreSQL
Malite ma mee ka sava PostgreSQL rụọ ọrụ
Site na mmalite ihe nkesa nchekwa data, bido ọrụ PostgreSQL wee mee ka ọrụ PostgreSQL nwee ike ịmalite na sistemụ buut dị ka nke a.
--------------- 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
Nyochaa nwụnye PostgreSQL
Mgbe ị wụnye sistemụ nchekwa data PostgreSQL na sava gị, nyochaa nrụnye ya site na ijikọ na sava nchekwa data postgres. A na-akpọ onye ọrụ nchịkwa PostgreSQL dị ka postgres, pịnye iwu a ka ịnweta akaụntụ sistemụ onye ọrụ.
$ sudo su postgres # cd # psql
Ka ịtọọ paswọọdụ maka onye ọrụ nchekwa data postgre, jiri iwu a:
postgres=# \password postgres
Iji chekwaa akaụntụ sistemụ onye ọrụ postgre, jiri iwu paswọọdụ dị n'okpuru.
$ sudo passwd postgres Enter new UNIX password: Retype new UNIX password: passwd: password updated successfully $su - postgre $ ls $ psql
Maka ozi ndị ọzọ, gaa na ebe obibi PostgreSQL: https://www.postgresql.org/
N'ikpeazụ, gụọkwa site na akụkọ ndị a gbasara sistemu njikwa nchekwa data ama ama:
- Ịwụnye MariaDB 10.1 na Debian Jessie na-agba ọsọ dị iche iche MariaDB ajụjụ
- Etu esi agbanwe akwụkwọ ndekọ data MySQL/MariaDB na Linux
- Otu esi etinye ma chekwaa MariaDB 10 na CentOS 7
- Otu esi etinye ma chekwaa MariaDB 10 na CentOS 6
- Wụnye MongoDB Community Edition 3.2 na Linux Sistemu
Nke ahụ bụ ihe niile ugbu a! Iji soro anyị kerịta echiche ọ bụla, jiri ụdị nzaghachi dị n'okpuru. Cheta ka ị na-ejikọ na linux-console.net mgbe niile maka ihe Linux na-atọ ụtọ.