[POSTGRE] HBA등 설정파일

$PGDATA/pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD # "local" is for Unix domain socket connections only #local   all             all                                     trust local   all             all                                    md5 # IPv4 local connections: #host    all             all             0.0.0.0/0            trust host    all             all             0.0.0.0/0            md5 #host    all             all             127.0.0.1/32            trust # IPv6 local connections: host    all             all             ::1/128                 trust # Allow replication connections from localhost, by a user with the # replication privilege. local   replication     all                                     trust host    replication     all             127.0.0.1/32            trust

-. 패스워드 인증방식

 └ trust : 패스워드 없이 접근 

 └ md5 : 패스워드를 md5로 암호화하여 전송

 

 

$HOME/.psqlrc

\set AUTOCOMMIT OFF    \set PROMPT1 '%M:%> %n@%/%R%#%x'    \set FETCH_COUNT 200    \timing    \pset pager off

 

※패스워드 입력하지 않고 접속

$HOME/.pgpass

IP:PORT:DB_NAME:DB_ID:DB_PWD

127.0.0.1:15432:*:pg:P@ssw0rd   localhost:15432:*:pg:P@ssw0rd