https://dbstudy.co.kr/w/index.php?action=history&feed=atom&title=Postgresql_%EC%84%A4%EC%B9%98_%ED%9B%84_DBA_%EC%9E%91%EC%97%85 2026-05-08T15:30:56Z 이 문서의 편집 역사 MediaWiki 1.39.10 https://dbstudy.co.kr/w/index.php?title=Postgresql_%EC%84%A4%EC%B9%98_%ED%9B%84_DBA_%EC%9E%91%EC%97%85&diff=876&oldid=prev 2025-06-29T14:11:28Z

<p><span dir="auto"><span class="autocomment">PostgreSQL 설치 후 DBA 체크리스트</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ko"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 이전 판</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2025년 6월 29일 (일) 23:11 판</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">1번째 줄:</td> <td colspan="2" class="diff-lineno">1번째 줄:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>= PostgreSQL 설치 후 DBA 체크리스트 =</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>= PostgreSQL 설치 후 DBA 체크리스트 =</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* [https://devcafe.co.kr/w/WSL<del style="font-weight: bold; text-decoration: none;">| </del>윈도우에 WSL로 간편하게 설치하기 ]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* [https://devcafe.co.kr/w/WSL 윈도우에 WSL로 간편하게 설치하기 ]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== 1. 서비스 상태 확인 ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== 1. 서비스 상태 확인 ==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* PostgreSQL 서비스가 정상적으로 실행 중인지 확인합니다.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* PostgreSQL 서비스가 정상적으로 실행 중인지 확인합니다.</div></td></tr> </table>

Postgresql https://dbstudy.co.kr/w/index.php?title=Postgresql_%EC%84%A4%EC%B9%98_%ED%9B%84_DBA_%EC%9E%91%EC%97%85&diff=875&oldid=prev 2025-06-29T14:11:03Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ko"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 이전 판</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2025년 6월 29일 (일) 23:11 판</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">1번째 줄:</td> <td colspan="2" class="diff-lineno">1번째 줄:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>= PostgreSQL 설치 후 DBA 체크리스트 =</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>= PostgreSQL 설치 후 DBA 체크리스트 =</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* [https://devcafe.co.kr/w/WSL| 윈도우에 WSL로 간편하게 설치하기 ]</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== 1. 서비스 상태 확인 ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== 1. 서비스 상태 확인 ==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* PostgreSQL 서비스가 정상적으로 실행 중인지 확인합니다.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* PostgreSQL 서비스가 정상적으로 실행 중인지 확인합니다.</div></td></tr> </table>

Postgresql https://dbstudy.co.kr/w/index.php?title=Postgresql_%EC%84%A4%EC%B9%98_%ED%9B%84_DBA_%EC%9E%91%EC%97%85&diff=874&oldid=prev 2025-06-29T14:00:12Z

<p><span dir="auto"><span class="autocomment">3. 데이터베이스와 사용자 생성</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ko"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 이전 판</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2025년 6월 29일 (일) 23:00 판</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l30">30번째 줄:</td> <td colspan="2" class="diff-lineno">30번째 줄:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>CREATE DATABASE mydb;  </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>CREATE DATABASE mydb;  </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-- 유저 생성  </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-- 유저 생성  </div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>CREATE USER <del style="font-weight: bold; text-decoration: none;">myuser </del>WITH ENCRYPTED PASSWORD &#039;mypassword&#039;;  </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>CREATE USER <ins style="font-weight: bold; text-decoration: none;">dbstudy </ins>WITH ENCRYPTED PASSWORD &#039;mypassword&#039;;  </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-- 권한 부여  </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-- 권한 부여  </div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>GRANT ALL PRIVILEGES ON DATABASE mydb TO <del style="font-weight: bold; text-decoration: none;">myuser</del>;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>GRANT ALL PRIVILEGES ON DATABASE mydb TO <ins style="font-weight: bold; text-decoration: none;">dbstudy</ins>;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/source&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/source&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> </table>

Postgresql https://dbstudy.co.kr/w/index.php?title=Postgresql_%EC%84%A4%EC%B9%98_%ED%9B%84_DBA_%EC%9E%91%EC%97%85&diff=873&oldid=prev 2025-06-29T13:33:24Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ko"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 이전 판</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2025년 6월 29일 (일) 22:33 판</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l76">76번째 줄:</td> <td colspan="2" class="diff-lineno">76번째 줄:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>sudo systemctl enable postgresql</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>sudo systemctl enable postgresql</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/source&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/source&gt;</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[분류:postgresql]]</ins></div></td></tr> </table>

Postgresql https://dbstudy.co.kr/w/index.php?title=Postgresql_%EC%84%A4%EC%B9%98_%ED%9B%84_DBA_%EC%9E%91%EC%97%85&diff=872&oldid=prev 2025-06-29T13:32:31Z

<p>새 문서: = PostgreSQL 설치 후 DBA 체크리스트 = == 1. 서비스 상태 확인 == * PostgreSQL 서비스가 정상적으로 실행 중인지 확인합니다. &lt;source lang=sql&gt; sudo systemctl status postgresql &lt;/source&gt; == 2. 데이터베이스 접속 및 기본 설정 == * 기본 postgres 계정으로 데이터베이스에 접속합니다. &lt;source lang=sql&gt; sudo -u postgres psql &lt;/source&gt; * superuser 비밀번호를 설정합니다. &lt;source lang=sql&gt; \password postgres &lt;/source...</p> <p><b>새 문서</b></p><div><br /> = PostgreSQL 설치 후 DBA 체크리스트 =<br /> <br /> == 1. 서비스 상태 확인 ==<br /> * PostgreSQL 서비스가 정상적으로 실행 중인지 확인합니다.<br /> &lt;source lang=sql&gt;<br /> sudo systemctl status postgresql<br /> &lt;/source&gt;<br /> <br /> == 2. 데이터베이스 접속 및 기본 설정 ==<br /> * 기본 postgres 계정으로 데이터베이스에 접속합니다.<br /> &lt;source lang=sql&gt;<br /> sudo -u postgres psql<br /> &lt;/source&gt;<br /> <br /> * superuser 비밀번호를 설정합니다.<br /> &lt;source lang=sql&gt;<br /> \password postgres<br /> &lt;/source&gt;<br /> <br /> * 필요 시 PostgreSQL 버전을 확인합니다.<br /> &lt;source lang=sql&gt;<br /> SELECT version();<br /> &lt;/source&gt;<br /> <br /> == 3. 데이터베이스와 사용자 생성 ==<br /> * 서비스용 데이터베이스와 전용 사용자를 생성합니다.<br /> &lt;source lang=sql&gt;<br /> -- database 생성 <br /> CREATE DATABASE mydb; <br /> -- 유저 생성 <br /> CREATE USER myuser WITH ENCRYPTED PASSWORD &#039;mypassword&#039;; <br /> -- 권한 부여 <br /> GRANT ALL PRIVILEGES ON DATABASE mydb TO myuser;<br /> &lt;/source&gt;<br /> <br /> == 4. 외부 접속 허용 및 방화벽 설정 ==<br /> &lt;source lang=sql&gt;<br /> /etc/postgresql/{{버전}}/main/pg_hba.conf 파일에서 연결 정책 설정<br /> /etc/postgresql/{{버전}}/main/postgresql.conf 파일에서 아래 내용 수정 (필요시)<br /> listen_addresses = &#039;*&#039;<br /> &lt;/source&gt;<br /> * 방화벽에서 5432 포트 개방<br /> &lt;source lang=sql&gt;<br /> sudo ufw allow 5432/tcp<br /> &lt;/source&gt;<br /> <br /> == 5. 인코딩과 로케일 설정 확인 ==<br /> <br /> * 생성된 DB의 인코딩과 로케일을 확인합니다.<br /> \l<br /> UTF8, ko_KR.UTF-8 등을 사용하는지 확인합니다.<br /> <br /> == 6. 기본 보안 설정 점검 ==<br /> # 불필요한 계정/DB 삭제<br /> # 패스워드 정책 적용 및 주기적 변경<br /> # 접근 권한 최소화<br /> <br /> == 7. 백업 및 복구 환경 구축 ==<br /> # 주기적 백업 스크립트 작성 및 테스트<br /> &lt;source lang=sql&gt;<br /> sudo -u postgres pg_dumpall &gt; /var/backups/pg_backup.sql<br /> &lt;/source&gt;<br /> <br /> * 복구 테스트도 실제로 수행<br /> <br /> == 8. 모니터링 및 로그 관리 설정 ==<br /> <br /> * 로그 파일 위치 및 레벨 확인 (postgresql.conf)<br /> * 필요 시 로그로테이션 설정<br /> <br /> == 9. 자동 시작 및 서비스 점검 ==<br /> <br /> * 시스템 재부팅 시 자동 기동 확인<br /> &lt;source lang=sql&gt;<br /> sudo systemctl enable postgresql<br /> &lt;/source&gt;</div>

Postgresql