一、配置Postgresql免密码登录@H_502_7@

vi /var/lib/pgsql/9.2/data/postgresql.conf
@H_502_7@

listen_addresses = '*' 修改为监听所有ip地址的连接请求
@H_502_7@

@H_502_7@

vi /var/lib/pgsql/9.2/data/pg_hba.conf
@H_502_7@

@H_502_7@

任意网段中的任意主机；trust——免密码登录@H_502_7@

host all all 0.0.0.0/0 trust@H_502_7@

二、@H_502_7@

使用postgres登录psql -h 127.0.0.1 -p 5432 -U postgres，登录后却出现以下问题，@H_502_7@

postgres=> create database d1;
ERROR: permission denied to create database
postgres=> CREATE ROLE tdw;
ERROR: permission denied to create role
postgres=> drop role dd;
ERROR: permission denied to drop role
postgres=> ALTER USER postgres WITH SUPERUSER;
ERROR: must be superuser to alter superusers
@H_502_7@

解决：
@H_502_7@

[root@bigdata2 data]# sudo -u postgres /usr/pgsql-9.2/bin/postgres --single -D /var/lib/pgsql/9.2/data/
Postgresql stand-alone backend 9.2.8
backend> ALTER USER postgres WITH SUPERUSER;
backend>
@H_502_7@

查看：@H_502_7@

@H_502_7@

三、
@H_502_7@

postgres=> drop database global;
ERROR: must be owner of database global
@H_502_7@

解决：
@H_502_7@

使用global的owner用户登录，psql -h 127.0.0.1 -p 5432 -U hive-d postgres@H_502_7@

四、命令总结@H_502_7@

@H_502_7@

service postgresql-9.2 stop
service postgresql-9.2 start
service postgresql-9.2 status@H_502_7@

@H_502_7@

[root@jstorm3 build]# psql --version
psql (Postgresql) 9.2.8
@H_502_7@

@H_502_7@

登录PG@H_502_7@

psql -h 127.0.0.1 -p 5432 -U postgres
指定数据库
psql -h 127.0.0.1 -p 5432 -U postgres -d postgres
@H_502_7@

查看所有用户密码@H_502_7@

select * from pg_shadow;
@H_502_7@

修改用户密码@H_502_7@

ALTER USER hive WITH PASSWORD '123456';
@H_502_7@

@H_502_7@

ALTER TABLE public.pb_proto_jar OWNER TO postgres;@H_502_7@

@H_502_7@

CREATE TABLE t1(cdate TIMESTAMP,c2 INT);@H_502_7@

INSERT INTO t1 VALUES(now(),1);@H_502_7@