Diff for "PostgreSQL" - BioHackersNet

Differences between revisions 4 and 6 (spanning 2 versions)

관련정보

데이터 덤프 및 로드

pg_dump dbname > outfile
psql dbname < infile

각종 팁

-  ⇤ ← Revision 4 as of 2011-08-03 11:00:36 → 
  Size: 274
  Editor: localhost
  Comment: converted to 1.6 markup
+   ← 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 8:
+데이터 덤프 및 로드

{{{
pg_dump dbname > outfile
psql dbname < infile
}}}

각종 팁
 * pg_dump 시 -F c 옵션을 썼다면 psql로 로드되지 않는다 pg_restore로 해야함. 10배 정도 용량 절약효과