# 리눅스#. yum을 통해 Postgre를 설치했다면, Extention을 사용하기 위해서는 yum install postgre16.1-contribsource로 설치했으면 contrib이 디렉토리에 존재함 1. Passwordcheck 모듈사용wget https://raw.githubusercontent.com/michaelpq/pg_plugins/main/passwordcheck_extra/passwordcheck_extra.cmv passwordcheck.c passwordcheck.c_orgwget https://raw.githubusercontent.com/michaelpq/pg_plugins/main/passwordcheck_extra/passwordcheck_extra.cmv passwor..
$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 ..
1. 수동 설치 파일 가져오기 wget https://ftp.postgresql.org/pub/source/v16.1/postgresql-16.1.tar.gz --no-check-certificate http://ftp.postgresql.org/pub/source/ Index of /pub/source/ ftp.postgresql.org https://www.enterprisedb.com/download-postgresql-binaries Community DL Page Download PostgreSQL Binaries The links below allow you to download archives of the files installed by our PostgreSQL installers. Th..
1. 수동 설치 파일 가져오기 (옛날버전 10.23* 까지만 지원) https://www.enterprisedb.com/download-postgresql-binaries wget https://sbp.enterprisedb.com/getfile.jsp?fileid=1258254 --no-check-certificate 2. 유저, 그룹 추가 groupadd dba useradd pgre passwd pgre usermod -g dba pgre chown pgre:dba postgresql-16.1.tar.gz 3. 압축해제 tar -zxvf postgresql-10.23-1-linux-x64-binaries.tar.gz 4. bash_profile export POSTGRES_HOME=/home/pgr..