Than'k Mr.Aris
I''ve tried to set up pg_hba.conf and postgres.conf, and then execution
>psql -h 167.205.240.67 -- that is my IP Address server-- but still get
problem and gei message "could not connect to server : connection refuse,
is the server running on 167.205.240.67 and accepting TCP/IP connections on
port 5432", so what can i do?
pg_hba.conf
********************
.................
..................
TYPE DATABASE USER IP_ADRESS MASK
AUTH_TYPE
local all all 167.205.240.67
255.255.255.0 trust
...................
.................
postgesql.conf
*********************
..........
............
.........
##connections parameter
tcpip_socket=true
max_connection = 32
ssl=true
port=5432
hostname_lookup=false
show_source_port=false
................
............
config.inc.php in phpPgAdmin
************************
/* $Id: config.inc.php-dist,v 1.10 2002/06/04 18:24:50 killroyboy Exp $ */
// Set the name and version
$cfgProgName = "phpPgAdmin";
$cfgVersion = "2.4.2";
// The default database is used to connect to the database to check the
adv_auth
// This can actually be any database you currently have on your system. It
just
// needs _a_ database to connect and check the system tables.
$cfgDefaultDB = "template1";
// You should change the superuser if different from postgres
// This is just used to filter out the system functions when listing
$cfgSuperUser = "postgres";
// If you want to be able to view the contents and structure of the System
Catalog/Tables set this to true.
// If you are new to Postgres or are not familiar with the system tables, it
is suggested you leave this as false
$cfgSysTables = true;
// If you want the web interface to administer postgres user, set this as
true.
$cfgUserAdmin = true;
// If you want to enable reporting
$cfgReports = true;
// If you want to filter the databases to only the ones the user has created
or owns.
// This has no affect if the user is a superuser.
$cfgUserDatabases = true;
// Set this to true during development of phpPgAdmin
$cfgDebug = false;
// If you do NOT want to quote all relations, set this to false
$cfgQuotes = true;
// Maximum pages to display link in browse
$cfgMaxPages = 9;
// If you do not want to display the tables of a database in the left frame,
add it to this array
// This feature is very useful when you have a database that has many tables
and slowes down the load of the left frame.
// $cfgNoTables[] = "big_table";
/******************************** IMPORTANT SECURITY NOTICE
********************************
By default, Postgres does not check passwords through a local connection.
This is
a major security if connecting through a local unix socket with phpPgAdmin.
You
have a few options to close this security hole:
1. You can connect through a TCP connection (use the -i option to start
postgres)
- Set $cfgServers[*]['local'] = false;
- Edit your $PGDATA/pg_hba.conf file to accept connections from localhost
with password authentication
2. Edit your $PGDATA/pg_hba.conf file to use password authentication
through a
local connection.
********************************* IMPORTANT SECURITY NOTICE
*******************************/
// The $cfgServers array starts with $cfgServers[1]. Do not use
$cfgServers[0].
// You can disable a server config entry by setting host to ''.
$cfgServers[1]['local'] = false;
$cfgServers[1]['host'] = 'localhost';
$cfgServers[1]['port'] = '5432';
$cfgServers[1]['adv_auth'] = true;
$cfgServers[1]['user'] = ''; // if you are not using adv_auth, enter the
username to connect all the time
$cfgServers[1]['password'] = ''; // if you are not using adv_auth and a
password is required enter a password
$cfgServers[1]['only_db'] = ''; // if set to a db-name, only this db is
accessible
$cfgServers[2]['local'] = false;
$cfgServers[2]['host'] = '';
$cfgServers[2]['port'] = '5432';
$cfgServers[2]['adv_auth'] = true;
$cfgServers[2]['user'] = ''; // if you are not using adv_auth, enter the
username to connect all the time
$cfgServers[2]['password'] = ''; // if you are not using adv_auth and a
password is required enter a password
$cfgServers[2]['only_db'] = ''; // if set to a db-name, only this db is
accessible
$cfgServers[3]['local'] = false;
$cfgServers[3]['host'] = '';
$cfgServers[3]['port'] = '5432';
$cfgServers[3]['adv_auth'] = true;
$cfgServers[3]['user'] = ''; // if you are not using adv_auth, enter the
username to connect all the time
$cfgServers[3]['password'] = ''; // if you are not using adv_auth and a
password is required enter a password
$cfgServers[3]['only_db'] = ''; // if set to a db-name, only this db is
accessible
// If you have more than one server configured, you can set
$cfgServerDefault
// to any one of them to autoconnect to that server when phpPGAdmin is
started,
// or set it to 0 to be given a list of servers without logging in
// If you have only one server configured, $cfgServerDefault *MUST* be
// set to that server.
$cfgServerDefault = 1; // default server (0 = no default server)
$cfgServer = ''; // the selected server is copied here for easier access
unset($cfgServers[0]); // Since 0 = no server, $cfgServers[0] must not be
used
$cfgManualBase = "http://www.postgresql.org/idocs/index.php";
$cfgConfirm = true;
$cfgPersistentConnections = false;
// If you have a table with several thousands of records, you will want to
set this false.
$cfgCountRecs = true;
// If you want the fields alphabetized when inserting/editing
$cfgDoOrder = false;
$cfgBorder = "0";
$cfgThBgcolor = "#D3DCE3";
$cfgBgcolorOne = "#CCCCCC";
$cfgBgcolorTwo = "#DDDDDD";
$cfgMaxRows = 30;
$cfgMaxInputsize = "300px";
$cfgMaxTextAreaSize = "400px";
$cfgOrder = "ASC";
$cfgShowBlob = false;
$cfgShowSQL = true;
// Set the maximum characters in any given field to diplay in "browse"
mode - 0 is unlimited
$cfgMaxText = 255;
$cfgMember = "#CCCCFF";
$cfgNonMember = "#CCCC99";
$cfgMaxTries = 10;
// Set your language preferences here.
include("english.inc.php");
?>
best regards,
--devi munandar