Differences between revisions 1 and 9 (spanning 8 versions)
Revision 1 as of 2008-06-20 08:19:06
Size: 245
Editor: 211
Comment:
Revision 9 as of 2012-11-03 10:55:50
Size: 812
Editor: 221
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: 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이 선호되는 이유?]]
 * [[http://dickey.xxx/mysql-is-done-it-s-the-postgres-age|MySQL is done, it's the Postgre Age]]
 * [[http://pypi.python.org/pypi/django-postgrespool|django-postgrespool]]
 * [[http://www.niwi.be/2012/10/09/postgresql-fulltextsearch-integration-with-django/|PostgreSQL full text search with Django]]

데이터 덤프 및 로드

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

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

One of the RelationalDatabase. OpenSource. PostgreSQL

http://www.postgresql.org/

관련정보

데이터 덤프 및 로드

pg_dump dbname > outfile
psql dbname < infile

각종 팁

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


CategoryProgram

PostgreSQL (last edited 2014-01-27 10:17:28 by 61)

web biohackers.net