postgresql启停、建库、建用户

最新推荐文章于 2024-10-08 10:29:44 发布

原创最新推荐文章于 2024-10-08 10:29:44 发布 · 1.1k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#postgresql #pgsql

本文介绍了如何使用shell脚本启动和停止PostgreSQL数据库，并展示了创建新数据库、指定用户以及修改用户密码的过程。通过`startPgsql.sh`和`stopPgsql.sh`脚本实现数据库的启停，使用`pg_ctl`命令检查数据库状态并管理用户权限。

1.启停脚本

[pgsql@localhost pgsql13.3]$ pwd
/home/pgsql/pgsql13.3
[pgsql@localhost pgsql13.3]$ cat startPgsql.sh
#!/bin/bash
. $HOME/.bash_profile
$HOME/pgsql13.3/bin/pg_ctl -D $HOME/pgsql13.3/data -l $HOME/pgsql13.3/log/pgsql.log start

[pgsql@localhost pgsql13.3]$ cat stopPgsql.sh
#!/bin/bash
. $HOME/.bash_profile
$HOME/pgsql13.3/bin/pg_ctl stop -D $HOME/pgsql13.3/data

[pgsql@localhost pgsql13.3]$ $HOME/pgsql13.3/bin/pg_ctl status $HOME/pgsql13.3/data
pg_ctl: too many command-line arguments (first is "status")
Try "pg_ctl --help" for more information.
#查看状态
[pgsql@localhost pgsql13.3]$ $HOME/pgsql13.3/bin/pg_ctl status -D $HOME/pgsql13.3/data
pg_ctl: server is running (PID: 408880)
/home/pgsql/pgsql13.3/bin/postgres "-D" "/home/pgsql/pgsql13.3/data"
[pgsql@localhost pgsql13.3]$

2.建库，指定用户

[pgsql@localhost bin]$ pwd
/home/pgsql/pgsql13.3/bin
[pgsql@localhost bin]$ createdb -U pgsql pgdb01 #建库 -U 指定新库的超级用户
[pgsql@localhost bin]$ psql -d pgdb01 -U pgsql #连接数据库
psql (13.3)
Type "help" for help.
pgdb01=# alter user pgsql with password '123456';#改密码
ALTER ROLE
pgdb01=# exit
[pgsql@localhost bin]$