Changes between Version 4 and Version 5 of oid/WorkLog/08-10-15


Ignore:
Timestamp:
Oct 15, 2008, 3:59:51 AM (17 years ago)
Author:
jazz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • oid/WorkLog/08-10-15

    v4 v5  
    1010{{{
    1111jazz@oceandb:~$ sudo apt-get install postgresql phppgadmin
     12jazz@oceandb:~$ sudo -u postgres psql template1
     13Welcome to psql 8.3.4, the PostgreSQL interactive terminal.
     14
     15Type:  \copyright for distribution terms
     16       \h for help with SQL commands
     17       \? for help with psql commands
     18       \g or terminate with semicolon to execute query
     19       \q to quit
     20
     21template1=# create user PG_USER with password '${PASSWORD}' createdb createuser;
     22CREATE ROLE
     23template1=# alter user postgres with password '${PASSWORD}';
     24ALTER ROLE
     25template1=# \q
     26jazz@oceandb:~$ sudo vi /etc/apache2/conf.d/phppgadmin
     27jazz@oceandb:~$ sudo apache2ctl restart
     28}}}
     29{{{
     30#!diff
     31--- /etc/apache2/conf.d/phppgadmin
     32+++ /etc/apache2/conf.d/phppgadmin
     33===
     34@@ -9,8 +9,8 @@
     35 order deny,allow
     36 deny from all
     37-allow from 127.0.0.0/255.0.0.0 ::1/128
     38-# allow from all
     39+# allow from 127.0.0.0/255.0.0.0 ::1/128
     40+allow from all
     41
     42 <IfModule mod_php5.c>
    1243}}}
    1344 * 把 PostgreSQL 資料庫 dump 出來