Changes between Version 7 and Version 8 of oid/WorkLog/08-10-15

Timestamp:

Oct 15, 2008, 4:31:32 AM (16 years ago)

Author:

jazz

Comment:

--

oid/WorkLog/08-10-15

@@ -61 +61 @@
 postgres  2643  0.0  0.1 17864 1708 ?        S    Sep26   0:00 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
 # 從 /usr/local/pgsql/doc/index.html 可以得知版本為 8.0.3
+[odb@ncor odb]$ sudo -u postgres /usr/local/pgsql/bin/pg_dumpall > ncor_pgsql.dumpall
+[odb@ncor odb]$ du -sh ncor_pgsql.dumpall
+3.5M    ncor_pgsql.dumpall
+}}}
+ * 用 scp 拷貝到實驗主機，並用 psql 指令把 dump 結果復原到實驗主機上
+{{{
+jazz@oceandb:~$ sudo -u postgres psql template1 < ncor_pgsql.dumpall
 }}}