開源數(shù)據(jù)庫postgreSQL13在麒麟v10sp1源碼安裝過程詳解
一、中標(biāo)麒麟v10sp1在飛騰2000+系統(tǒng)安裝略
二、系統(tǒng)依賴包安裝
[root@ft2000db opt]# yum install bzip* [root@ft2000db opt]# nkvers ############## Kylin Linux Version ################# Release: Kylin Linux Advanced Server release V10 (Tercel) Kernel: 4.19.90-17.ky10.aarch64 Build: Kylin Linux Advanced Server release V10 (SP1) /(Tercel)-aarch64-Build04/20200711 ################################################# [root@ft2000db opt] # yum install -y perl-ExtUtils-Embed [root@ft2000db opt]# yum install -y flex root@ft2000db opt]# yum install -y bison root@ft2000db opt]# yum install -y readline-devel root@ft2000db opt]# yum install -y zlib-devel root@ft2000db opt]# yum install -y openssl-devel root@ft2000db opt]# yum install -y pam-devel root@ft2000db opt]# yum install -y libxml2-devel root@ft2000db opt]# yum install -y libxslt-devel root@ft2000db opt]# yum install -y openldap-devel root@ft2000db opt]# yum install -y python-devel root@ft2000db opt]# yum install -y gcc-c++ root@ft2000db opt]# yum install -y libssh2-devel
下載安裝軟件及創(chuàng)建安裝目錄
[root@ft2000db opt]# wget http://ftp.postgresql.org/pub/source/v13.1/postgresql-13.1.tar.bz2 [root@ft2000db opt]# tar xjvf postgresql-13.1.tar.bz2 [root@ft2000db opt]# cd postgresql-13.1/ [root@ft2000db postgresql-13.1]# mkdir -p /opt/pgsql [root@ft2000db postgresql-13.1]# ./configure --prefix=/opt/pgsql ................................................................ configure: creating ./config.status config.status: creating GNUmakefile config.status: creating src/Makefile.global config.status: creating src/include/pg_config.h config.status: creating src/include/pg_config_ext.h config.status: creating src/interfaces/ecpg/include/ecpg_config.h config.status: linking src/backend/port/tas/dummy.s to src/backend/port/tas.s config.status: linking src/backend/port/posix_sema.c to src/backend/port/pg_sema.c config.status: linking src/backend/port/sysv_shmem.c to src/backend/port/pg_shmem.c config.status: linking src/include/port/linux.h to src/include/pg_config_os.h config.status: linking src/makefiles/Makefile.linux to src/Makefile.port
[root@ft2000db postgresql-13.1]# gmake //這里編譯時(shí)間大約30分鐘,如果失敗一般都是系統(tǒng)依賴包原因,根據(jù)提示解決
.............................................................................................................
gmake[2]: 離開目錄“/opt/postgresql-13.1/src/test/isolation” gmake -C test/perl all gmake[2]: 進(jìn)入目錄“/opt/postgresql-13.1/src/test/perl” gmake[2]: 對(duì)“all”無需做任何事。 gmake[2]: 離開目錄“/opt/postgresql-13.1/src/test/perl” gmake[1]: 離開目錄“/opt/postgresql-13.1/src” gmake -C config all gmake[1]: 進(jìn)入目錄“/opt/postgresql-13.1/config” gmake[1]: 對(duì)“all”無需做任何事。 gmake[1]: 離開目錄“/opt/postgresql-13.1/config” All of PostgreSQL successfully made. Ready to install. [root@ft2000db postgresql-13.1]#gmake install
..........................................................................................
gmake[1]: 離開目錄“/opt/postgresql-13.1/src” gmake -C config install gmake[1]: 進(jìn)入目錄“/opt/postgresql-13.1/config” /usr/bin/mkdir -p '/opt/pgsql/lib/pgxs/config' /usr/bin/install -c -m 755 ./install-sh '/opt/pgsql/lib/pgxs/config/install-sh' /usr/bin/install -c -m 755 ./missing '/opt/pgsql/lib/pgxs/config/missing' gmake[1]: 離開目錄“/opt/postgresql-13.1/config” PostgreSQL installation complete.
三、檢查安裝的版本
[root@ft2000db postgresql-13.1]# /opt/pgsql/bin/postgres --version postgres (PostgreSQL) 13.1
創(chuàng)建用戶和組
[root@ft2000db postgresql-13.1]# groupadd -g 1002 postgres [root@ft2000db postgresql-13.1]# useradd -g 1002 -u 1002 postgres [root@ft2000db postgresql-13.1]# passwd postgres [root@ft2000db postgresql-13.1]# chown -R postgres:postgres /opt/ [root@ft2000db postgresql-13.1]# chmod -R 775 /opt/
配置環(huán)境變量
[postgres@ft2000db ~]$ cat .bash_profile # Source /root/.bashrc if user has one [ -f ~/.bashrc ] && . ~/.bashrc # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH PATH=/opt/pgsql/bin:$PATH export PATH LD_LIBRARY_PATH=/opt/pgsql/lib export LD_LIBRARY_PATH
初始化數(shù)據(jù)庫
[postgres@ft2000db ~]$ mkdir -p /opt/pgsql/data [postgres@ft2000db ~]$ initdb -D /opt/pgsql/data The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "zh_CN.UTF-8". The default database encoding has accordingly been set to "UTF8". initdb: could not find suitable text search configuration for locale "zh_CN.UTF-8" The default text search configuration will be set to "simple". Data page checksums are disabled. fixing permissions on existing directory /opt/pgsql/data ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... Asia/Shanghai creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok initdb: warning: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: pg_ctl -D /opt/pgsql/data -l logfile start
啟動(dòng)數(shù)據(jù)庫
[postgres@ft2000db ~]$ pg_ctl -D /opt/pgsql/data start waiting for server to start....2020-11-20 16:01:05.881 CST [34826] LOG: starting PostgreSQL 13.1 on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 7.3.0, 64-bit 2020-11-20 16:01:05.882 CST [34826] LOG: listening on IPv6 address "::1", port 5432 2020-11-20 16:01:05.882 CST [34826] LOG: listening on IPv4 address "127.0.0.1", port 5432 2020-11-20 16:01:05.882 CST [34826] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2020-11-20 16:01:05.884 CST [34827] LOG: database system was shut down at 2020-11-20 16:00:27 CST 2020-11-20 16:01:05.887 CST [34826] LOG: database system is ready to accept connections done server started
登錄數(shù)據(jù)庫
[postgres@ft2000db ~]$ psql -p 5432 psql (13.1) type "help" for help. postgres=#
到此postgresql數(shù)據(jù)庫安裝完畢。
到此這篇關(guān)于開源數(shù)據(jù)庫postgreSQL13在麒麟v10sp1源碼安裝過程詳解的文章就介紹到這了,更多相關(guān)postgreSQL13在麒麟v10sp1源碼安裝內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
相關(guān)文章
解決sqoop從postgresql拉數(shù)據(jù),報(bào)錯(cuò)TCP/IP連接的問題
這篇文章主要介紹了解決sqoop從postgresql拉數(shù)據(jù),報(bào)錯(cuò)TCP/IP連接的問題,具有很好的參考價(jià)值,希望對(duì)大家有所幫助。一起跟隨小編過來看看吧2020-12-12
PgSQl臨時(shí)表創(chuàng)建及應(yīng)用實(shí)例解析
這篇文章主要介紹了PgSQl臨時(shí)表創(chuàng)建及應(yīng)用實(shí)例解析,文中通過示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下2020-12-12
PostgreSQL教程(六):函數(shù)和操作符詳解(2)
這篇文章主要介紹了PostgreSQL教程(六):函數(shù)和操作符詳解(2),本文講解了模式匹配、數(shù)據(jù)類型格式化函數(shù)、時(shí)間/日期函數(shù)和操作符等內(nèi)容,需要的朋友可以參考下2015-05-05
PostgreSQL字符切割:substring函數(shù)的用法說明
這篇文章主要介紹了PostgreSQL字符切割:substring函數(shù)的用法說明,具有很好的參考價(jià)值,希望對(duì)大家有所幫助。一起跟隨小編過來看看吧2021-02-02
PostgreSQL數(shù)據(jù)庫中DISTINCT關(guān)鍵字的四種用法詳解
PostgreSQL 不但高度兼容 SQL 標(biāo)準(zhǔn),同時(shí)還對(duì)很多語法進(jìn)行了擴(kuò)展,可以用于實(shí)現(xiàn)一些特殊的功能,今天我們就來介紹一下 PostgreSQL 數(shù)據(jù)庫中 DISTINCT 關(guān)鍵字的 4 種不同用法,需要的朋友可以參考下2024-04-04
PostgreSQL的generate_series()函數(shù)的用法說明
這篇文章主要介紹了PostgreSQL的generate_series()函數(shù)的用法說明,具有很好的參考價(jià)值,希望對(duì)大家有所幫助。一起跟隨小編過來看看吧2021-01-01
PostgreSQL與MySQL優(yōu)劣勢(shì)比較淺談
這篇文章主要詳細(xì)介紹了PostgreSQL與MySQL有哪些優(yōu)劣勢(shì),文中介紹的非常詳細(xì),對(duì)于學(xué)習(xí)有一定的幫助,感興趣的小伙伴可以參考一下2023-04-04
PostgreSQL中json數(shù)據(jù)類型詳解
json數(shù)據(jù)也可以被存儲(chǔ)為text,但是 與text數(shù)據(jù)類型相比,JSON 數(shù)據(jù)類型的優(yōu)勢(shì)在于能強(qiáng)制要求每個(gè)被存儲(chǔ)的值符合 JSON 規(guī)則,這篇文章主要介紹了PostgreSQL中json數(shù)據(jù)類型,需要的朋友可以參考下2023-04-04

