Diff for "PostgreSQL" - BioHackersNet

Differences between revisions 3 and 7 (spanning 4 versions)

관련정보

데이터 덤프 및 로드

pg_dump dbname > outfile
psql dbname < infile

각종 팁

-  ⇤ ← Revision 3 as of 2008-06-20 08:21:00 → 
  Size: 272
  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 6:
- * [http://groups.google.com/group/django-users/browse_thread/thread/1ea53f8cac79f82e Django에서 PostgreSQL이 선호되는 이유?]
+ * [[http://groups.google.com/group/django-users/browse_thread/thread/1ea53f8cac79f82e|Django에서 PostgreSQL이 선호되는 이유?]]
 * [[http://dickey.xxx/mysql-is-done-it-s-the-postgres-age|MySQL is done, it's the Postgre Age]]

데이터 덤프 및 로드

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

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