About PostgreSql 8.0 |
尚未結案
|
powmien
初階會員 發表:27 回覆:80 積分:41 註冊:2004-10-20 發送簡訊給我 |
|
juneo
高階會員 發表:103 回覆:190 積分:118 註冊:2004-05-13 發送簡訊給我 |
|
powmien
初階會員 發表:27 回覆:80 積分:41 註冊:2004-10-20 發送簡訊給我 |
|
juneo
高階會員 發表:103 回覆:190 積分:118 註冊:2004-05-13 發送簡訊給我 |
pgadminⅢ 跟phppgadmin 不能說誰好不好,
應該是看你習慣怎麼用
有寫網頁 PHP+ Mysql 也常常會用到phpMyAdmin 它跟phppgadmin 是一樣的 從我的感覺來說
pgadminⅢ 是WIN IDE介面,有中文的版本,設定上比較簡單,但是很多功能並沒有,例如....備份資料庫 phpMyAdmin(For MySql) 它跟phppgadmin 事實上應該一樣吧,phppgadmin 我沒用的很透徹,phpMyAdmin倒是用很久了
我用phpMyAdmin跟你解說
1.WEB介面 操作簡單
2.PHP程式 好修改,偶而會改改它的介面比較適合自己用
3.全功能 ^^ 你用的到的功能都有 pgadminⅢ 我用在區域網路上,phpMyAdmin用在外出或者網際網路上
通常phpMyAdmin(For MySql) & phppgadmin 是需要設定config.inc.php這各檔案,以下是安裝說明^^
檔案路徑 phpPgAdmin\install. 4. If you run your PHP installation in safe mode, in order that the database
dump feature can work correctly, you need to set the 'safe_mode_allowed_env_vars'
php.ini variable to include the PGPASSWORD and PGUSER environmental variables
and the safe_mode_exec_dir to include /usr/bin (or wherever the pg_dump
binaries are found).
eg. safe_mode_allowed_env_vars = PHP_,PGPASSWORD,PGUSER
safe_mode_exec_dir = /usr/bin
Given that you usually don't want to allow everything in /usr/bin to
be executed, you might want to copy the pg_dump and pg_dumpall utilities
to a directory by themselves.
Also, you will need to ensure that your 'pg_dump' and 'pg_dumpall' utilities
are executable by the PHP process, if you want dump support in phpPgAdmin. 5. Enable the statistics collector in PostgreSQL. phpPgAdmin will display
table and index performance and usage statistics if you have enabled the
PostgreSQL statistics collector. To enable the collector, uncomment the
following lines in your postgresql.conf and enable them: stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = true 6. Browse to the phpPgAdmin installation using a web browser. You might
need cookies enabled for phpPgAdmin to work. 7. IMPORTANT - SECURITY PostgreSQL by default does not require you to use a password to log in.
We STRONGLY recomment that you enable md5 passwords for local connections
in your pg_hba.conf, and set a password for the default superuser account. Due to the large number of phpPgAdmin installations that have not set
passwords on local connections, there is now a configuration file
option called 'extra_login_security', which is TRUE by default. While
this option is enabled, you will be unable to log in to phpPgAdmin as
the 'root', 'administrator', 'pgsql' or 'postgres' users and empty passwords
will not work.
Once you are certain you have properly secured your database server, you
can then disable 'extra_login_security' so that you can log in as your
database administrator using the administrator password. 數學 程式 經驗=不懂^^
|
juneo
高階會員 發表:103 回覆:190 積分:118 註冊:2004-05-13 發送簡訊給我 |
--------------------這是分隔線------------------------------------
檔案路徑 phpPgAdmin\conf\config.inc.php
// Display name for the server on the login screen
$conf['servers'][0]['desc'] = 'PostgreSQL'; // Hostname or IP address for server. Use '' for UNIX domain socket.
$conf['servers'][0]['host'] = ''; // Database port on server (5432 is the PostgreSQL default)
$conf['servers'][0]['port'] = 5432; // Change the default database only if you cannot connect to template1
$conf['servers'][0]['defaultdb'] = 'template1'; // Specify the path to the database dump utilities for this server.
// You can set these to '' if no dumper is available.
$conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump';
$conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall'; // Example for a second server
//$conf['servers'][1]['desc'] = 'Test Server';
//$conf['servers'][1]['host'] = '192.168.0.1';
//$conf['servers'][1]['port'] = 5432;
//$conf['servers'][1]['defaultdb'] = 'template1';
//$conf['servers'][1]['pg_dump_path'] = 'c:/cygwin/bin/pg_dump.exe';
//$conf['servers'][1]['pg_dumpall_path'] = ''; ---------------又是分隔線---------------------------
如果還不能解決你的問題,請將錯誤畫面貼上比較能夠確切命中問題 數學 程式 經驗=不懂^^
|
powmien
初階會員 發表:27 回覆:80 積分:41 註冊:2004-10-20 發送簡訊給我 |
|
juneo
高階會員 發表:103 回覆:190 積分:118 註冊:2004-05-13 發送簡訊給我 |
本站聲明 |
1. 本論壇為無營利行為之開放平台,所有文章都是由網友自行張貼,如牽涉到法律糾紛一切與本站無關。 2. 假如網友發表之內容涉及侵權,而損及您的利益,請立即通知版主刪除。 3. 請勿批評中華民國元首及政府或批評各政黨,是藍是綠本站無權干涉,但這裡不是政治性論壇! |