close
Warning:
Can't synchronize with repository "(default)" (Unsupported version control system "svn": /usr/lib/python2.7/dist-packages/libsvn/_fs.so: failed to map segment from shared object: Cannot allocate memory). Look in the Trac log for more information.
2008-10-15
備份聯合目錄 PostgreSQL 到實驗主機
- 安裝 PostgreSQL 與 phpPGadmin
- [參考] 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
-
|
|
|
9 | 9 | order deny,allow |
10 | 10 | deny from all |
11 | | allow from 127.0.0.0/255.0.0.0 ::1/128 |
12 | | # allow from all |
| 11 | # allow from 127.0.0.0/255.0.0.0 ::1/128 |
| 12 | allow from all |
13 | 13 | |
14 | 14 | <IfModule mod_php5.c> |
- 把 PostgreSQL 資料庫 dump 出來
Download in other formats: