= 2008-10-15 =

 * [http://www.lightbox.ca/pg2mysql.php pg2mysql converter (PostgreSQL to MySQL Converter)]
 * [http://packages.debian.org/etch/phppgadmin phpPGadmin] - 官方網站: http://phppgadmin.sf.net

== 備份聯合目錄 PostgreSQL 到實驗主機 ==

 * 安裝 PostgreSQL 與 phpPGadmin
   * [參考] [http://plog.longwin.com.tw/my_note-unix/2007/07/13/debian_postgresql_phppgadmin_2007 Debian Linux 架設 PostgreSQL + PhpPgAdmin]
{{{
jazz@oceandb:~$ sudo apt-get install postgresql phppgadmin
jazz@oceandb:~$ sudo -u postgres psql template1
Welcome to psql 8.3.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=# create user PG_USER with password '${PASSWORD}' createdb createuser;
CREATE ROLE
template1=# alter user postgres with password '${PASSWORD}';
ALTER ROLE
template1=# \q
jazz@oceandb:~$ sudo vi /etc/apache2/conf.d/phppgadmin
jazz@oceandb:~$ sudo apache2ctl restart
}}}
{{{
#!diff
--- /etc/apache2/conf.d/phppgadmin
+++ /etc/apache2/conf.d/phppgadmin
@@ -9,7 +9,7 @@
 order deny,allow
 deny from all
-allow from 127.0.0.0/255.0.0.0 ::1/128
-# allow from all
+# allow from 127.0.0.0/255.0.0.0 ::1/128
+allow from all

 <IfModule mod_php5.c>
}}}
 * 把 PostgreSQL 資料庫 dump 出來
   * 先查詢 PostgreSQL 版本: 7.3.21
{{{
[root@ncor root]# yum list
...略...
rh-postgresql                       i386   7.3.21-1                 update
rh-postgresql-contrib               i386   7.3.21-1                 update
rh-postgresql-devel                 i386   7.3.21-1                 update
rh-postgresql-docs                  i386   7.3.21-1                 update
rh-postgresql-jdbc                  i386   7.3.21-1                 update
rh-postgresql-libs                  i386   7.3.21-1                 update
rh-postgresql-pl                    i386   7.3.21-1                 update
rh-postgresql-python                i386   7.3.21-1                 update
rh-postgresql-server                i386   7.3.21-1                 update
rh-postgresql-tcl                   i386   7.3.21-1                 update
rh-postgresql-test                  i386   7.3.21-1                 update
}}}
   * [參考] [http://www.postgresql.org/docs/7.3/static/app-pg-dumpall.html PostgreSQL 7.3.21 Documentation pg_dumpall] 
   * [參考] [http://twpug.net/docs/postgresql-doc-8.0-zh_TW/backup.html PostgreSQL 8.0.0 中文文件 Chapter 22. 備份和恢復]