centos7上安装postgresql11 Beta2版

最新推荐文章于 2023-09-18 11:08:39 发布

原创最新推荐文章于 2023-09-18 11:08:39 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#postgresql #centos #postgresql11

postgresql 专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了如何从源代码安装并配置PostgreSQL数据库，包括下载安装包、解压编译、创建用户组和用户、建立数据文件目录、初始化数据库、修改配置文件、启动数据库以及验证数据库是否成功启动。

1.下载安装包

https://ftp.postgresql.org/pub/source/v11beta2/postgresql-11beta2.tar.gz

2.解压编译

tar -zxvf postgresql-11beta2.tar.gz

configure

make

make install

3.生成postgres组和用户

[root@localhost usr]# groupadd postgres
[root@localhost usr]# useradd -g postgres postgres
[root@localhost usr]# passwd postgres

4.建立数据文件目录

root@localhost bin]# mkdir /usr/pgdata
[root@localhost bin]# chown -R postgres:postgres /usr/pgdata
[root@localhost bin]# chmod 700 /usr/pgdata

5.初始化数据库

[postgres@localhost bin]$ ./initdb -D /usr/pgdata/
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 /usr/pgdata … 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 /usr/pgdata/ -l logfile start

6.修改配置文件

vim postgresql.conf

listen_addresses = ‘*’

port = 5432

7.启动数据库

[postgres@localhost bin]$ ./pg_ctl start -D /usr/pgdata/
waiting for server to start…2018-08-07 10:18:44.704 CST [15690] LOG: listening on IPv4 address “0.0.0.0”, port 5432
2018-08-07 10:18:44.704 CST [15690] LOG: listening on IPv6 address “::”, port 5432
2018-08-07 10:18:44.707 CST [15690] LOG: listening on Unix socket “/tmp/.s.PGSQL.5432”
2018-08-07 10:18:44.869 CST [15700] LOG: database system was shut down at 2018-08-07 10:14:35 CST
2018-08-07 10:18:44.903 CST [15690] LOG: database system is ready to accept connections
done
server started
[postgres@localhost bin]$

8.验证

[postgres@localhost bin]$ ./psql
psql (11beta2)
Type “help” for help.