时间:2021-07-01 10:21:17 帮助过:18人阅读
[root@hst init.d]# su - postgres
-bash-4.1$ createuser --superuser dbuser
-bash-4.1$ psql
psql (9.3.5)
Type "help" for help.
postgres=# alter user dbuser with password ‘dbuser‘;
postgres=# create database demo with encoding=‘UTF8‘ owner=dbuser;
cd /home/dotop
vi db_backup.sh
Linux配置postgresql自动备份
标签:body res database 系统 127.0.0.1 pgsql 编写 log creat