1. 错误, 允许本地连接： -bash-4.1$ psql mydb psql: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "mydb", SSL off 在配置文件：pg_hba.conf增加如下内容 # IPv4 local connections: #允许本地连接 local all all trust #允许远程连接 host all all 0.0.0.0/0 md5 2. 推出psql命令行 \q mydb-# \q -bash-4.1$ 3. 类似于oracle sqlplus mydb=# select version(); version ------------------------------------------------------------------------------------------------------------------- PostgreSQL 8.4.20 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-17), 64-bit (1 row) mydb=# select current_date; date ------------ 2017-05-18 (1 row)
