1 下载源码,编译
2 /etc/profile配置环境变量,加入path;加PGDATA=/home/pgdata
3 初始化initdb -D $PGDATA
4 启动 pg_ctl start -D $PGDATA
5 psql postgres客户端连接
6 查看
create database db_hi;
\c db_hi;
create table hello(name char(20),age int);
insert into hello values('zs',30);
select * from hello;
mac下简单使用
mac 安装postgres11.5 brew install postgres pgdata=~/pgdata initdb -D $pgdata pg_ctl -D ~ -l $pgdata/server.log start createuser hello -P createdb hellodb -O hello -E UTF8 -e psql -U hello -d hellodb hellodb=> \c hellodb You are now connected to database "hellodb" as user "hello". hellodb=> create table test(id int, name varchar(20),gender varchar(20)); CREATE TABLE hellodb=> select * from test; 使用jdbc插入数据后再查 hellodb=> select * from test; pg_ctl -D $pgdata -l $pgdata/server.log stop