투덜이 개발자

postgresql 소스 컴파일 수동 설치 본문

DataBase/Postgresql

postgresql 소스 컴파일 수동 설치

엠투 2022. 1. 18. 14:32
반응형

sudo make
sudo make install

[postgres@gmedia postgresql-13.2]$ mkdir -p /home/postgres/pgsql/data
[postgres@gmedia postgresql-13.2]$ /home/postgres/pgsql/bin/initdb -E utf-8 -D /home/postgres/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /home/postgres/pgsql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Asia/Seoul
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    /home/postgres/pgsql/bin/pg_ctl -D /home/postgres/pgsql/data -l logfile start

PostgreSql 실행

/home/postgres/pgsql/bin/pg_ctl -D /home/postgres/pgsql/data -l logfile start

[postgres@gmedia bin]$ /home/postgres/pgsql/bin/pg_ctl -D /home/postgres/pgsql/data -l logfile start
waiting for server to start.... done
server started

확인

[postgres@gmedia bin]$ ps aux | grep postgres
gitlab-+  2840  0.0  0.6 1174360 24368 ?       Ss    2016   1:13 postgres: gitlab gitlabhq_production [local] idle
root      4340  0.0  0.0 189724  2332 pts/0    S    13:09   0:00 su postgres
postgres  4341  0.0  0.0 115452  2108 pts/0    S    13:09   0:00 bash
gitlab-+  8974  0.0  0.6 1174568 25212 ?       Ss    2016   1:05 postgres: gitlab gitlabhq_production [local] idle
gitlab-+  9021  0.0  0.6 1172552 25596 ?       Ss    2016   1:05 postgres: gitlab gitlabhq_production [local] idle
gitlab-+  9048  0.0  0.6 1172232 24212 ?       Ss    2016   1:02 postgres: gitlab gitlabhq_production [local] idle
gitlab-+  9053  0.0  0.6 1172588 25044 ?       Ss    2016   1:05 postgres: gitlab gitlabhq_production [local] idle
gitlab-+  9057  0.0  0.6 1174608 25724 ?       Ss    2016   1:05 postgres: gitlab gitlabhq_production [local] idle
gitlab-+  9069  0.0  0.6 1173648 24412 ?       Ss    2016   1:04 postgres: gitlab gitlabhq_production [local] idle
root     10661  0.0  0.0   4184    20 ?        Ss    2016   0:06 runsv postgresql

 

 

참고 : https://harulife.kr/111

 

postgresql 소스설치

postgreSQL 다운로드 다운로드는 공식 홈페이지인 https://www.postgresql.org/download/ 받을 수 있습니다. 또는 아래처럼 wget 명령어를 사용하여 다운로드 받을 수도 있습니다. [root@Centos7 ~]# wget https:/..

harulife.kr

 

반응형