婷婷综合国产,91蜜桃婷婷狠狠久久综合9色 ,九九九九九精品,国产综合av

主頁 > 知識庫 > 開源數據庫postgreSQL13在麒麟v10sp1源碼安裝過程詳解

開源數據庫postgreSQL13在麒麟v10sp1源碼安裝過程詳解

熱門標簽:江蘇400電話辦理官方 濟南外呼網絡電話線路 電話機器人怎么換人工座席 廣州電銷機器人公司招聘 電銷機器人能補救房產中介嗎 地圖標注要花多少錢 移動外呼系統模擬題 天津開發區地圖標注app 400電話申請客服

一、中標麒麟v10sp1在飛騰2000+系統安裝略

二、系統依賴包安裝

[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

下載安裝軟件及創建安裝目錄

[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 //這里編譯時間大約30分鐘,如果失敗一般都是系統依賴包原因,根據提示解決
.............................................................................................................

gmake[2]: 離開目錄“/opt/postgresql-13.1/src/test/isolation”
gmake -C test/perl all
gmake[2]: 進入目錄“/opt/postgresql-13.1/src/test/perl”
gmake[2]: 對“all”無需做任何事。
gmake[2]: 離開目錄“/opt/postgresql-13.1/src/test/perl”
gmake[1]: 離開目錄“/opt/postgresql-13.1/src”
gmake -C config all
gmake[1]: 進入目錄“/opt/postgresql-13.1/config”
gmake[1]: 對“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]: 進入目錄“/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

創建用戶和組

[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/

配置環境變量

[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

初始化數據庫

[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

啟動數據庫

[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

登錄數據庫

[postgres@ft2000db ~]$ psql -p 5432
psql (13.1)
type "help" for help.

postgres=#

到此postgresql數據庫安裝完畢。

到此這篇關于開源數據庫postgreSQL13在麒麟v10sp1源碼安裝過程詳解的文章就介紹到這了,更多相關postgreSQL13在麒麟v10sp1源碼安裝內容請搜索腳本之家以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持腳本之家!

您可能感興趣的文章:
  • postgresql 利用xlog進行熱備操作
  • Postgresql中xlog生成和清理邏輯操作
  • Postgresql去重函數distinct的用法說明
  • postgresql 12版本搭建及主備部署操作
  • postgresql初始化之initdb的使用詳解
  • postgresql 如何查看pg_wal目錄下xlog文件總大小
  • postgresql之使用lsn 獲取 wal文件名的實例
  • PostgreSQL 實現定時job執行(pgAgent)

標簽:溫州 杭州 辛集 寶雞 昭通 濮陽 海西 榆林

巨人網絡通訊聲明:本文標題《開源數據庫postgreSQL13在麒麟v10sp1源碼安裝過程詳解》,本文關鍵詞  開源,數據庫,postgreSQL13,;如發現本文內容存在版權問題,煩請提供相關信息告之我們,我們將及時溝通與處理。本站內容系統采集于網絡,涉及言論、版權與本站無關。
  • 相關文章
  • 下面列出與本文章《開源數據庫postgreSQL13在麒麟v10sp1源碼安裝過程詳解》相關的同類信息!
  • 本頁收集關于開源數據庫postgreSQL13在麒麟v10sp1源碼安裝過程詳解的相關信息資訊供網民參考!
  • 推薦文章
    主站蜘蛛池模板: 榕江县| 尖扎县| 三河市| 松江区| 安阳县| 上饶市| 汨罗市| 大连市| 蓝山县| 根河市| 旬邑县| 保德县| 班戈县| 航空| 增城市| 观塘区| 绍兴县| 昂仁县| 日喀则市| 江达县| 河曲县| 东城区| 韶关市| 安岳县| 赤峰市| 无棣县| 绿春县| 曲靖市| 日喀则市| 平顺县| 英德市| 松桃| 准格尔旗| 怀宁县| 巴里| 崇仁县| 青河县| 新乡县| 贵定县| 石河子市| 巴林左旗|