close
Warning:
Can't synchronize with repository "(default)" (Unsupported version control system "svn": /usr/lib/python2.7/dist-packages/libsvn/_core.so: failed to map segment from shared object: Cannot allocate memory). Look in the Trac log for more information.
- Timestamp:
-
Oct 15, 2008, 4:31:32 AM (17 years ago)
- Author:
-
jazz
- Comment:
-
--
Legend:
- Unmodified
- Added
- Removed
- Modified
-
|
v7
|
v8
|
|
| 61 | 61 | postgres 2643 0.0 0.1 17864 1708 ? S Sep26 0:00 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data |
| 62 | 62 | # 從 /usr/local/pgsql/doc/index.html 可以得知版本為 8.0.3 |
| | 63 | [odb@ncor odb]$ sudo -u postgres /usr/local/pgsql/bin/pg_dumpall > ncor_pgsql.dumpall |
| | 64 | [odb@ncor odb]$ du -sh ncor_pgsql.dumpall |
| | 65 | 3.5M ncor_pgsql.dumpall |
| | 66 | }}} |
| | 67 | * 用 scp 拷貝到實驗主機,並用 psql 指令把 dump 結果復原到實驗主機上 |
| | 68 | {{{ |
| | 69 | jazz@oceandb:~$ sudo -u postgres psql template1 < ncor_pgsql.dumpall |
| 63 | 70 | }}} |
| 64 | 71 | |