Temat: phppgadmin
witam,
zainstalowałem phppgadmin do postgresa 8.3 na ubuntu, wszystko z repozytoriów i niestety wpisując adres w przeglądarce nie mam strony do zalogowania. Poprosze o pomoc w konfiguracji.
system: ubuntu 9.04 server, tylko cl
baza: postgres 8.3
pg_hba.conf
# Database administrative login by UNIX sockets
local all postgres ident sameuser
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
hostnossl all all 10.0.0.1/32 md5
host all all 10.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
postgresql.conf:
...
# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
port = 5432 # (change requires restart)
max_connections = 100
...
phppgadmin/config.inc.php
...
// Hostname or IP address for server. Use '' for UNIX domain socket.
// use 'localhost' for TCP/IP connection on this computer
$conf['servers'][0]['host'] = '';
// Database port on server (5432 is the PostgreSQL default)
$conf['servers'][0]['port'] = 5432;
// Database SSL mode
// Possible options: disable, allow, prefer, require
// To require SSL on older servers use option: legacy
// To ignore the SSL mode, use option: unspecified
$conf['servers'][0]['sslmode'] = 'allow';
// Change the default database only if you cannot connect to template1.
// For a PostgreSQL 8.1+ server, you can set this to 'postgres'.
$conf['servers'][0]['defaultdb'] = 'template1';
...