postgresql启停、建库、建用户

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]$