Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=4823232
By: nobody
Thanks for the prompt response. phpPgAdmin and postgres are on separate servers
conf/config.inc.php:
$conf['servers'][0]['desc'] = 'PostgreSQL';
$conf['servers'][0]['host'] = 'postgresl.ngdc.noaa.gov';
$conf['servers'][0]['port'] = 5432;
//tried "allow", "disable" as well
//$conf['servers'][0]['sslmode'] = 'allow';
$conf['servers'][0]['defaultdb'] = 'template1';
$conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump';
$conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';
$conf['servers'][0]['slony_support'] = false;
$conf['servers'][0]['slony_sql'] = '/usr/share/pgsql';
$conf['autocomplete'] = 'default on';
$conf['extra_login_security'] = false;
$conf['owned_only'] = false;
$conf['show_comments'] = true;
$conf['show_advanced'] = false;
$conf['show_system'] = false;
$conf['show_reports'] = true;
$conf['owned_reports_only'] = false;
$conf['min_password_length'] = 1;
$conf['left_width'] = 200;
$conf['theme'] = 'default';
$conf['show_oids'] = false;
$conf['max_rows'] = 30;
$conf['max_chars'] = 50;
$conf['use_xhtml'] = false;
$conf['help_base'] = 'http://www.postgresql.org/docs/%s/interactive/';
$conf['version'] = 17;
pg_hba.conf:
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 140.172.179.24/32 md5
# IPv6 local connections:
host all all ::1/128 trust
host all all 140.172.179.24/32 md5
host grid all 140.172.179.24 255.255.255.255 md5
Anything else that will help?
Thanks!
-- john
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=115884
|
