Diff for "PostgreSQL" - BioHackersNet

Differences between revisions 5 and 7 (spanning 2 versions)

관련정보

데이터 덤프 및 로드

pg_dump dbname > outfile
psql dbname < infile

각종 팁

-  ⇤ ← Revision 5 as of 2011-12-12 10:02:35 → 
  Size: 365
  Editor: 211
  Comment:
+   ← Revision 7 as of 2012-06-06 12:29:49 → ⇥
  Size: 607
  Editor: 211
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 7:
+ * [[http://dickey.xxx/mysql-is-done-it-s-the-postgres-age|MySQL is done, it's the Postgre Age]]
-Line 15:
+Line 16:
+각종 팁
 * pg_dump 시 -F c 옵션을 썼다면 psql로 로드되지 않는다 pg_restore로 해야함. 10배 정도 용량 절약효과