Diff for "PostgreSQL" - BioHackersNet

Differences between revisions 5 and 6

관련정보

데이터 덤프 및 로드

pg_dump dbname > outfile
psql dbname < infile

각종 팁

-  ⇤ ← Revision 5 as of 2011-12-12 10:02:35 → 
  Size: 365
  Editor: 211
  Comment:
+   ← Revision 6 as of 2011-12-13 07:57:06 → ⇥
  Size: 509
  Editor: 211
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 15:
+각종 팁
 * pg_dump 시 -F c 옵션을 썼다면 psql로 로드되지 않는다 pg_restore로 해야함. 10배 정도 용량 절약효과