SysAdmin/기타
CentOS
jjryu
2020. 7. 18. 15:11
- 배포판 버전 확인
$ grep . /etc/*-release
- 디스크 용량 확인 하기
$ du -h
- Centos 7에 PostgreSQL 11 버전 설치
c.f. # yum install -y postgresql
# rpm -Uvh https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# yum install -y postgresql11-server postgresql11-contrib
# /usr/pgsql-11/bin/postgresql-11-setup initdb
# systemctl start postgresql-11
# systemctl enable postgresql-11
- Centos 7에 PostgreSQL 11버전 외부에서 접속
# su - postgres -c 'psql'
postgres=# ALTER USER postgres PASSWORD <new_password>;
/var/lib/pgsql/11/data/postgresql.conf
listen_addresses = '*'
/var/lib/pgsql/11/data/pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
#local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
host all all 0.0.0.0/0 md5
# systemctl restart postgresql-11
# firewall-cmd --permanent --add-port=5432/tcp
# firewall-cmd --reload