<![CDATA[
<h4 style="box-sizing: border-box; font-family: 나눔고딕, NanumGothic, 돋움, Dotum; line-height: normal; color: rgb(10, 36, 106); margin-top: 18px; margin-bottom: 10px; font-size: 16pt; padding: 0px;">PostgreSQL(DB) 디렉토리 구조</h4><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">PostgreSQL(DB)를 설치하고 나면 아래와 같은 구조로 구성된다.</p><ul class="lecture_ul" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; list-style-position: initial; list-style-image: initial; width: 821px; padding: 1px 0px 3px; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum; font-size: 15px;"><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><span style="box-sizing: border-box; font-weight: 700;">[그림] 엔진 디렉토리 구조화면</span></li><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><a href="http://www.gurubee.net/imgs/postgresql/basic/3.4.1.jpg" rel="lightbox" style="box-sizing: border-box; background-color: transparent; color: rgb(51, 122, 183);"><img alt="PostgreSQL Configuration 구성" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.gurubee.net%2Fimgs%2Fpostgresql%2Fbasic%2F3.4.1.jpg" style="box-sizing: border-box; border: none; vertical-align: middle; max-width: 90%;"></a></li></ul><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><ul class="lecture_ul" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; list-style-position: initial; list-style-image: initial; width: 821px; padding: 1px 0px 3px; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum; font-size: 15px;"><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><span style="box-sizing: border-box; font-weight: 700;">[표] 엔진 디렉토리 구조에 대한 설명</span></li><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><table class="confluenceTable" style="box-sizing: border-box; border-spacing: 0px; border-collapse: collapse; background-color: transparent; line-height: 14pt; list-style: none; margin: 10px 0px; padding: 0px; width: 811px;"><tbody style="box-sizing: border-box;"><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><th class="confluenceTh" style="box-sizing: border-box; padding: 5px; text-align: center; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); background-color: rgb(240, 240, 240); vertical-align: top; line-height: 14pt; list-style: none;">디렉토리</th><th class="confluenceTh" style="box-sizing: border-box; padding: 5px; text-align: center; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); background-color: rgb(240, 240, 240); vertical-align: top; line-height: 14pt; list-style: none;">내용</th></tr><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none; text-align: center;">bin</td><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none;">postgreSQL(DB)에서 사용하는 실행파일 위치</td></tr><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none; text-align: center;">data</td><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none;">DB의 Data디렉토리</td></tr><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none; text-align: center;">doc</td><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none;">Documentation 파일 위치</td></tr><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none; text-align: center;">pg_env.sh</td><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none;">환경변수 설정 파일</td></tr><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none; text-align: center;">include</td><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none;">Header files 위치(Cluster 생성 시에 사용됨)</td></tr><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none; text-align: center;">installer/scripts</td><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none;">Installer files</td></tr><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none; text-align: center;">lib</td><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none;">PostgreSQL(DB)에 필요한 library 위치</td></tr><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none; text-align: center;">pgAdmin3</td><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none;">그래픽 관리자 Tool</td></tr><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none; text-align: center;">stackbuilder</td><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none;">GUI기반의 업데이트 관리 Tool</td></tr><tr style="box-sizing: border-box; line-height: 14pt; list-style: none;"><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none; text-align: center;">uninstall-postgresql/<br style="box-sizing: border-box;">uninstall-postgresal.dat</td><td class="confluenceTd" style="box-sizing: border-box; padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204); vertical-align: top; font-size: 14px; line-height: 14pt; list-style: none;">PostgreSQL 제거를 위한 uninstall 파일</td></tr></tbody></table></li></ul><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">그 중에서도 data 디렉토리는 PostgreSQL(DB)의 Data정보가 저장되는 디렉터리로 PostgreSQL(DB)에 대한 Data에 대한 정보, 트랜잭션 로그 정보, 환경설정 부분 등에 대한 파일들이 위치하게 된다. data 디렉토리에 대한 구조와 형식에 대해서 살펴보면 아래와 같다.</p><ul class="lecture_ul" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; list-style-position: initial; list-style-image: initial; width: 821px; padding: 1px 0px 3px; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum; font-size: 15px;"><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><span style="box-sizing: border-box; font-weight: 700;">[그림] Data 디렉토리 정보</span></li><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><a href="http://www.gurubee.net/imgs/postgresql/basic/3.4.2.jpg" rel="lightbox" style="box-sizing: border-box; background-color: transparent; color: rgb(51, 122, 183);"><img alt="PostgreSQL Configuration 구성" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.gurubee.net%2Fimgs%2Fpostgresql%2Fbasic%2F3.4.2.jpg" style="box-sizing: border-box; border: none; vertical-align: middle; max-width: 90%;"></a></li></ul><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">PostgreSQL(DB)에서는 하나의 서버의 인스턴스에서 관리되는 database의 모음을 cluster라고 한다. 이때, cluster는 아래 그림에서 data 디렉토리에 해당된다.</p><ul class="lecture_ul" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; list-style-position: initial; list-style-image: initial; width: 821px; padding: 1px 0px 3px; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum; font-size: 15px;"><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><span style="box-sizing: border-box; font-weight: 700;">[그림] data(cluster) directory structure</span></li><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><a href="http://www.gurubee.net/imgs/postgresql/basic/3.4.3.jpg" rel="lightbox" style="box-sizing: border-box; background-color: transparent; color: rgb(51, 122, 183);"><img alt="PostgreSQL Configuration 구성" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.gurubee.net%2Fimgs%2Fpostgresql%2Fbasic%2F3.4.3.jpg" style="box-sizing: border-box; border: none; vertical-align: middle; max-width: 90%;"></a></li></ul><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">data 디렉토리 내에 base라는 디렉토리가 위치한다. base 디렉토리 밑으로 database가 각각 디렉토리로 생성이 되고, 해당 디렉토리에 테이블이나 인덱스와 같은 오브젝트들이 파일형식으로 저장된다.</p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">그리고 또한 PostgreSQL(DB)는 테이블스페이스를 지원한다. 테이블스페이스의 생성을 위해 특정 디렉토리를 지정하고 테이블스페이스를 생성하면, 해당 경로가 pg_tblspc 디렉토리 밑에 심볼릭 링크로 걸리게 되고, 이 링크를 통해 디렉토리의 파일들을 조회할 수 있다.</p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><ul class="lecture_ul" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; list-style-position: initial; list-style-image: initial; width: 821px; padding: 1px 0px 3px; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum; font-size: 15px;"><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><span style="box-sizing: border-box; font-weight: 700;">[그림] data Directory Layout</span></li><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><a href="http://www.gurubee.net/imgs/postgresql/basic/3.4.4.jpg" rel="lightbox" style="box-sizing: border-box; background-color: transparent; color: rgb(51, 122, 183);"><img alt="PostgreSQL Configuration 구성" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.gurubee.net%2Fimgs%2Fpostgresql%2Fbasic%2F3.4.4.jpg" style="box-sizing: border-box; border: none; vertical-align: middle; max-width: 90%;"></a></li></ul><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">아래와 같이 psql로 접속하여 각 database에 대한 oid값을 확인해 볼 수 있다.</p><ul class="lecture_ul" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; list-style-position: initial; list-style-image: initial; width: 821px; padding: 1px 0px 3px; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum; font-size: 15px;"><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><span style="box-sizing: border-box; font-weight: 700;">[그림] database에 대한 oid 확인화면</span></li><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><a href="http://www.gurubee.net/imgs/postgresql/basic/3.4.5.jpg" rel="lightbox" style="box-sizing: border-box; background-color: transparent; color: rgb(51, 122, 183);"><img alt="PostgreSQL Configuration 구성" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.gurubee.net%2Fimgs%2Fpostgresql%2Fbasic%2F3.4.5.jpg" style="box-sizing: border-box; border: none; vertical-align: middle; max-width: 90%;"></a></li></ul><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><h4 style="box-sizing: border-box; font-family: 나눔고딕, NanumGothic, 돋움, Dotum; line-height: normal; color: rgb(10, 36, 106); margin-top: 18px; margin-bottom: 10px; font-size: 16pt; padding: 0px;">주요 환경설정 파일</h4><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><h6 style="box-sizing: border-box; font-family: 나눔고딕, NanumGothic, 돋움, Dotum; line-height: normal; color: black; margin-top: 8px; margin-bottom: 10px; font-size: 14px; padding: 0px;">원격접속을 위한 클라이언트 인증설정 파일 : pg_hba.conf</h6><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">원격지에서의 접속을 위한 클라이언트 인증에 대한 설정을 지정해주는 파일로 Type, Database, User, Address, Method 로 구분하여 설정하게 된다.</p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">예를 들어서 localhost와 특정IP 대역으로부터의 모든 접속은 반드시 패드워드를 입력해야 접속이 가능하도록 설정하고 싶을 경우 아래와 같이 설정해줄 수 있다.</p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">혹은 모든 대역에 대하여 접속이 가능하도록 하려면, ADDRESS 부분에 대하여 0.0.0.0/0 으로 설정 해주면 된다.</p><ul class="lecture_ul" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; list-style-position: initial; list-style-image: initial; width: 821px; padding: 1px 0px 3px; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum; font-size: 15px;"><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><span style="box-sizing: border-box; font-weight: 700;">[그림] pg_hba.conf 파일화면</span></li><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><a href="http://www.gurubee.net/imgs/postgresql/basic/3.4.6.jpg" rel="lightbox" style="box-sizing: border-box; background-color: transparent; color: rgb(51, 122, 183);"><img alt="PostgreSQL pg_hba.conf 파일화면" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.gurubee.net%2Fimgs%2Fpostgresql%2Fbasic%2F3.4.6.jpg" style="box-sizing: border-box; border: none; vertical-align: middle; max-width: 90%;"></a></li></ul><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">Pg_hba.conf 파일은 수정 후에 PostgreSQL(DB)에 대하여 reload 명령을 수행해줘야 적용이 된다.</p><div style="box-sizing: border-box; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum; font-size: 15px;"><div id="highlighter_767596" class="syntaxhighlighter sql" style="box-sizing: border-box; width: 821px; margin: 1em 0px !important; position: relative !important; overflow: auto !important; font-size: 1em !important;"><div class="toolbar" style="box-sizing: content-box !important; border-radius: 0px !important; background: rgb(108, 226, 108) !important; border: none !important; bottom: auto !important; float: none !important; height: 11px !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: absolute !important; right: 1px !important; top: 1px !important; vertical-align: baseline !important; width: 11px !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 10px !important; min-height: auto !important; z-index: 10 !important; color: white !important;"><span style="box-sizing: border-box;"><a href="http://www.gurubee.net/lecture/2917#" class="toolbar_item command_help help" style="box-sizing: content-box !important; background: none !important; color: white !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 1px 0px 0px !important; position: static !important; right: auto !important; text-align: center !important; top: auto !important; vertical-align: baseline !important; width: auto !important; font-size: 1em !important; min-height: auto !important; display: block !important;">?</a></span></div><table border="0" cellpadding="0" cellspacing="0" style="border-spacing: 0px; border-collapse: collapse; line-height: 14pt; margin: 5px; width: 804px; font-size: 14px; list-style: none; box-sizing: content-box !important; background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; min-height: auto !important;"><tbody style="box-sizing: content-box !important; border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; font-size: 1em !important; min-height: auto !important;"><tr style="list-style: none; box-sizing: content-box !important; font-size: 1em !important; line-height: 1.1em !important; border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; min-height: auto !important;"><td class="gutter" style="list-style: none; box-sizing: content-box !important; padding: 0px !important; border: 0px !important; vertical-align: baseline !important; font-size: 1em !important; line-height: 1.1em !important; border-radius: 0px !important; background: none !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; width: auto !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; min-height: auto !important; color: rgb(175, 175, 175) !important;"><div class="line number1 index0 alt2" style="box-sizing: content-box !important; width: auto !important; height: auto !important; overflow: visible !important; border-radius: 0px !important; background-image: none !important; background-position: initial !important; background-size: initial !important; background-repeat: initial !important; background-attachment: initial !important; background-origin: initial !important; background-clip: initial !important; border-width: 0px 3px 0px 0px !important; border-top-style: initial !important; border-right-style: solid !important; border-bottom-style: initial !important; border-left-style: initial !important; border-top-color: initial !important; border-right-color: rgb(108, 226, 108) !important; border-bottom-color: initial !important; border-left-color: initial !important; border-image: initial !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px 0.5em 0px 1em !important; position: static !important; right: auto !important; text-align: right !important; top: auto !important; vertical-align: baseline !important; font-size: 1em !important; min-height: auto !important; white-space: pre !important;">1</div></td><td class="code" style="list-style: none; width: 770px; box-sizing: content-box !important; padding: 0px !important; border: 0px !important; vertical-align: baseline !important; overflow: visible !important; background: none !important; font-size: 1em !important; line-height: 1.1em !important; border-radius: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; margin: 0px !important; outline: 0px !important; position: static !important; right: auto !important; top: auto !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; min-height: auto !important;"><div class="container" style="box-sizing: content-box !important; padding: 0px !important; margin: 0px !important; width: auto !important; border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: relative !important; right: auto !important; top: auto !important; vertical-align: baseline !important; font-size: 1em !important; min-height: auto !important;"><div class="line number1 index0 alt2" style="box-sizing: content-box !important; width: auto !important; height: auto !important; overflow: visible !important; border-radius: 0px !important; background-image: none !important; background-position: initial !important; background-size: initial !important; background-repeat: initial !important; background-attachment: initial !important; background-origin: initial !important; background-clip: initial !important; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; font-size: 1em !important; min-height: auto !important; white-space: pre !important;"><code class="sql plain" style="box-sizing: content-box !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; padding: 0px !important; color: black !important; background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; min-height: auto !important;">#명령어 : pg_ctl reload –D $PGDATA</code></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><h6 style="box-sizing: border-box; font-family: 나눔고딕, NanumGothic, 돋움, Dotum; line-height: normal; color: black; margin-top: 8px; margin-bottom: 10px; font-size: 14px; padding: 0px;">PostgreSQL(DB) 튜닝과 환경설정 파일 : postgresql.conf</h6><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">PostgreSQL(DB)에 대한 환경설정 값에 대해서 postgresql.conf 파일을 이용하여 설정할 수 있다. PostgreSQL(DB)의 port 정보나 address(IP) 값을 설정해 줄 수 있으며 DB에 대한 튜닝 또한 이 파일에서 관리할 수 있다.</p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;">설정 값에 따라 다르지만 되도록 해당 파일을 수정 후에는 PostgreSQL(DB)에 대하여 restart를 진행해 줘야 한다.</p><p style="box-sizing: border-box; margin-top: 10px; margin-bottom: 10px; font-size: 14px; line-height: 14pt; list-style: none; padding: 2px 7px; text-indent: 1em; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum;"></p><ul class="lecture_ul" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; list-style-position: initial; list-style-image: initial; width: 821px; padding: 1px 0px 3px; color: rgb(51, 51, 51); font-family: 나눔고딕, NanumGothic, 돋움, Dotum; font-size: 15px;"><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><span style="box-sizing: border-box; font-weight: 700;">[그림] postgresql.conf 파일화면</span></li><li style="box-sizing: border-box; list-style: none; margin: 0px; padding: 2px 0px 1px 10px; font-size: 14px; line-height: 16pt;"><a href="http://www.gurubee.net/imgs/postgresql/basic/3.4.7.jpg" rel="lightbox" style="box-sizing: border-box; background-color: transparent; color: rgb(35, 82, 124); text-decoration-line: underline; outline: -webkit-focus-ring-color auto 5px; outline-offset: -2px;"><img alt="PostgreSQL postgresql.conf 파일화면" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fwww.gurubee.net%2Fimgs%2Fpostgresql%2Fbasic%2F3.4.7.jpg" style="box-sizing: border-box; border: none; vertical-align: middle; max-width: 90%;"></a></li><li></li></ul>
<!-- -->
]]>
카페 게시글
postgres DB
PostgreSQL(DB) 디렉토리 구조
생짜초보
추천 0
조회 196
20.02.22 23:10
댓글 0
다음검색
