1, 环境规划
目录名称 | 存放位置 |
---|---|
Postgres 用户家目录 | /home/postgres |
软件存放目录 | /home/soft |
安装目录 | /usr/local |
数据目录 | /home/postgres/data/ |
2, 安装流程
2.1 解压安装
在操作系统安装完成后, 按照表格规划目录.
1) 安装部署参考文档
下载页:
软件包: PostgreSQL-10.7-2-Linux-x64-binaries.tar.gz
2) 创建 postgre 安装用户
- useradd postgres
- passwd postgres
3) 创建 postgre 安装目录及数据目录
- mkdir -p /home/postgres/data/
- chown -R postgres:postgres /home/postgres/data/
- chmod -R 775 /home/postgres/data/
4) 解压安装
- tar -xvf PostgreSQL-10.8-4-Linux-x64-binaries.tar -C /home/postgres/
- [[email protected] postgres]# chmod -R 777 pgsql
- [[email protected] postgres]# ll
- total 12
- drwxrwxrwx 9 root root 4096 Apr 10 03:24 pgsql
- drwx------ 19 postgres postgres 4096 Apr 15 11:33 pgsql_data
5) 初始化数据库
- [[email protected] bin]$cd /home/postgres/pgsql/bin
- [[email protected] bin]$ ./initdb -D /home/postgres/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 "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english".
- Data page checksums are disabled.
- fixing permissions on existing directory /home/postgres/data ... ok creating subdirectories ... ok
- selecting default max_connections ... 100
- selecting default shared_buffers ... 128MB
- selecting dynamic shared memory implementation ... posix creating configuration files ... ok
- running Bootstrap script ... ok
- performing post-Bootstrap initialization ... ok
- syncing data to disk ... ok
- 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 /home/postgres/data/ -l logfile start
6) 启动数据库
- [[email protected] bin]$ ./pg_ctl -D /home/postgres/data/ -l logfile start
- waiting for server to start.... done
- server started
7) 停止数据库
./pg_ctl -D /home/postgres/data/ stop
来源: http://www.bubuko.com/infodetail-3105149.html