centos7 运行postgres 数据库脚本db.sql

[root@localhost ~]# su postgres
bash-4.2$ psql
could not change directory to "/root": Permission denied
psql (9.5.6)
Type "help" for help.

postgres=# psql -Upostgres
postgres-# psql -Upostgres</root/Desktop/db.sql

 

[root@localhost dreamstart]# su postgres

bash-4.2$ psql -Upostgres<db.sql

 

 

+ View Code?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

[root@localhost dreamstart]# su postgres bash-4.2$ psql -Upostgres<db.sql CREATE ROLE ALTER ROLE CREATE DATABASE CREATE DATABASE CREATE DATABASE GRANT GRANT GRANT You are now connected to database "dreamstart_dev" as user "postgres". CREATE SCHEMA CREATE EXTENSION ALTER DATABASE ALTER DATABASE ALTER SCHEMA ALTER SCHEMA GRANT You are now connected to database "dreamstart_prod" as user "postgres". CREATE SCHEMA CREATE EXTENSION ALTER DATABASE ALTER DATABASE ALTER SCHEMA ALTER SCHEMA GRANT You are now connected to database "dreamstart_test" as user "postgres". CREATE SCHEMA CREATE EXTENSION ALTER DATABASE ALTER DATABASE ALTER SCHEMA ALTER SCHEMA GRANT bash-4.2$