版本: 9.6
安装
https://www.postgresql.org/download/linux/redhat/
参考:https://blog.csdn.net/weixin_43230682/article/details/108403642
Install PostgreSQL:
sudo yum install -y postgresql96-server
Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-9.6/bin/postgresql96-setup initdb #初始化数据库
sudo systemctl enable postgresql-9.6
sudo systemctl start postgresql-9.6
查看组件:
[root@node201 ~]# rpm -qa|grep postgresql
postgresql96-libs-9.6.21-1PGDG.rhel7.x86_64
postgresql96-9.6.21-1PGDG.rhel7.x86_64
postgresql96-server-9.6.21-1PGDG.rhel7.x86_64
[root@node201 ~]# rpm -ql postgresql96-server-9.6.21-1PGDG.rhel7.x86_64
/etc/pam.d/postgresql
/etc/sysconfig/pgsql
/usr/bin/postgresql-9.6-setup
/usr/lib/systemd/system/postgresql-9.6.service
/usr/lib/tmpfiles.d/postgresql-9.6.conf
/usr/pgsql-9.6/bin/initdb
/usr/pgsql-9.6/bin/pg_controldata
/usr/pgsql-9.6/bin/pg_ctl
/usr/pgsql-9.6/bin/pg_resetxlog
/usr/pgsql-9.6/bin/postgres
/usr/pgsql-9.6/bin/postgresql96-check-db-dir
/usr/pgsql-9.6/bin/postgresql96-setup
/usr/pgsql-9.6/bin/postmaster
/usr/pgsql-9.6/lib
…
/usr/pgsql-9.6/share
/usr/pgsql-9.6/share/conversion_create.sql
/usr/pgsql-9.6/share/extension
/usr/pgsql-9.6/share/extension/plpgsql–1.0.sql
/usr/pgsql-9.6/share/extension/plpgsql–unpackaged–1.0.sql
/usr/pgsql-9.6/share/extension/plpgsql.control
/usr/pgsql-9.6/share/information_schema.sql
…
/var/lib/pgsql
/var/lib/pgsql/9.6
/var/lib/pgsql/9.6/backups
/var/lib/pgsql/9.6/data
/var/run/postgresql
操作数据库
[root@node201 ~]# su - postgres
-bash-4.2$ createdb test #创建数据库
-bash-4.2$ psql #连接数据库
psql (9.6.21)
Type “help” for help.
postgres=#
postgres=# \l #查看所有数据库,默认数据库是postgres
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------±---------±---------±------------±------------±----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
test | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
postgres=# \c #切换连接的数据库
You are now connected to database “postgres” as user “postgres”.
postgres=# \c test #切换到test数据库
You are now connected to database “test” as user “postgres”.
test=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------±---------±---------±------------±------------±----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
test | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
debug日志:
ls /var/lib/pgsql/9.6/data/log/
tail /var/lib/pgsql/9.6/data/pg_log/postgresql-Fri.log
tail /var/lib/pgsql/9.6/data/pg_log/postgresql-Sat.log