centos7에 postgresql13 설치하기

  1.   vi /etc/security/limits.conf
       postgres        soft      nofile        65535 

        postgres        hard      nofile        65535

  2.  vi /etc/sysctl.conf

        fs.file-max = 65535

  3.   sysctl -p

  4.  yum -y install gcc gcc-c++ make autoconf readline readline-devel zlib zlib-devel openssl openssl-devel gettext gettext-devel python python-devel wget

  5.   sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

  6.   yum -y update

  7.   yum -y install postgresql13 postgresql13-server

  8.   /usr/pgsql-13/bin/postgresql-13-setup initdb

  9.   systemctl status postgresql-13

  10.   systemctl start postgresql-13

  11.   systemctl status postgresql-13

  12.   systemctl enable postgresql-13

이후 초기 설정

1. su – postgresql
2. psql -c ” ‘패스워드 복잡하게 ALTER ROLE

3. $ sudo vi /var/lib/pgsql/13/data/postgresql.conf

          # 59 행

          listen_addresses = ‘192.168.0.80’

4. 원격 접속 설정

       $ sudo vi /var/lib/pgsql/13/data/pg_hba.conf

5. 어디서든 수락 (권장하지 않음)

        host all  all 0.0.0.0/0 md5

6. 특정대역에서 접속

      host all  all 192.168.0.0/24 md5

7. sudo systemctl restart postgresql-13

8. 접속테스트

     $ sudo -iu postgres psql