IT_engineer

https://www.postgresql.org/ftp/source/v13.8/ PostgreSQL: File Browser www.postgresql.org 파일 다운로드 # yum install -y tar bzip2 gcc readline-devel zlib-devel make # tar -xvf 파일명 # sh configure # make # make install # useradd postgres # mkdir /usr/local/pgsql/data # chown postgres /usr/local/pgsql/data # su - postgres vi .bash_profile PATH=$PATH:/usr/local/pgsql/bin PGLIB=/usr/local/pgsql/lib PGDATA=..

OS는 centOS7사용. 방화벽 포트 5432/tcp 오픈 설치중 좀 어이없는 상황이 발생해서 정리... sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm sudo dnf -qy module disable postgresql sudo dnf install -y postgresql13-server sudo /usr/pgsql-13/bin/postgresql-13-setup initdb sudo systemctl enable postgresql-13 sudo systemctl start postgresql-13 설치를 하고 난뒤 initdb..

postgreSQL 14버전 설치 및 외부 접속 설정. OS는 centOS7사용. 방화벽 포트 5432/tcp 오픈 https://www.postgresql.org/download/linux/redhat/ PostgreSQL: Linux downloads (Red Hat family) Linux downloads (Red Hat family) The Red Hat family of distributions includes: Red Hat Enterprise Linux Rocky Linux CentOS (7 and 6 only) Fedora Oracle Linux and others. PostgreSQL is available on these platforms by default. However, each..