<![CDATA[
<div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/e7412965391ed3f88a40ff30a9f0e02952f222ef" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/e7412965391ed3f88a40ff30a9f0e02952f222ef" data-origin-width="381" data-origin-height="66"></div><p>-복구 명령어</p><p>pg_dump -U scott -d testdb -t scott.emp -t scott.dept -Fc -f backup.dump</p><p>pg_restore -U scott -d testdb -n scott -t emp backup.dump</p><p>pg_restore -U scott -d testdb -n scott -t dept backup.dump</p><p> </p><p>- 확인</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/0162e24e0a088eb12919a4567c7b3427df55c7a2" class="txc-image" width="597" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/0162e24e0a088eb12919a4567c7b3427df55c7a2" data-origin-width="826" data-origin-height="536"></div>
<!-- -->
]]>
카페 게시글
10.PostgreSQL 수업
Re: 오늘의 마지막 문제.scott 계정의 emp 테이블과 dept 테이블을 모두 다 drop 하고 다시 복구하시오
다음검색
