postgres

安装
Ubuntu Xenial (16.04)
sudo add-apt-repository “deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main”
wget –quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.6

Ubuntu Trusty (14.04)
sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main"
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.6

Ubuntu Precise (12.04)
sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main"
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.6

配置访问权限
sudo gedit /etc/postgresql/9.1/main/pg_hba.conf
# “local” is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.1.0/24 md5
# IPv6 local connections:
host all all ::1/128 trust

sudo gedit /etc/postgresql/9.1/main/postgresql.conf
    #listen_addresses=’localhost’
    去掉 #, 改为listen_addresses=’*’

重启服务
sudo service postgres restart
/etc/init.d/postgresql start

重新加载配置文件:
sudo /etc/init.d/postgresql reload

创建用户
sudo su postgres
createuser -P -d -a -e user_name

创建DB
createdb db_name -O user_name
psql
GRANT ALL ON database db_name to user_name;
\q

导入dump文件
psql db_name <文件>
psql -d db_name -t <文件>
psql -d db_name -U user_name -f <文件>
导出文件
pg_dump -h host_ip -U user_name db_name > <文件>

psql -U postgres(用户名)  数据库名(缺省时同用户名) < /data/dum.sql

导入备份文件
pg_restore -FC -O -U postgres -d ${DB_NAME}${backup_file}

select * from seq_resource_bundle;

alter sequence seq_resource_bundle restart with 90601