Diff for "PostgreSQL" - BioHackersNet

Differences between revisions 1 and 6 (spanning 5 versions)

관련정보

데이터 덤프 및 로드

pg_dump dbname > outfile
psql dbname < infile

각종 팁

-  ⇤ ← Revision 1 as of 2008-06-20 08:19:06 → 
  Size: 245
  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 1:
-One of the relational [Database]. OpenSource. WikiPedia:PostgreSQL
+One of the RelationalDatabase. OpenSource. WikiPedia:PostgreSQL

http://www.postgresql.org/
-Line 4:
+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이 선호되는 이유?]]

데이터 덤프 및 로드

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

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